Search code examples
vbaexcelgroup-summaries

Summarize data in Excel with VBA

I have a table in Excel with dates and values. Every day there were a number of different values.

I want to summarize how many of each value there were every day.

Example: From this

Date  Value

10/1  Blue
10/1  Blue
10/1  Red
11/1  Blue
11/1  Blue

I want to get a new table with something like this:

     10/1    11/1
Blue    2       2
Red     1       0

I'm convinced this is possible to do in VBA/Excel. Does anyone have any ideas?

Solution

  • The solution was, just as Alex K said, to use the Privot Table function included in Excel.

    Thanks for your help!