Home
BetterSolutions.com
Online Documentation
Microsoft Office Excel
Microsoft Office Word
JavaScript Programming
VBA Programming
C# Programming
Microsoft Office Excel
Workbooks
Worksheets
Rows Columns
Cells Ranges
Data Validation
Data Analysis
Pivot Tables
Power Query
Search Excel ...
Functions
User Defined
Formulas
Dynamic Formulas
Reviewing
Track Changes
Named Ranges
Conditional Format
Microsoft Word
Tables
Charts
Dates Times
Formatting
Illustrations
Layout
Importing
XML
Microsoft PowerPoint
Ribbon
Options
Shortcut Keys
Protection
Add-ins
Macros
Templates
Quant Finance
Microsoft Outlook
Microsoft Office Excel
Worksheet Functions List
Ribbon Tabs Explained
Keyboard Shortcut Keys
Best Practices
Search Excel ...
VBA Programming
Visual Basic Editor
Add-ins
Macros
Syntax
Arrays
Collections
Error Handling
Debugging
Search VBA ...
Data Types
Variables
Strings
Numbers
Dates Times
Files Directories
Best Practices
XML
Questions
Functions
Subroutines
MsgBox
InputBox
Userforms
Controls
Events
Databases
C# Programming
Ribbon
Options
Shortcut Keys
Enumerations
Class Modules
References
Web Services
SQL
JS Programming
VBA Programming
Complete Functions List
Recording Macros
Syntax And Loops
Best Practices
Search VBA ...
Bespoke Development
Office Add-in Development
JavaScript Office Add-ins
VSTO and C# Integration
Macros and VBA Programming
High Value Consultancy
Get In Touch
Excel
>
Formulas
Microsoft Excel
Formulas
User FAQs ...
Shortcut Keys ...
Troubleshooting ...
Error Types ...
Complete List
Categories ...
Counting
Summing
Lookup
Conditional
Date & Time
Formatting
Number
Statistical
Text
Filtering
Data Validation
Other
Counting Formulas
Summing Formulas
Lookup Formulas
Inserting ...
Calculation ...
Auditing ...
Error Checking ...
Dynamic Formulas ...
Array Formulas ...
Updates ...
Code - TypeScript
Code - VBA ...
Updated: 01 November 2023
01 November 2023
Data Validation Formulas
Only allow a certain number of characters*
Placeholder
Only allow characters in uppercase*
Placeholder
Only allow dates in a particular range*
Placeholder
Only allow dates in a particular year
Data Validation - Only allow
Only allow dates in the current year
Data Validation - Only allow
Only allow dates in the next 30 days
Data Validation - Only allow
Only allow dates that are weekdays*
Placeholder
Only allow dates that are weekends
Data Validation - Only allow
Only allow dates*
Placeholder
Only allow entries in a particular format*
Placeholder
Only allow numbers in a particular range*
Placeholder
Only allow numbers that are whole numbers
Data Validation - Only allow
Only allow numbers*
Placeholder
Only allow percentages that are whole numbers
Data Validation - Only allow
Only allow percentages*
Placeholder
Only allow text in uppercase*
Placeholder
Only allow text*
Placeholder
Only allow times*
Placeholder
Only allow unique values no duplicates*
Placeholder
Only allow values from a predefined list*
Placeholder
Only allow values that are not in a predefined list
Data Validation - Only allow
Only allow values whose sum is restricted*
Placeholder
Only allow yes or no*
Placeholder
Only allow a certain number of characters*
Placeholder
Only allow characters in uppercase*
Placeholder
Only allow dates in a particular range*
Placeholder
Only allow dates in a particular year
Data Validation - Only allow
Only allow dates in the current year
Data Validation - Only allow
Only allow dates in the next 30 days
Data Validation - Only allow
Only allow dates that are weekdays*
Placeholder
Only allow dates that are weekends
Data Validation - Only allow
Only allow dates*
Placeholder
Only allow entries in a particular format*
Placeholder
Only allow numbers in a particular range*
Placeholder
Only allow numbers that are whole numbers
Data Validation - Only allow
Only allow numbers*
Placeholder
Only allow percentages that are whole numbers
Data Validation - Only allow
Only allow percentages*
Placeholder
Only allow text in uppercase*
Placeholder
Only allow text*
Placeholder
Only allow times*
Placeholder
Only allow unique values no duplicates*
Placeholder
Only allow values from a predefined list*
Placeholder
Only allow values that are not in a predefined list
Data Validation - Only allow
Only allow values whose sum is restricted*
Placeholder
Only allow yes or no*
Placeholder
© 2023 Better Solutions Limited.
All Rights Reserved.
© 2023
Better Solutions Limited
Top