MS Excel: Advanced Data Validation using List

[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...!!!

[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

[rdalben]

how do i delete a name list (furniture, fruits ,etC) ??

[tanimnsu]

gr8 tutorial

waiting for 'use of array' in upcoming sessions

[RaiNtrospection]

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

[01234566517]

hey! did a bang up job!! it seems you are going from strength to strength and I'm sure you will continue that way. Never stop doing what you do best!! :)