Data Management, ...
Follow
Find tag "useful"
826 views | +0 today
Your new post is loading...
Your new post is loading...
Rescooped by Oz du Soleil from FrankensTeam's Excel Collection
Scoop.it!

Excel Data Validation Examples Custom Criteria

Excel Data Validation Examples Custom Criteria | Data Management, Data Quality | Scoop.it
Excel data validation examples using custom validation; prevent duplicates, limit total amount, prevent leading spaces, prohibit weekend dates

Via Kris
Oz du Soleil's insight:

Creative uses of validation to cover common needs for cell restrictions and limitations.

more...
Kris's curator insight, May 3, 2013 4:26 AM

Today this Custom validation was really useful - I limited the cell to two different text values without using List.

Rescooped by Oz du Soleil from FrankensTeam's Excel Collection
Scoop.it!

Excel CEILING and FLOOR Functions

Excel CEILING and FLOOR Functions | Data Management, Data Quality | Scoop.it

Via Kris
more...
No comment yet.
Rescooped by Oz du Soleil from FrankensTeam's Excel Collection
Scoop.it!

Facts about subtotal formula - visible and hidden cells - E90E50 fx

Facts about subtotal formula - visible and hidden cells - E90E50 fx | Data Management, Data Quality | Scoop.it
formule excel formattazione condizionale convalida formule matriciali

Via Kris
more...
Kris's curator insight, February 4, 2013 3:40 AM

Some things to remember when using SUBTOTAL formula.

Rescooped by Oz du Soleil from FrankensTeam's Excel Collection
Scoop.it!

Excel Data Validation Examples Custom Criteria

Excel Data Validation Examples Custom Criteria | Data Management, Data Quality | Scoop.it
Excel data validation examples using custom validation; prevent duplicates, limit total amount, prevent leading spaces, prohibit weekend dates

Via Kris
more...
Kris's curator insight, May 3, 2013 4:26 AM

Today this Custom validation was really useful - I limited the cell to two different text values without using List.

Oz du Soleil's curator insight, May 21, 2013 9:28 AM

Creative uses of validation to cover common needs for cell restrictions and limitations.

Rescooped by Oz du Soleil from Excel Easy
Scoop.it!

Excel Advanced Filters

Excel Advanced Filters | Data Management, Data Quality | Scoop.it
How to use Advanced Filters in Excel. Find exact text using Advanced Filters with formula criteria.

Via Kris, Roger Fisher
more...
Kris's curator insight, April 18, 2013 2:44 PM

Formulas in criteria - Great!

Progressive training's curator insight, February 9, 2:07 PM

Excel Advanced Filters

 

Rescooped by Oz du Soleil from FrankensTeam's Excel Collection
Scoop.it!

Excel Dynamic Data Validation Lists

Excel Dynamic Data Validation Lists | Data Management, Data Quality | Scoop.it
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 :-)


Via Kris
Oz du Soleil's insight:

Dependent and dynamic dropdown lists in Excel are so valuable in controlling inputs and keeping your source data clean.

more...
No comment yet.