Another simpler? option to frame it up dynamically, using non-array formulas
Assume your source data is in A2 down
In B2: =IF(A2="","",IF(COUNTIF(A$2:A2,A2)1,"",ROW()))
In C2: =IF(ROWS($1:1)COUNT(B:B),"",INDEX(A:A,SMALL(B:B,R OWS($1:1))))
Copy B2:C2 down to cover the max expected extent of source data, eg down to
C200? Hide/minimize col B. Col C will auto-return the list of uniques from
col A as the data in col A changes. Voila? hit the YES below
--
Max
Singapore
---
"Maracay" wrote:
Hi Guys

I have a column (A) with different concepts repeated several times, what I
want is to show those concepts 1 time in column B, ex.

Column A Column B
Car Car
Bike Bike
Car Bus
Bus Airplane
Bus
Car
Car
Bus
Bike
Bike
Airplane


Thanks