Good evening Programming Experts,
I need your assistance , I have an excel sheet with a dashboard on sheet1 and raw data on sheet 2. I'm trying to use a v lookup or index match but its failing, not sure if its the way my raw data set up but by the looks of it all looks good.
below is my dashboard view
02-Nov Monday
quality Metric NCC-O NCC-A ABB-D ABB-D%
Grand Total
02-Nov Monday
quality Metric NCC-O NCC-A ABB-D ABB-D%
John Doe
Amy Watson
Justin Brown
Noah Anderson
below is my raw data view
Roll UP Monday Tuesday Wednesday Thursday Friday
Met Target 22 21 16 21 22
NCC-O 16 13 21 11 9
NCC-A 23 21 32 33 16
ABB-D 14 17 22 13 22
ABB-D% 5 3 6 7 3
John Doe Monday Tuesday Wednesday Thursday Friday
Met Target 3 5 3 2 1
NCC-O 6 7 8 7 2
NCC-A 3 3 5 7 9
ABB-D 1 1 1 1 1
ABB-D% 5 6 8 9 9
Amy Watson Monday Tuesday Wednesday Thursday Friday
Met Target 3 5 3 2 1
NCC-O 6 7 8 7 2
NCC-A 3 3 5 7 9
ABB-D 1 1 1 1 1
ABB-D% 5 6 8 9 9
Justin Brown Monday Tuesday Wednesday Thursday Friday
Met Target 3 5 3 2 1
NCC-O 6 7 8 7 2
NCC-A 3 3 5 7 9
ABB-D 1 1 1 1 1
ABB-D% 5 6 8 9 9
Noah Anderson Monday Tuesday Wednesday Thursday Friday
Met Target 3 5 3 2 1
NCC-O 6 7 8 7 2
NCC-A 3 3 5 7 9
ABB-D 1 1 1 1 1
ABB-D% 5 6 8 9 9
I would like the raw nicely summarized in the dashboard. The only thing that I would need say is my dashboard DAY OF WEEK is programmed to change each day so it will become Monday then Tuesday then Wednesday ect. I want the formula to capture that in the dashboard from the raw data as the days change,
I have also attached my excel document to make it easier.
Thank you greatly.
Bookmarks