J
Jeremy
I have a worksheet I am stumped on:
I have a row that is sorting data with an IF statement the
if statement returns either "REHAB" or "Review". I need to
know the year that the REHAB value is returned (I have the
year labeled in a different row immediately above the
REHAB/Review row).
I would like the formula to search for REHAB and return
the 1st year that REHAB appears and stop. From there I
will add 20 years to the returned value.
Any ideas?
I have a row that is sorting data with an IF statement the
if statement returns either "REHAB" or "Review". I need to
know the year that the REHAB value is returned (I have the
year labeled in a different row immediately above the
REHAB/Review row).
I would like the formula to search for REHAB and return
the 1st year that REHAB appears and stop. From there I
will add 20 years to the returned value.
Any ideas?