I have data for an item number and quantity and I want to enter the same item in a column where I want to restrict data entry if the item entered exceeds the quantity. To do this I used a custom formula in Excel data validation.

#shorts, #vlookup, #countifs, #datavalidation, #dataentry, #exceltips

Please take the opportunity to connect with your friends and family and share this video with them if you find it useful.