Build engaged audiences through publishing by curation.
Sign up with Facebook
Sign up with Twitter
Sign up with Linkedin
I don't have a Facebook, a Twitter or a LinkedIn account
Start a free trial of Scoop.it Business
Excel data validation examples using custom validation; prevent duplicates, limit total amount, prevent leading spaces, prohibit weekend dates
Creative uses of validation to cover common needs for cell restrictions and limitations.
Are you sure you want to delete this scoop?
Today this Custom validation was really useful - I limited the cell to two different text values without using List.
formule excel formattazione condizionale convalida formule matriciali
Some things to remember when using SUBTOTAL formula.
How to use Advanced Filters in Excel. Find exact text using Advanced Filters with formula criteria.
Formulas in criteria - Great!
Create a data validation list that is dependent on another list using formulas that dynamically update when the source data changes.
Easy-to-use data validation. The formula is complex, but you can easily use the file! :-)
And there is a great trick with ! for advanced users :-)
Dependent and dynamic dropdown lists in Excel are so valuable in controlling inputs and keeping your source data clean.