Scribd
Upload
22 views3 pages

Data Validation: Year Type Product Group Producer Code Volume Cost Per Unit Price Per Unit

The document contains sales data from 2018 for convenience stores, including product group, producer code, volume sold, cost per unit, and price per unit. It also provides guidance on how to validate the data by selecting rows, using data validation tools to assign error messages, and specifying the source for validation.

Uploaded by

anushree sarpotdar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
22 views3 pages

Data Validation: Year Type Product Group Producer Code Volume Cost Per Unit Price Per Unit

The document contains sales data from 2018 for convenience stores, including product group, producer code, volume sold, cost per unit, and price per unit. It also provides guidance on how to validate the data by selecting rows, using data validation tools to assign error messages, and specifying the source for validation.

Uploaded by

anushree sarpotdar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

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

You might also like