getting max value of unique dates in a range

I

ibeetb

I have a 2 ranges both with 16 rows. 1 column has dates with 4 dates being
repeated 4 times, which make up the 16 rows. The other colum has values that
correspond to each of the dates.
I need a formula to scroll through the dates and get the max value from the
value column of all LIKE dates.....

Is this possible
 
B

Bernie Deitrick

ibeetb,

One word: PivotTable. Okay, it's really two words, smushed into one, but the end result is the same.

Select your data, the choose Data | PivotTable....

In the Wizard (XL97) or from the commandbar (XL2000 up), drag the date button to the row field, then the values button to the data
field, and change the default field setting from SUM oto MAXIMUM.

And you're done....

HTH,
Bernie
Excel MVP
 

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

Autonumber field in Excel that behaves the same as Access 0
Need Help with a VBA subroutine 0
IF ARRAY with multiple conditions. 1
Lookup in multiple & separate cells 6
difficult VLOOKUP question: 2
MS Project. Real progress of the project, % complete 1
Help needed with If & Today function 4
Problem with formula for finding last greater than/less than or equal to value 2

Top