Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 15th 14, 03:23 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2012
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!

  #2   Report Post  
Old May 15th 14, 03:37 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,872
Default Find Duplicates in a Schedule (Two fields: Time and ApplicantID)

Hi,

Am Thu, 15 May 2014 07:23:13 -0700 (PDT) schrieb OutdoorRuss:

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.


select your table A2:En = Conditional Formatting = New Rule = Use
formula to determine.....:
=SUMPRODUCT(--($A$2:A2=$A2),--($C$2:C2=$C2))1
and select the expected fill color


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional


Reply
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 01:48 AM
Find duplicates, sum column then delete duplicates aileen Excel Programming 3 December 11th 08 06: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 01:52 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017