P
Princess V
I have a sheet with raw data - from which a pivot table was created for us.
It contains values as such:
Location ID Type of Hardware Number of Units
In a separate sheet, I have location id and number of units.
I want to create a new sheet that compares the location ids in both sheets
and then tell me when there is a discrepency in the number of units.
Help?
It contains values as such:
Location ID Type of Hardware Number of Units
In a separate sheet, I have location id and number of units.
I want to create a new sheet that compares the location ids in both sheets
and then tell me when there is a discrepency in the number of units.
Help?