Finding last cell of an array

**este994** · 07-26-2011, 07:14 AM

Hello, I wonder if someone can help me.

Im working on a tracker that gets updated by dumping data into a different sheet. I want a cell to show me the latest date of the paste, i.e. the cell needs to be automated to show the value of the last cell of the pasted array.

I hope that makes sense.

Many thanks.

E

**zbor** · 07-26-2011, 07:15 AM

Is last cell number or text? Or any?

**este994** · 07-26-2011, 07:17 AM

The last cell is a date. I want the first cell to show exactly what is in the other...

**este994** · 07-26-2011, 08:28 AM

Any ideas?

**Rahbee** · 07-26-2011, 08:42 AM

Is the array just one column? Are there any missing cells in the array?

**Rahbee** · 07-26-2011, 08:47 AM

Originally Posted by Rahbee

Is the array just one column? Are there any missing cells in the array?

If the array is just one column (i.e. the data you want returned is always in the same column) and there are no missing cells in that column, then this will work:

=INDIRECT(CONCATENATE("COLUMN",COUNTA(COLUMN:COLUMN)))

Where COLUMN = the column letter for the column containing the dates.

You will also have to format the cell containing this function as a Date.