Summarize Excel Data

[DJBittner]

Attached is a workbook, MonRental.xlsm, where I would like to use the sheet: PlaySpace and create summary lines of totals (Column C) for each Equipment# (Column L).

Excel's Consolidate and/Subtotal options seem to fall way short. When I arrive with two columns of summary data (Equip# & Equip Total) I will need to reference that data via VLOOKUP in another workbook so it is important that I get 1 line of data per Equipment#.

If I were working in my old AS/400 - RPG environment I would simply query the data, summarizied (control break) by Equip# and write the output to a workfile. However, .....

Thoughts and consideration appreciated,

Dan

[rylo]

Hi

If pivot table doesn't give you what you are chasing, can you update your example file to show the output structure you are trying to achieve.

rylo

[MarvinP]

Hi DJBittner,

A Pivot Table may do what you want. See Sheet5 where I've done two pivots on your PlaySpace data. See the attached.

[DJBittner]

Pivot Tables are the answer -- I wondered but could not (initially) find the Pivot-button.

All set on this one - thanks a ton, Dan.