Hi, I have a spreadsheet and I'm bit stuck as to which formula (pivot table) to use to get the information out of my data table. I was thinking possibly Index/Match.



I'm a bit of a novice to Excel and couldn't get it to work. I've uploaded a workbook, first tab is data, second tab is what I'd like it to do.

Any help appreciated.

Seasons Greetings !

Attached Files

Data Query.xlsx (20.5 KB, 10 views)

Hi, see the attached file (with two auxiliary columns) ...

Attached Files

Data Query.xlsx (21.5 KB, 5 views)

Cross post Summary Pivot Table from More Extensive Data
read this to understand why it is important

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post