I need to create a report that pulls the last 3 cell values in a column.
This will need to be in three separate cells.
Column C will contain data which will be added to daily.
- D2 will contain the value of the last but 2 cell in column C.
- D3 will contain the value of the last but 1 cell in column C.
- D4 will contain the value of the last cell in column C.
Note : I'm using Google Sheets.
Any help will be greatly appreciated.