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.
=INDEX(A2:A,COUNTA(A2:A),1)) by @EricSmalling in StackOverflow Get the last non-empty cell in a column in Google Sheets. You can apply this to your scenario