Data validation
Year Type Product group Producer Code Volume Cost per unit Price per unit
2018 Convenience stores Coffee Lieken |13/12/38| 420 6.0 8.4
2018 Convenience stores Coffee Lieken |13/13/98| 480 6.1 7.4
2018 Convenience stores Lieken |13/13/99| 528 5.4 7.6
2018 Convenience stores Fruits Lieken |13/01/01| 4836 0.74 0.96
2018 Convenience stores Lieken |13/01/01a| 5928 0.95 0.99
2018 Convenience stores Lieken |13/01/02| 5712 0.89 0.97
2018 Convenience stores Lieken |13/01/03| 4872 0.62 0.9
2018 Convenience stores Lieken |13/01/04| 6228 0.65 1.07
2018 Convenience stores Lieken |13/01/05| 9588 0.92 1.01
2018 Convenience stores Lieken |13/01/06| 7836 1.19 0.96
2018 Convenience stores Lieken |13/01/07| 7560 1.02 1.09
2018 Convenience stores Lieken |13/01/30| 8556 0.99 1.1
Meat
Coffee
Vegetabiles
Fruits
How to validate the data:
select the row you want to fill the data--> go to data ribbon and select data validation--> assign a error msg--> select where you validate from