View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KimC KimC is offline
external usenet poster
 
Posts: 52
Default Help with Analysing Data

Hi,

I'm a bit at a stand still with how to work this.
I have a sheet with quite a number of information.
But to simplify it, I have a column with company name, amount they spent in
quarter one.

What I need to find is the companies who spend money in quarter one, and how
much they spend.

I'm trying to use a pivot table for this, but i just cant seem to get it
right - it lists all the companies and the ones who didnt spend anything have
a 0 listed next to them.

Thanks in advance;
Kimberley