Custom Data Validation in Excel to have Customer ID in a particular way only

Опубликовано: 06 Октябрь 2024
на канале: Excel Rush

5,238

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