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: 2
Default Find Duplicates in a Schedule (Two fields: Time and ApplicantID)

I have a schedule for a job fair that has thousands of applicant interview times at hundreds of interview tables. I need a quick way to make sure there are no duplicate times for each applicant.

I have a table something like this:

Time | TableID | ApplicantID | Applicant Name

I want to search for both Time and ApplicantID to see if there are any duplicates and then highlight them or identify in some way that those conflicts need to be resolved.

Any help would be greatly appreciated!
 
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
Transpose 4 Columns data to Rows for Employee Time In and Time Out Schedule Nasir[_2_] Excel Programming 0 May 4th 11 12:05 PM
Time schedule Zsolt Szabó Excel Discussion (Misc queries) 3 May 3rd 09 05:22 PM
Formula to count based on multiple criteria fields w/duplicates Excel-User-RR Excel Worksheet Functions 5 March 8th 09 12:48 AM
Find duplicates, sum column then delete duplicates aileen Excel Programming 3 December 11th 08 05:03 PM
How to use solver to schedule part time and full time workforce? The Ooz Excel Discussion (Misc queries) 0 August 18th 05 06:53 AM


All times are GMT +1. The time now is 06:42 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"