Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi all,
I am creating a spreadsheet which will have data entry from different users. I want to give the validation in such a way that a combination of values in 2 columns do not occur more than once. Like say A B 1 a 1 b 2 a 2 b 2 a in above example the combination 2 and a is recurring. it should be restricted by validation while entering the data itself. can anybody please help Regards NC |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sort column data with hidden columns - excel 2003 | Excel Discussion (Misc queries) | |||
Data validation in data form? | Excel Discussion (Misc queries) | |||
Merging columns of data | Excel Discussion (Misc queries) | |||
Merging columns of data | Excel Discussion (Misc queries) | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) |