T tjs Jan 15, 2008 #1 How would I particular cell ranges look for and display repeating data say in a Name column or zip code column.
How would I particular cell ranges look for and display repeating data say in a Name column or zip code column.
C CLR Jan 15, 2008 #2 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
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
T tjs Jan 15, 2008 #3 For example I would like to pull all entires with that have duplicate numbers so searching and finding all those which repeat?
For example I would like to pull all entires with that have duplicate numbers so searching and finding all those which repeat?
C CLR Jan 15, 2008 #4 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
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
D Dave Peterson Jan 15, 2008 #5 Chip Pearson has lots of info: http://www.cpearson.com/excel/Duplicates.aspx