#1
|
|||
|
|||
Excel - Formula or Pivot Table
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 ! |
#2
|
|||
|
|||
Hi, see the attached file (with two auxiliary columns) ...
|
#3
|
||||
|
||||
__________________
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Cannot Group Date In Excel Pivot Table | tomohawk | Excel | 3 | 01-18-2022 08:59 AM |
Excel pivot table | Don Harrison | Excel | 6 | 06-07-2017 02:32 PM |
Excel 2010 Pivot table problem | Kris TenEyck | Excel | 4 | 02-01-2014 01:26 AM |
Excel Pivot Table Calculated Field | BertLady | Excel | 0 | 05-21-2012 10:51 AM |
Excel 2010 Pivot Table Qs | SchneeBaer | Excel | 2 | 10-03-2011 08:45 PM |