Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Search Listings
Hi
I am using Excel XP pro I have a list of names or whatever in one column. Is there any way I can do a search for all names that have been duplicated and it throw up a list for me. The search facility seems to be a bit limited for this task. Regards |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Search Listings
select your range
Conditional Formatting =COUNTIF($A$1:$A$100,$A1)1 format any color you like (it will highlight all the duplicated) "chesjak" wrote: Hi I am using Excel XP pro I have a list of names or whatever in one column. Is there any way I can do a search for all names that have been duplicated and it throw up a list for me. The search facility seems to be a bit limited for this task. Regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Excel Discussion (Misc queries) | |||
Creating automatic listings | Excel Discussion (Misc queries) | |||
How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions | |||
How do I format 1 column of alphabetical listings into 3 columns? | Excel Worksheet Functions | |||
IF statments for multiple listings. | Excel Worksheet Functions |