BetterSolutions.com
BetterSolutions.com
Documentation
Microsoft Office Word
VBA Programming
C# Programming
JavaScript Programming
Consultancy
Macros, Templates and EUDAs
Office JS Add-ins and Scripts
VSTO and .NET Integration
Addins
Office Add-ins for Excel
Office Add-ins for Word
Support
Troubleshooting
Long Term Partner
Training
Microsoft 365 Migration
Please Contact Us Today for a FREE Consultation
Excel
Add-ins
Best Practices
Cells Ranges
Charts
Conditional Format
Data Analysis
Data Validation
Dates Times
Finance
Formatting
Formulas
Functions
Illustrations
Importing
Layout
Macros
Named Ranges
Options
Pivot Tables
Power Query
Protection
Reviewing
Ribbon
Rows Columns
Shortcut Keys
Tables
Templates
Track Changes
User Defined Fns
Workbooks
Worksheets
XML
Word
Documents
Layout
Pages
Sections
References
Building Blocks
Content Controls
Mailings
Search Word ...
Characters
Paragraphs
Styles
Bullets
Numbering
Track Changes
Reviewing
Outlines
Best Practices ...
Tables
Charts
Bookmarks
Text Boxes
Illustrations
Fields
Importing
XML
Questions ...
Ribbon
Options
Shortcut Keys
Protection
Add-ins
Macros
Templates
Design
PowerPoint
Presentations
Slides
Paragraphs
Characters
Sections
Handouts
Notes
Slide Show
Search PowerPoint ...
Styles
Bullets
Numbering
Text Boxes
Reviewing
Track Changes
Outlines
References
Best Practices ...
Tables
Charts
Animation
Transitions
Illustrations
Layout
Importing
Video
Questions ...
Ribbon
Options
Shortcut Keys
Protection
Add-ins
Macros
Templates
Design
Outlook
Mail
Rules
Alerts
Search
Tasks
Notes
Journal
OneNote
Search Outlook ...
Calendar
Appointments
Meetings
Events
Folders
SharePoint
Proofing
Web Client
Best Practices ...
Contacts
Address Book
People
Groups
Illustrations
OneDrive
Importing
HTML
Questions ...
Ribbon
Options
Shortcut Keys
Exchange
Add-ins
Macros
Forms
XML
VBA
Add-ins
Arrays
Best Practices
Class Modules
Code Snippets
Collections
Controls
Databases
Data Types
Dates Times
Debugging
Enumerations
Error Handling
Events
Files Directories
Functions
Macros
MsgBox
Numbers
Options
References
Ribbon
Shortcut Keys
SQL
Strings
Subroutines
Syntax
Userforms
Variables
Visual Basic Editor
Web Interaction
XML
C#
Visual Studio
.NET Library
Projects
Syntax
Arrays
Collections
Error Handling
Debugging
Search C# ...
Data Types
Variables
Strings
Numbers
Dates Times
Files Directories
MessageBox
Utiities
Best Practices ...
Classes
Structures
Interfaces
Generics
Windows Forms
Databases
Web Services
XML
Questions ...
Web Add-ins
VSTO Add-ins
Excel Interop
VBA Migration
Serialization
Threading
WPF Forms
ASP.NET
JS
Visual Studio Code
Node JS Runtime
Yeoman Generator
Syntax
Arrays
Objects
Error Handling
Debugging
Search JavaScript ...
Data Types
Variables
Strings
Numbers
Dates Times
Microsoft Graph
Express Backend
HTML Pages
Best Practices ...
Functions
React Library
Fluent UI
TypeScript
Task Panes
Ribbon Commands
Dialog Boxes
Custom Functions
Questions ...
Office Scripts
Office Add-ins
Office Manifest
Office Events
Excel API
Word API
PowerPoint API
Outlook API
Feedback
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: 04 September 2024
04 September 2024
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
© 2024 Better Solutions Limited.
All Rights Reserved.
© 2024
Better Solutions Limited
Top