Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hey everyone: using Excel 2000.
I have a spreadsheet like such (each # is in a different cell), starting on A1: 1 2 3 4 1 5 6 3 2 7 4 3 1 5 6 3 6 3 2 5 1 2 3 4 These numbers are entered in manually as new records. Notice that "1 2 3 4" and "1 5 6 3" have been entered twice. I am trying to stop that from happening. When people are entering a new record, I don't want them to enter a row of numbers if it's already been entered once before. So is there a way (thinking about Validation) to create a condition that says "look at this row of cells as a whole" and see if that set of numbers (in that specific order) has been entered anywhere above? Hope that makes sense. Thanks for your help! Joe |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Duplicates in excel that aren't 100% DUPLICATES ... | Excel Discussion (Misc queries) | |||
Conditional formatting of duplicates in a range | Excel Worksheet Functions | |||
Cannot extend the range of data I'm trying to prevent duplicates i | Excel Worksheet Functions | |||
AVOIDING DUPLICATES IN A RANGE OF CELLS | Excel Discussion (Misc queries) | |||
Count unique values among duplicates in a subtotal range | Excel Discussion (Misc queries) |