Microsoft Excel - Find last cell value
Asked By Loo KL
16-Apr-10 04:48 AM
Hi Everyone,
I'd like to find last entered values in a range. Can excel formula do this?
Example :-
Column A B C D E
Values 5 4 0 3 2
Result I want is value '2' , because this last entered value in column A - E range.
Thanks in advance.
Loo
Anoop S replied to Loo KL
You can use this simple formula to find last number entered in a column( eg for column-A)
=INDEX(A:A,COUNT(A:A))
and
For ind last number entered in the row by(eg for row -1)
=INDEX(1:1,COUNT(1:1))
Super Man replied to Loo KL
=INDEX(A1:E1,COUNT(A1:E1))
Rolf Jaeger replied to Loo KL
The formulas provided to you so far fail if there is a blank entry in your 'Values' row. Assuming that you have a header row (in this example row 1) with no blank cells and assuming that your 'Values' row is row 2, this would be a more reliable formula:
Hope this helped,
Rolf
Loo KL replied to Rolf Jaeger
Hi Everybody,
Appreciated the advice.
I use below formula, It work fine!
=INDEX(A1:E1,COUNTA(A1:E1))
Thanks.
Formula Excel What is a formula? Excel New Users Discussions Microsoft Excel (1) Excel (1) BiffMicrosoft (1) http: / / dictionary.reference.com / - - Biff Microsoft Excel MVP This link might be helpful to you. . . http: / / www.lmgtfy.com / ?q = excel
Excel Formula Excel What EXCEL formula can I use for the following: Cell E4 has Nov-09 (11 / 1 / 09 shows Oct-09 $12, 880.00 Nov-09 $85, 904.50 Dec-09 $39, 403.25 Excel Discussions Microsoft Excel (1) Excel (1) Worksheet (1) VLOOKUP (1) Dec (1) Bliengme (1) Month (1) = VLOOKUP(E4
How do I delete a header in Microsoft Excel? Excel I would like to know how to delete a header in Microsoft Excel. Can you help? Excel Miscellaneous Discussions Microsoft Excel (1) Excel 2007 (1) Page (1) Workbook (1) SQRT (1) VBA (1) ShowFormula (1) Anne
what does "" signify in an Excel formula Excel Can anyone help? Excel Worksheet Discussions Microsoft Excel (1) Excel (1) LN (1) Kirill (1) EE98DF1BD66D (1) Constants (1) It literally means nothing = IF(A1 = "", " it is empty", "data found") So the above formula looks if A1 = "" i.e. nothing and if that true returns 'it is empty". Mike
CHANGE CASE COMMAND IN MICROSOFT EXCEL Excel Microsoft Word contains the command of CHANGE CASE which is very useful, but Microsoft Excel does not contain this command due to which its too much difficult as rewrite the whole content of a cell. Cant this command be available in Microsoft Excel too, I think its not hard for Microsoft Corporation. Or if this command is available