Hello!
I've created a spreadsheet that is calendar based. At the end of each month I manually populate a figure that correlates to any given month (e.g. Cell A1 has text 'Jan', B1 has text 'Feb' etc, and in cell A2 I'd manually fill in a number that correlates to Jan, in B2 I'd fill in the number that correlates to Feb etc etc).
What I'd like to happen is to have a totally separate cell that shows the most recent months number (e.g., if March was the last month with any data, the separate cell would know to populate itself with that data and ignore all upcoming months as there is no data populated yet). This would automatically update with the next latest months number as and when I manually update the next month.
I hope this makes sense but happy to help clarify if any is needed.
Thanks in advance.
John
I've created a spreadsheet that is calendar based. At the end of each month I manually populate a figure that correlates to any given month (e.g. Cell A1 has text 'Jan', B1 has text 'Feb' etc, and in cell A2 I'd manually fill in a number that correlates to Jan, in B2 I'd fill in the number that correlates to Feb etc etc).
What I'd like to happen is to have a totally separate cell that shows the most recent months number (e.g., if March was the last month with any data, the separate cell would know to populate itself with that data and ignore all upcoming months as there is no data populated yet). This would automatically update with the next latest months number as and when I manually update the next month.
I hope this makes sense but happy to help clarify if any is needed.
Thanks in advance.
John