How do I DMAX only part of a column?

G

Guest

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
 
G

Guest

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 O1:p2. 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.
 
G

Guest

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 O1:p2. 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.
 
G

Guest

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
 
G

Guest

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
 

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

Adding only part of a column of data 3
Find & replace different years (part of the date)in a column 1
How do I get the last number from a specific column 6
How to UN-hide column A? 3
How do I markup a column of numbers without adding a column? 4
A sort of lookup or match 1
how do I print the contents of a cell that is over the max limit? 2
How Do I Find Different Values In A String? 2

Top