ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Extracting non-repeating data (https://www.excelbanter.com/excel-discussion-misc-queries/153551-extracting-non-repeating-data.html)

yshridhar

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

Muhammed Rafeek M

Extracting non-repeating data
 
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.



"yshridhar" wrote:

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


yshridhar

Extracting non-repeating data
 
Thanks alot.... Mr. Rafeek
Sridhar


"Muhammed Rafeek M" wrote:

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.



"yshridhar" wrote:

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


challa prabhu

Extracting non-repeating data
 
Hi,

You can use either Cutom Autofilter in the Autofilter or Use
Data--Filter_Advanced Filter command

Challa Prabhu

"yshridhar" wrote:

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



All times are GMT +1. The time now is 02:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com