Thank you Smartin,

That function works great. Just had to modify the blank cell check to E2=E4
or A2<A4.
Appreciate it,
Wox

"smartin" wrote:

Hi, I'm not sure if this is what you need, but give it a look.

=IF(OR(E2=E3,A2<A3),"",(C2-INDEX(C:C,MATCH(1,(E2=$E$1:$E$999)*(A2=$A$1:$A$999 )*(B2=$B$1:$B$999),0),1))/365)

Wox wrote:
Sorry, when I said area, actually meant type, which can be 'a' or 'b' in
alternating rows. The formula currently will look up the first instance of
the grade in the current row, regardless of whether that first instance is
type a or b. I would need the formula to make a check for the earliest grade
of the correct type within the current location.
Hope this helps,
Thanks again for your time,
Wox

"smartin" wrote:

Hmm, "area" was not in the original description. Can you show how the
layout?

Wox wrote:
Thanks for the reply Smartin,

Your formula 4 is really close I believe, and much more efficient than what
I was trying to use. The results do need to be separated out by location, but
also by area. This is what was tripping me up, as they are entered in every
other row. I think this is a little closer, but still not quite right:

=IF(OR(E2=E4,A2<A4),"",(C2-INDEX(C:C,MATCH(1,(E2=$E$1:$E$999)*(A2=$A$1:$A$999 ),0),1))/365)

Thanks for any additional time you can help out,
Wox