Help with numbers!!!

[drich290195]

I have numbers please feel free to message me with how I can help

[Ads]

[Scavenger123]

I have numbers please feel free to message me with how I can help

Can I email the file to you?

[drich290195]

Can I email the file to you?

Yeah sure I'll send u my email

[Farnorth]

I am putting together a spreadsheet using numbers on my very first ipad (2) EVER! I have been using Microsoft FOREVER (first time with a MAC of any kind). This one equation is KILLING ME. Here is what I am trying to do.

I am a personal trainer and I track peoples weight. So, I have a column of cells that reflects the changes in their weight going from top to bottom. At the very bottom I have a cell that I want to show the "last number in the series of those weigh ins" i.e. each time I add a weight in an empty cell (of the progression) I want it to show up in that bottom cell. If you need a photo image I will be happy to send one. That's all. Very simple. The excel formula is using LOOKUP and a series of symbols and row/cell locations and works perfect. I feel like LOOKUP is what I want but what in the world do I use when all I have to work with is tabs that say "Search for" "search where" and "result-values". PLEASE help! I know there is a formula to do this. Thanks

Rick

I have exactly the same need (pretty much the same reason, making a diet tracking spreadsheet). After hours of research here is what worked for me. (B2:B64 is the range in the column.)

=INDEX (B2:B64, COUNTA(B2:B64))

Index & CountA are both functions. when usuing the iPad it is a bit difficult to figure out because you can not just type in the formula, apple holds your hand. When you put in the Index funtion you get all the "bubbles" to replace. touch on the ones you need to replace and in this instance you have to delete a few optional ones that are not needed.
(range) is the cell range you are looking at, delete (row-index) and (column-index) and the commas in between them. touch (area-index) and replace with COUNTA(B2:B64) {you have to use your finger to select the range, you can not just type it in}

Thats it. Worked like a charm. This cell then gives you the last entry in the range.

Hope this helps someone - it sure took me long enough to figure it out.


Farnorth.