This is part of what I was looking for but need one more step. I have a huge
list of participants in a study. I wanted to look through this huge list and
find the max of weight loss among Men. I have a variable M/F so I can find
the max number but what I would llike is a function that will also give me
the person's name associated with this max number - in a different column of
same sheet. Is this possible? I appreciate anyhelp you guys can give.

"Sandy Mann" wrote:

"irvine79" wrote in message
...
Thanks, worked perfect! One more question, what does Ctrl + Shift + Enter
accomplish?


It makes Excel work on each elemant of the first array with the first
element of the second array. ie:

=SUM((A1:A3)*(B1:B3))

work out as

=SUM(A1*B1,A2*B2,A3*B3)

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"irvine79" wrote in message
...
Thanks, worked perfect! One more question, what does Ctrl + Shift + Enter
accomplish?

thanks

"Sandy Mann" wrote:

Try:

=MAX((MONTH(B1:B1000)=MONTH(TODAY()))*(H1:H1000))

This ia an array formula so enter it with Ctrl + Shift + Enter not just
enter.

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"irvine79" wrote in message
...
Column B = All dates for this year.
Column H = production figures entered daily.

My goal is to come up with a cell that calculates the max daily
production
figure for the month by referencing today's date to find which month to
consider.

I am using a sumif formula to calculate the month's cumulative
production
figure but haven't figured out how to find the highest daily figure of
the
month.

=SUMIF(B3:B262,TEXT(TODAY(),"mmm"),H3:H262) ...

Basically in need a MAX version of the above formula.

Thanks!