excel seach
I have an excel sheet with 5000 entries - much of which are duplicates. Is
there a way to pull only one line/name/address from each set of duplicates without going through and doing it one by one? |
excel seach
You can use Advanced Filter to extract duplicates - Debra Dalgleish
shows how he http://www.contextures.com/xladvfilter01.html Hope this helps. Pete On Jun 27, 9:59*pm, Excel-lent Novice <Excel-lent wrote: I have an excel sheet with 5000 entries - much of which are duplicates. *Is there a way to pull only one line/name/address from each set of duplicates without going through and doing it one by one? * |
All times are GMT +1. The time now is 09:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com