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
---
"Novice Lee" wrote:
insted of doing the whole column how can I get it do ranges of numbers like

A4:A28, A31:A55, A58:A82, etc.....