|
|
#1
12-11-2022, 01:25 PM
|
|||
|
|||
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 ! 
|
|
|
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 |
Windows 10 
Office 2019
Threaded Mode