Last Occurrence of Values In A Range

[bjnockle]

Looking for formula to return last occurrence of numbers in column C. The last occurrence of numbers to return is column C and the desired output/desired results is in column D.

The formula should be based on column A and B for it to look into column C and then return the last occurrence in the desired column, which is column D.

Only values with 1s in column B should be made to return the last occurrence value in column D. Formula should be setup to return blank for values with Zeros (0s) in column B.

Please Login or Register  to view this content.

See sample file.

Thanks

[mehmetcik]

Formula for cell D2 and then fill down =IF(AND(C2<>C3,B2=1),C2,"")

[hrlngrv]

If there could be different years in col A both with 1 in col B,

D2:

Please Login or Register  to view this content.