Data Validation (Excel) Reduce items already selected, in next row in data validation

Hi,

Suppose my data validation list contains 5 items (numbers from 1 to 5). As soon as I select 2 from list, then next data validation list should not show 2, but should show 1,3,4,5. Is that possible without macros? Yes, how...

- San
Sanjay GandhiFounder, KenhalAsked:
Who is Participating?
 
Rory ArchibaldCommented:
There is a detailed walkthrough on Debra's page here showing how to exclude previously selected items: http://www.contextures.com/xlDataVal03.html
0
 
Saqib Husain, SyedEngineerCommented:
Can you upload a sample layout to work on?
0
 
Sanjay GandhiFounder, KenhalAuthor Commented:
Sure, please find the attached file.
Data-Validation.xlsx
0
 
Sanjay GandhiFounder, KenhalAuthor Commented:
Works fine.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.