View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default Sorting by month

Good morning,
I have several lines of information for different plants and am trying to
consolidate it to one line per plant.

ie:
a b c
7/21 A 123
7/21 B 342
7/21 C 502
7/22 B 132
7/22 C 200
7/25 A 400

What I want to see is this...

a b c
July A 523 <~~~Total for month for that plant
july B 474
July C 702

I would like to have it do this for each month but on the same page. I hope
this makes sense.