It is hard to know from your postings if you know in advance all the
possible entry values in Column A or not. Assuming you don't, will this be
acceptable? Place this formula...

=IF(A2="","",IF(COUNTIF(A$2:A2,A2)1,"",MAX(IF((B$ 2:B$100<0)*(A$2:A$100=A2),C$2:C$100,""))))

In Row 2 of some unused column and copy it down... the first occurrence of a
value in Column A will show the maximum date you are looking for.

--
Rick (MVP - Excel)


"Carrie_Loos via OfficeKB.com" <u34134@uwe wrote in message
news:8a95b0252cffd@uwe...
Thanks but my issue is to try and get the max date in the range only for
those unique instances. Example: any that are labeled "AnthonyJan-08" then
another max for any that are labeled "AnthonyFeb-08". With a SUMIF I can
point to a cell and define the range to look in by that cell value.
Secondly,
since my range cycles through different people and all the calendar months
I
was hoping not to have to rewrite the formula over and over again like a
SUMIF. Is it possible?

Rick Rothstein wrote:
Try this array-entered** formula...

=MAX(IF(B2:B100<0,C2:C100,""))

**Commit the formula with Ctrl+Shift+Enter, not just Enter by itself.

Change the upper end of the ranges from 100 to the maximum row number that
will ever contain data.

I can't figure out this array formula - can anyone assist?

[quoted text clipped - 49 lines]
AnthonyFeb-08 2.0 02/07/08
AnthonyFeb-08 2.0 02/08/08

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200809/1