D
dt
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?
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?