Data Consolidation

[cmschube]

Hey All,

I hope someone can help me. I have a list of about 30k PCs for a
Enterprise Dollar estimate thing. I need to find out how much money
each Business Unit has in PCs. I have a list of PCs, Cost Center, and
Device Type, but like I said I have about 30k of them. I need to find
out how I can tell Excel to look for how many instances of each there
are per Cost Center. Any ideas?

Thanks,

cmschube

 

[Earl Kiosterud]

cmschube,

Make a Pivot Table. Drag the Cost Center into the left or top. Double-click the heading
and set it for count. Drag it again into the data area. This is a bit different in earlier
versions of Excel (97, and maybe 2000).