Can you help me with a formula that would return the second to last that has data populated in the given range within a row? I will have 52 weeks of data going across. I want YTD value, 4 WK Avg value, 2WAGO value and current value. I have every column figured out except the 2 weeks ago heading. What formula can i use to return not the last cell populated in my range, but the next to last?