|
|
How to find last row with number in a column in Excel?
|
|
|
|
Mac Elite
Join Date: Jan 2001
Status:
Offline
|
|
I have an Excel spreadsheet that I'm using to monitor my weight loss. In one column, I enter my weight each day; one day per row. I want to add a "Lost so far:" field, but not sure of a function in Excel that I can specify a range of cells or column and it spits how the last row with a number in it. Any ideas?
Thanks!
|
|
|
|
|
|
|
|
|
Professional Poster
Join Date: Jan 2001
Location: Australia
Status:
Offline
|
|
Why not just calculate the sum of the column for "lost so far:"?
Also try to swap bread and pasta for vegetables, and make sure you eat something for breakfast!
|
|
|
|
|
|
|
|
|
Dedicated MacNNer
Join Date: Jun 2000
Status:
Offline
|
|
This will tell you row of the last cell used in Column B
=MATCH(9.99999999999999E+307,B:B)
And this will tell you the value of that last cell
=INDEX(B:B,MATCH(9.99999999999999E+307,B:B))
and this will
|
Ignore the argumentative nature of this poster. He is old and can't engage in meaningful dialog
very long. Therefore, management asks that you at least humor him. Thanks.
|
|
|
|
|
|
|
|
Mac Elite
Join Date: Jan 2001
Status:
Offline
|
|
moon monkey: its not a column - its just one field that shows how much i lost all together
shades of gray - thanks! what were you going to say after the last "and this will"?
|
|
|
|
|
|
|
|
|
Dedicated MacNNer
Join Date: Jun 2000
Status:
Offline
|
|
I think I was combining two thoughts, and forgot to erase the last part.
But that happens when you are an old codger.
So, were those two formulas what you needed?
|
Ignore the argumentative nature of this poster. He is old and can't engage in meaningful dialog
very long. Therefore, management asks that you at least humor him. Thanks.
|
|
|
|
|
|
|
|
Mac Elite
Join Date: Jan 2001
Status:
Offline
|
|
Well "=INDEX(B:B,MATCH(9.99999999999999E+307,B:B))" worked in Google Spreadsheets once, but then when i tried typing another number into the next empty row, it showed an error of "N/A Did not find value 999999999...." and so on. Any ideas?
Thanks!
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Forum Rules
|
|
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
|
HTML code is Off
|
|
|
|
|
|
|
|
|
|
|
|