We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Display dates in pivot table rather than sum/count etc?

Medium Priority
321 Views
Last Modified: 2012-08-13
Hello experts,

I have a table to data, basically, I check monthly returns from various departments, and i want to be able to produce a table that will display on a given the month the recertification dates (AA-AD) or if nothing is present remain blank per domain.  I have highlighted in red the heading i want to include.

I thought a pivot table would do this but I cant get it to display dates.
I've attached an example which hopefully explains a little better.

Thank you for your help example10.xlsx
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2011
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Thank you i was able to work out exactly what I needed from your solution :)
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.