| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Duplicate entries in more than one column
hellor,
Well, i hope someone here will be able to help me! My data is as follows: LAST NAME FIRST NAME 1. ABC OPP 2. XYZ MGF 3. RTY SED 4. QRS WER 5. ABC OPP 6. RTY SED 7. QFG CVT 8. POL MUH I want to identify the duplicate entries by grabbing the data from both columns that is Last Name and First Name as well. So that I get rows 1 &5 as well as rows 3 &4 highlighted. All the help information that you have given in the community is for data in ONe COLUMN ONLY. You will be of great help if you could add a solution to my problem as well! Looking forward to your reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count duplicate entries in column | Excel Discussion (Misc queries) | |||
| NO DUPLICATE ENTRIES IN A COLUMN USING EXCEL | Setting up and Configuration of Excel | |||
| How to remove duplicate entries in column? | Excel Discussion (Misc queries) | |||
| How do I set up an Excel column to not allow duplicate entries (m. | Excel Discussion (Misc queries) | |||
| Preventing Duplicate Entries within a column | Excel Discussion (Misc queries) | |||
Threaded Mode
