Creat Filter List

[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

 

[Guest]

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

 

[Max]

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

 

[Nasir Naqvi]

Thanks, I got my answer from your reply

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com