Compare column of number

  • Thread starter Thread starter Novice Lee
  • Start date Start date
N

Novice Lee

Hello,
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
 
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,SMALL($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
 
insted of doing the whole column how can I get it do ranges of numbers like

A4:A28, A31:A55, A58:A82, etc.....
 
Here's how, an example for > A4:A28 ..

In B4: =IF(A4="","",IF(COUNTIF(A$4:A4,A4)>1,"",ROW()))
Copy down to B28

In C4
=IF(COLUMNS($A:A)>COUNT($B$4:$B$28),"",INDEX($A:$A,SMALL($B$4:$B$28,COLUMNS($A:A))))
Copy across as far as required to cover the max expected number of unique
items from the source range, say to C20?
Success? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
 
Back
Top