All articles with 'data validation' Tag

Find out how you can get a free e-book on excel and charting in this week’s excel links.

In this weeks edition, learn how to compare multiple items in a range using match, know how you can add more than one legend to a chart, include images in comments.

Google Spreadsheets team has introduced another very useful feature to their online excel competitor: Data Validation.
Although the data validation is not as robust as that of Excel’s, it provides basic validations pretty neatly.

Data validation is a great way to keep your users informed about possible values in a cell and guide them to select something appropriate. As part of the spreadcheats series, in this post we will discuss 2 advanced data validation techniques that can help you when you are modeling a complex worksheet.

Often I wish Microsoft had spent the effort and time on a data genie (and a set of powerful formulas) that can automate common data cleanup tasks like extracting duplicates, makings lists unique, find missing items, remove spaces etc. Alas, instead they have provided features like clippy which are intrusive to say the least. So […]

Spelling mistakes are a thing of day to day carporate life. Most of the data in spreadsheets is entered by people and hence prone to having spelling mistakes or alternate spellings. For eg. a person named John could have been spelled as Jon. And when John calls you back to confirm his reservation and you […]