How do I DMAX only part of a column?

[Stu Leslie]

In EXCEL 2003, I have used this function
=DMAX(Incidents!O:O,"POB",Incidents!O1:O2) to find the highest figure in
column O of my Incidents spreedsheet but I can't for the life of me DMAX only
part of that same column on that same spreedsheet to get a year by year
highest total. I have tried changing the Database to be the portion I want to
DMAX without success. I have also fiddled with several different variations
of the criteria without success. O1 is column name "POB", O2 is blank, and O3
has "4" in it. I want to DMAX O546 thru to about O1000.
Help me and I'll be forever in your debt.
Thanks
Stu

 

[JBoulton]

If you have dates in another column you could use sumproduct.
You could also add to the criteria range to test for the dates. You would
do that by changing O1:O2 to O12. Then put the heading of the year column
in P1 and put the year you want to analyze in p2.
BTW, =MAX(O:O) would return the same thing as your DMAX formula.

 

[Stu Leslie]

JBoulton,
Thanks. As I haven't attempted sumproduct yet, I wasn't brave enough to give
it a try. However your MAX formula go me thinking ... and I've found that I
can just MAX the portion I desire. The formula box that comes up talks about
figures 1 to 30 so I assumed I could only select 30 cells ... NOT SO! I MAX'd
450 cells and gave me the result I desired.
Thanks again
Stu