Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find Matching Records in Two Worksheets | Excel Discussion (Misc queries) | |||
Find matching records in two worksheets | Excel Discussion (Misc queries) | |||
Matching an Array in one Tab with an Array with another Tab | Excel Worksheet Functions | |||
Matching cells | Excel Discussion (Misc queries) | |||
Formula for Searching & matching two values in excel | Excel Discussion (Misc queries) |