View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bman342 bman342 is offline
external usenet poster
 
Posts: 22
Default Need to identify duplicate entries in a Table

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.