ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table grouping (https://www.excelbanter.com/excel-discussion-misc-queries/202167-pivot-table-grouping.html)

DT

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