MS Excel / VBA help thread

You are reading a single comment by @hugo7 and its replies. Click here to read the full conversation.

•

Chalfie

You'll get a date hierarchy inserted into the pivot.

Dates in col a
Name in col b

Make pivot
Pivot will have Date and name in the field list
Also Months, Quarters, YEars.

Chuck the date (or months/quarters, years) in rows, then count of name in the values.

•

hugo7 in reply to @Chalfie

But then I end up with a count for each date rather than month.

•

Chalfie in reply to @hugo7

On the pivot?
Look in the field list?
You should have three new fields under the date, depending on your version of excel, as excel now inserts date hierarchy in there, giving you
Quarter (date)
Month (date)
Year (date)

About

Avatar for hugo7 @hugo7 started