.. anything else that I could try?
With your source data as posted assumed in A2:B2 down
In C2:
=IF(A2="","",IF(COUNTIF(A$2:A2,A2)1,"",ROW()))
In D2:
=IF(ROWS($1:1)COUNT(C:C),"",INDEX(A:A,SMALL(C:C,R OWS($1:1))))
Copy C2:D2 down to the last row of data in col A. Col D extracts the uniques
list of the tel nos in col A.
Then, to compare the uniques list in col D with the source data in col B
In E2:
=IF(D2="","",IF(COUNTIF(B:B,D2),ROW(),""))
In F2:
=IF(ROWS($1:1)COUNT(E:E),"",INDEX(D:D,SMALL(E:E,R OWS($1:1))))
Copy E2:F2 down to the same extent. Col F will extract the desired uniques
list of tel nos in col A which are found in col B, with all results neatly
packed at the top.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
---