Most current date

  • Thread starter Thread starter Art
  • Start date Start date
A

Art

I am trying to summarize a bunch of entries with a pivot table but can't seem
to get the format that I am looking to attain. I have copied out all my item
purchases, date and cost. I am trying to get the latest date and the amount
that I purchased it for. If I create a pivot table I can only get it to
return all the individual dates against an item. Is it possible to get the
most current date only?
 
Because the dates are just numbers, consider using the MAX() function.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Don't show all Pivot table subtotals 1
Determine Most/Least Frequent Date from List 2
Pivot Table with Data Model Connection - getpivotdata reference issue 0
grouping dates in a pivot table 1
Showing latest date in Pivot chart with total for all dates 1
Excel 2007 -- Dates in Pivot Tables in wrong order after refresh 1
identifying data from a separate worksheet 1
Pivot Table Summary Error? 6

Back
Top