Another way to extract the uniques list dynamic in another sheet using simpler non-array formulas .. Source data in Sheet1's col C (file_name), running in C2 down In another sheet, Put in A2: =IF(Sheet1!C2="","",IF(COUNTIF(Sheet1!$C$2:C2,Sheet1!C2)>1,"",ROW())) Leave A1 blank In B2: =IF(ROW(A1)>COUNT(A:A),"",INDEX(Sheet1!C:C,SMALL(A:A,ROW(A1)))) Select A2:B2, fill down to the max expected extent of data in Sheet1's col C. Hide away col A. The uniques list of file_names will be extracted in col B, all neatly bunched at the top. -- Max Singapore http://savefile.com/project... xdemechanik ---
- Kelly Atkinson
The everything parent's guide to tantrums: the only book you need to prevent outbursts, avoid public scenes, and help your child stay calm - http://www.goodreads.com/review...