Creat Filter List

  • Thread starter Thread starter Nasir Naqvi
  • Start date Start date
N

Nasir Naqvi

Hi,

Kindly suggest how to creat filter list to avoid from same or repeatd entries in a column.

Example

Column "A" Column "B" (Filter List)
RB000001009 RB000001009
RB000001009 RB000001023
RB000001023 RB000001036
RB000001023 RB000001044
RB000001036 RB000001023
RB000001044
RB000001044
RB000001044
RB000001023



EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
 
Select Advanc Filter from Data-Filter menu
Active Copy to other location.
Enter/Select Proper range to 'List Range' box
Enter/Select output cell address to "Copy to" box
Active 'Unique Records Only'
and click ok


pls do rate for this answer
 
One way if you want it dynamically extracted as col A is updated ..

Assuming source data running in A2 down ..

Put in B2:
=IF(A2="","",IF(COUNTIF($A$2:A2,A2)>1,"",ROW()))

Put in C2:
=IF(ROW(A1)>COUNT(B:B),"",INDEX(A:A,SMALL(B:B,ROW(A1))))

Select B2:C2, copy down to cover the max expected extent of source data.
Hide away col B. Col returns the list of uniques in col A, with lines all
neatly bunched at the top
 
Back
Top