Thread: group data
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
microsoft.news.com[_2_] microsoft.news.com[_2_] is offline
external usenet poster
 
Posts: 8
Default group data

the big issue is that i'm generating the excel spreadsheet on the fly using
C#, and i'm passing all the data in to the spreadsheet which works, but now
i have to group the as I listed before and I'm not sure how to do that or if
it can even be done

"Jim Thomlinson" wrote in message
...
Depending on how your data looks I would highly recommend a pivot table.
Once
you get the hang of them they are fast, easy and very powerful at pulling
together a lot of data into useful information in a really big hurry.
--
HTH...

Jim Thomlinson


"microsoft.news.com" wrote:

How can I group data? example:

instead of seeing

BMW
BMW
Lexus
BMW
Lexus

I want
BMW
cars sold
when sold
who bought

Lexus
Cars sold
when sold
who bought.

is something possible to do when creating a spreadsheet?