Thread: Matching
View Single Post
  #2   Report Post  
Ron Coderre
 
Posts: n/a
Default

I came up with 2 ways to handle your situation:

(Assuming entries are in Cells A1:B???)
This one allows you to enter duplicate Student IDs, but flags them with a
colored cell background:
1)Select the Input Range
2)FormatConditional Formatting
3)Formula Is: =SUMPRODUCT(--($A$1:$B1=A1)*(A1<""))1
Format: ( I set the cell background color to bright yellow)
Click [OK]

This one prevents the entry of a duplicate Student ID:
1)Select the Input Range
2)DataValidationCustom
3)Formula: =SUMPRODUCT(--($A$1:$B1=A1)*(A1<""))=1
Click OK

Does that help?
--
Regards,
Ron