MS Excel: Advanced Data Validation using List

This tutorial shows how to create a LIST based Data Validation using MS Excel 2003, how to create a validation list that changes based on a selection from another list and how to create custom messages to guide users more effectively. NAMED Ranges/ formulas and IF function are used as validation criteria to accomplish this along with standard Data Validation Settings.

Category:

Education

Tags:

• Excel 2003
• list
• data
• validation
• named
• ranges
• formula
• if
• function
• input
• message
• error
• alert
• stop
• warning

[rdalben]

The only way to delete an existing range name, or modify its cell reference, is via Insert>Name>Define

[RaiNtrospection]

In excel 2003, only way to delete named ranges/formulas is through Insert>Name>Define as you pointed. Shortcut to reach Define name box is Ctrl+F3.

Excel 2007 added an incredible 'Name Manger' to take care of that along with other benefits.

Hope this helps. Thanks for your query

[RaiNtrospection]

Thanks for your comment. needed some inspiration and you just boosted it up :)

[TheLonelymusic]

thanks



[TheRubixGuy]

how could someone dislike this, great tutorial!!

[naliniananth]

Thank u very much for ur guidance.

i was able to repeat what u did with a small data as u had shown. But when I used a larger data of 100 rows, the error message I recd is as follows;

The list source must be a delimited list or a reference to a single row or column.

I hv taken care for all the punctations while writing the formulae.

Kindly guide. Thanks

[althafameen]

Tnx For That

[redbutterfly1028]

Thank you so much....This really very helpful...u saved me...hehehehe =)

[vikyyyyyyyy]

Thank you so much! This is really helpful

[ramen003]

Just got a superb idea for my needed report. Thank you very much.

[shipupx]

this is really awesome...!!!