![]() |
Pivot Table grouping
I have a spreadsheet with various computer information..
Office ComputerName Memory FreeSpace What I'm trying to do is get a summary as follows Office Mem < 1K Mem < 1.5 K Mem < 2K FreeSpace < 15Gig Office1 1 0 3 2 Office2 4 2 0 5 .... where the number are the count of the number of count of computers meeting this criteria... I've done part of this using a pivot table(the memory), but I had to do the 'group' manually. Is there a better way? |
All times are GMT +1. The time now is 07:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com