| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying Duplicate Data?
How would I particular cell ranges look for and display repeating data say in
a Name column or zip code column. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying Duplicate Data?
Data Filter Autofilter........then choose the dropdown arrow on the
column of interest and select the desired item to filter.......... Vaya con Dios, Chuck, CABGx3 "tjs" wrote: How would I particular cell ranges look for and display repeating data say in a Name column or zip code column. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying Duplicate Data?
For example I would like to pull all entires with that have duplicate numbers
so searching and finding all those which repeat? "CLR" wrote: Data Filter Autofilter........then choose the dropdown arrow on the column of interest and select the desired item to filter.......... Vaya con Dios, Chuck, CABGx3 "tjs" wrote: How would I particular cell ranges look for and display repeating data say in a Name column or zip code column. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying Duplicate Data?
Sorry, I misunderstood your desire. For dealing with duplicates, I use Jim
Cone's fine commercial Add-in called "XLCompanion".....it's available at: http://www.realezsites.com/bus/primitivesoftware/ Vaya con Dios, Chuck, CABGx3 "tjs" wrote: For example I would like to pull all entires with that have duplicate numbers so searching and finding all those which repeat? "CLR" wrote: Data Filter Autofilter........then choose the dropdown arrow on the column of interest and select the desired item to filter.......... Vaya con Dios, Chuck, CABGx3 "tjs" wrote: How would I particular cell ranges look for and display repeating data say in a Name column or zip code column. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Displaying Duplicate Data?
Chip Pearson has lots of info:
http://www.cpearson.com/excel/Duplicates.aspx tjs wrote: How would I particular cell ranges look for and display repeating data say in a Name column or zip code column. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Bar data not displaying | Charts and Charting in Excel | |||
| problems with displaying "duplicate vlookup values" in same column | Excel Discussion (Misc queries) | |||
| Would like help with displaying data if are a certain value is pre | Excel Worksheet Functions | |||
| Displaying data | Excel Discussion (Misc queries) | |||
| Add data labels without displaying data points? | Charts and Charting in Excel | |||
Hybrid Mode
