Custom Data Validation in Excel to have Customer ID in a particular way only
Your company maintains customer id's only starting with a C- and must have atleast 4 digits following it. But your data entry guys mess it up a lot.
Use this Custom Data Validation technique to ensure they are able to enter the customer id only in a particular way.
Play around with this method, to make your own Custom formula too!
For more videos to learn excel, click this link
• Learn Excel's Tricks
SUBSCRIBE!
/ @excelrush
Blog
Visit www.ExcelRush.com for the free blog to learn Excel in-depth.
Rushabh Shah is an expert in training Professionals & Students in Excel's Advanced features & formulas. These tutorials are simply a way to spread the knowledge and make people more productive using Excel.
For Classroom & Online Live Trainings with Rushabh, visit www.DLTC.co
Пікірлер: 2
Great one sir
Can I ask you something if you don't mind please? I have a cell with 3 choices (by data validation) and i want to fill others cells automatically which also these filled cells can calculate numbers automatically. For example, when I choose the first choice from the cell with the data validation, then another cell can calculate the sum of some cells automatically. when i choose the second choice from the cell with the data validation then another cell (not the cell from the first choice)can calculate the sum of some cells automatically. I could send you a draft from this excel if you don't mind in order to understand it more clearly. Thank you in advance