Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table - Grouping | Excel Worksheet Functions | |||
Pivot Table Grouping | Excel Discussion (Misc queries) | |||
Grouping with a pivot table | Excel Worksheet Functions | |||
Pivot table grouping | Excel Worksheet Functions | |||
Pivot Table Grouping | Excel Discussion (Misc queries) |