Source data assumed running in A1 down
In B1: =IF(A1="","",IF(COUNTIF(A$1:A1,A1)1,"",ROW()))
Copy B1 down to cover the max expected extent of source data, say down to
B200?

Then in C1:
=IF(COLUMNS($A:A)COUNT($B:$B),"",INDEX($A:$A,SMAL L($B:$B,COLUMNS($A:A))))
Copy C1 across to cover the max expected number of unique items, eg across
to Z1?. C1 across returns the results you seek. Success? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Novice Lee" wrote:
Is there a way to compare numbers in a column and return the numbers once.
Example:
a b c d e f
300 300 310 312 400 411
310
300
312
411
400
400
400

Thanks