I have an excel report that gets emailed to me and it's in a very poor format that I need to convert into a more traditional table. Also, this file will be updated daily by a not very experienced person in Excel. A traditional Index Match Match won't work as the horizontal categories are different every few rows down.
On the "Daily Data" tab, you will see the date in Column A.
There are then different categories in Column's C-V, which I then need to perform a matrix lookup on.
What I need to accomplish:
Click on the "Data for Qlikview" tab.
In cell D3 for example, I need to return the sum of "Customer ASN's Received" on 06/22/2017, which in this case would be 7.
In cell P4 on the "Data for Qlikview" tab, I would need to see a result of 902.
I'm lost....
Bookmarks