mcarter973
Board Regular
- Joined
- Mar 24, 2002
- Messages
- 83
is there an excel formula for determining the last value entered in a range (column of data) or can the answer only be achieved thru writing code?
thanks
thanks
On 2002-08-29 12:31, Ekim wrote:
If your data is in say B5:B50 -
To find the last number:
=INDEX(B5:B50,MATCH(9.99999999999999E+307,B5:B50))
or
=INDEX(B:B,MATCH(9.99999999999999E+307,B:B))
If your range includes text (or a mixture of numbers and text) use:
=INDEX(B5:B50,COUNTA(B5:B50),1)
Regards
Mike