speedy dave
04-14-2010, 05:36 PM
Hi guys (again)
I am trying to figure out a formula to enter into a cell that retrieves the last entry in a column.
I have a formula... ( its not VBA but..... )
=INDEX('list'!D:D,MATCH(9.99999999999999E+307,'list'!D:D))
As you can see, the formula looks up and copies the last entry in column D ( of the worksheet "list" ) and pastes it to the cell that the formula sits in.
And it works fine...... but it will only retrieve "numbers"
I need to be able to retrieve "words"
What can I substitue the "9.99999999999E+307" with to return the text that is the last entry of that column ???
I am trying to figure out a formula to enter into a cell that retrieves the last entry in a column.
I have a formula... ( its not VBA but..... )
=INDEX('list'!D:D,MATCH(9.99999999999999E+307,'list'!D:D))
As you can see, the formula looks up and copies the last entry in column D ( of the worksheet "list" ) and pastes it to the cell that the formula sits in.
And it works fine...... but it will only retrieve "numbers"
I need to be able to retrieve "words"
What can I substitue the "9.99999999999E+307" with to return the text that is the last entry of that column ???