how do I look up the last instance and calculate based on last input,
disregarding the previous input.

=LOOKUP("x",B46:AF46,B1:AF1)+7

In other words, if "x" is inputted twice on consecutive rows, then calculate
based on the last entry.