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