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

"Nasir Naqvi" wrote:

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