| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting non-repeating data
How to extract non-repeating data items from a data (in column)?
Thank you Sridhar |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| blocks of data repeating | New Users to Excel | |||
| repeating columnar data | Excel Worksheet Functions | |||
| repeating data in other sheets | Excel Discussion (Misc queries) | |||
| Repeating Data | Excel Discussion (Misc queries) | |||
| How do I stop data from repeating? | Excel Discussion (Misc queries) | |||
Hybrid Mode
