I have two columns, one with the date, sequentially, and then one for the corresponding number/data for that day. I have a third cell that I just want to update to the most current date this has numbers entered. Hopefully the example below makes this clear. I feel like there should be a simple solution, but everything I Google only comes up with finding max or min dates, or the current date. VLOOKUP wont work because my dates will not always be to the left of the data. Any help much appreciated!
EDIT: The Date Column will always be the leftmost (Column A) but the column with the data being entered might be several columns over.
Example Sheet | Want the Date Here: Example 4 Oct |
Date | Data |
2 Oct | 13 |
3 Oct | 12 |
4 Oct | 17 |
5 Oct | |
6 Oct | |
7 Oct |
Last edited: