Extracting non-repeating data

Y

yshridhar

How to extract non-repeating data items from a data (in column)?
Thank you
Sridhar
 
M

Muhammed Rafeek M

If you want extract Unique data from ur data list, Select data list and go
Data->Filter->Advance Filter. You will get one dialogbox,
Select 'Copy to another location', select proper range in List range column,
and select copy to column and activate "Unique records only" then Click OK



please do rate.
 
Y

yshridhar

Thanks alot.... Mr. Rafeek
Sridhar


Muhammed Rafeek M said:
If you want extract Unique data from ur data list, Select data list and go
Data->Filter->Advance Filter. You will get one dialogbox,
Select 'Copy to another location', select proper range in List range column,
and select copy to column and activate "Unique records only" then Click OK



please do rate.
Click to expand...
 
C

challa prabhu

Hi,

You can use either Cutom Autofilter in the Autofilter or Use
Data->-Filter_>Advanced Filter command

Challa Prabhu
 
Top