Complex Data Input Limitations
Data Validation is a great tool in Excel for making sure that whatever is entered in a cell matches your specific criteria. This tip looks at how you can combine desired limitations into a single formula that can be used with Data Validation.
Read this tip »
(Thanks to Ron Solecki, Steve Aprahamian, Harold Druss, Raymond Guzman, Dennis Riddle, Elliot Penna, Jos Graindor, Patrick Sedgwick, Ryszard Raciborski, Wayne Edmondson, Erik Oberg, Bob Beechey, Andrija Vrcan, John Snow, Peter Crosby, Jim Stevens, Dan McGovern, and Harr Ruchti for contributing to this tip.)