| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding duplicate cells across a whole spreadsheet
I'm looking at the class rosters for all 6 of my classes this semester at
UCF. I want to put all of the names in an excel spreadsheet and then find but NOT remove any duplicated names so I can contact classmates that have more than one class in common with me and work together with them. What's the easiest way to do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Finding duplicate cells across a whole spreadsheet
you can use conditional formating option "Format only unique of duplicate
values" chose your formatting and duplicates are identified. "Patrick J M" wrote: I'm looking at the class rosters for all 6 of my classes this semester at UCF. I want to put all of the names in an excel spreadsheet and then find but NOT remove any duplicated names so I can contact classmates that have more than one class in common with me and work together with them. What's the easiest way to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding muliple duplicate records in spreadsheet | Excel Worksheet Functions | |||
| Finding duplicate cells within a worksheet automatically | Excel Worksheet Functions | |||
| Finding duplicate numbers in a spreadsheet | Excel Worksheet Functions | |||
| Finding duplicate data between 2 spreadsheet workbooks? | Excel Discussion (Misc queries) | |||
| finding & filtering out duplicate cells | Excel Discussion (Misc queries) | |||
Linear Mode
