Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi:
I am learning a lot by reading these posts, but I cannot figure this one out. I have a table (nn rows x 6 columns). The first column is the ID of the participant. The other five columns are their selections from a validated drop-down (header row shown below). In each row a participant selects five names from the same list (the list has about 1,000 names), but has to choose a different name for their five selections. That part I have error checked. Participant ID Name1 Name2 Name3 Name4 Name5 What I also need to check (which I cannot figure out) is that no participants select the same five names from the list. While the five selections are made from the same (alphabetized) list, they will not necessarily be made in the same order. Thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is there a macro to identify and remove duplicate data in Excel? | Excel Worksheet Functions | |||
Look up/math text | Excel Worksheet Functions | |||
Deleting duplicate entries in an Excel list | Excel Worksheet Functions | |||
Deleting duplicate entries in Excel list | Excel Discussion (Misc queries) | |||
Multiple Files, Duplicate Entries | Excel Discussion (Misc queries) |