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