Extracting non-repeating data

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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...
 
Hi,

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

Challa Prabhu
 
Back
Top