Tuesday 28 November 2017

Excel - Data Validation Examples Custom Criteria

Prevent Duplicates in Table Column
Require Unique 5-Digit Numbers
Prevent Duplicates in Range of Cells
Limit the Total 
No Leading or Trailing Spaces
No Spaces in Text
No Spaces in Cell
Restrict to a Specific Date Range
Restrict to a Dynamic Date Range




















Prohibit Weekend Dates






Microsoft Accredited IT Training Provider
Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators
Microsoft MOS Test Centre London

No comments:

Post a Comment