Hello,

I am trying to create an equation that would automatically pick up the last
known data point in a range. For example, I have all the months starting from
Row 3 Column C, and in Row 3 Column 1, I need to create a function that would
pick up the most recent data point and place it in that cell, C1. So, if
there was something in March, it would replace February, if there was
something in July, it would replace June in C1. Please help. Thanks!