Hi,
I am trying to collate data where there are multiple criteria to be compared and then the output is to be tabulated.
I have columns as under:
- Locations: 4 in number
- Cost center: 4 in number (one for each location)
- GL Code: 14 in number (common to all cost centers)
In a month expenditure is done for each location under multiple GL code.
What I am trying to collate is the month wise expenditure for each Location for its cost center.
The link to a sample of my data is at:
http://%22https//drive.google.…UVHVtWmlscmc%22
I am using excel 2013.
Thanks,
upu3217