In the attached file i've a column of data that goes up and down and in the 2nd column it's a more smoothed set of numbers. Essentially if row B is bigger than row A give me row A based on column 1. But what I want to do is if row B is bigger than row A give me row A but from column 2 so that where there's the 55 and 70 it's actually 5.
Doesn't matter what I try seem to continually get circular references. Easy to do in excel (naturally!) Any ideas??