LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there a macro to identify and remove duplicate data in Excel? Cindy Lou Excel Worksheet Functions 3 March 9th 06 03:10 AM
Look up/math text JN Excel Worksheet Functions 11 February 4th 06 08:27 AM
Deleting duplicate entries in an Excel list ticephotos Excel Worksheet Functions 5 May 3rd 05 08:44 PM
Deleting duplicate entries in Excel list ticephotos Excel Discussion (Misc queries) 2 May 3rd 05 06:22 PM
Multiple Files, Duplicate Entries PMSunshine77 Excel Discussion (Misc queries) 1 December 10th 04 08:28 PM


All times are GMT +1. The time now is 02:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"