1. Due to the recent site upgrade, the iPadForums (iPF) App will no longer work. The new iPadForums.net website has been designed from the ground up to work perfectly from any mobile, tablet, or desktop computer using the built in internet browser. Create a shortcut to iPadForums.net on your home screen by following these steps: Create an icon for iPadForums.net

Help with numbers!!!

Discussion in 'iWork Forum' started by RickH, Apr 18, 2011.

  1. RickH
    Offline

    RickH iPF Noob

    Joined:
    Apr 18, 2011
    Messages:
    1
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Greenville SC
    Ratings:
    +0 / 0
    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
    Last edited: Apr 18, 2011
  2. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    15,985
    Thanks Received:
    1,850
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +1,994 / 1
    Banged my head against it for a while, but didn't get anywhere. I may try again later when my head stops hurting. :(
  3. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    15,985
    Thanks Received:
    1,850
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +1,994 / 1
    Ok, I still don't understand most of how this works, but the OS X version of Numbers has a weight tracking template that does what you want. I exported it to the iPad, and the formula still worked. If you look over the formula they use maybe you can tweak it to work on your spreadsheet.

    Here's a link to download the file: http://dl.dropbox.com/u/17742163/weight.numbers
  4. jakerich
    Offline

    jakerich iPF Novice

    Joined:
    Aug 12, 2010
    Messages:
    31
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    But, to do what you asked, double tap on the cell into which you want to put the formula. A window will open, tap the "=" on the bar above the keys, then tap the "functions" button, then "reference" and you will see Lookup as a function you can use.

    Teach a man to fish, etc, etc, etc.
  5. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    15,985
    Thanks Received:
    1,850
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +1,994 / 1
    I'm pretty sure the OP knows the function is there. They just couldn't decipher the use instructions. Neither could I. I spent quite a bit of time trying to use the LOOKUP function, but could not make it work as suggested. The formula that works in the Pages example uses different functions in combination with an IF statement. I think I understand it, but haven't looked up all the functions used to make sure.
    Last edited: Apr 18, 2011
  6. jakerich
    Offline

    jakerich iPF Novice

    Joined:
    Aug 12, 2010
    Messages:
    31
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    Perhaps he did know the function is there, but he said, 'all I have to work with is tabs that say "Search for" "search where" and "result-values".' To me that statement shows that he didn't realize a double-tap on the target cell opens up a greater set of choices. If you tap the cell once, that's what you get, you have to tap twice to get to the functions. But in either case, he now has options. It's all good!
  7. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    15,985
    Thanks Received:
    1,850
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +1,994 / 1
    I thought the same as you, until I looked up the LOOKUP function and realized what he was calling tabs were actualy the names of the parameters for the function, something I probably would not have noticed if I had not got curious and tried to set up a table to use it.

    As you say, no harm, no foul.
  8. jakerich
    Offline

    jakerich iPF Novice

    Joined:
    Aug 12, 2010
    Messages:
    31
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    Yep, you are right! I got it backwards. My apologies for questioning your inerrant intuition!
  9. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    15,985
    Thanks Received:
    1,850
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +1,994 / 1
    More like stubborn and pedantic. :) No apologies necessary.
  10. Scavenger123
    Offline

    Scavenger123 iPF Noob

    Joined:
    Oct 24, 2010
    Messages:
    5
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Denver
    Ratings:
    +0 / 0
    Large Spreadsheet test request

    I am looking for someone to test a large (about 12mb) Excel spreadsheet on the Ipad 2 that was too large for the original Ipad. I was considering Docs to Go but really do not care which app.
  11. drich290195
    Offline

    drich290195 iPF Novice

    Joined:
    Jun 12, 2011
    Messages:
    29
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    I have numbers please feel free to message me with how I can help
  12. Scavenger123
    Offline

    Scavenger123 iPF Noob

    Joined:
    Oct 24, 2010
    Messages:
    5
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Denver
    Ratings:
    +0 / 0
    Large spreadsheet

    Can I email the file to you?
  13. drich290195
    Offline

    drich290195 iPF Novice

    Joined:
    Jun 12, 2011
    Messages:
    29
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    Yeah sure I'll send u my email
  14. Farnorth
    Offline

    Farnorth iPF Noob

    Joined:
    Aug 23, 2011
    Messages:
    3
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    College Place, WA
    Ratings:
    +0 / 0
    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.

Share This Page

Search tags for this page
help numbers ipad
,
help using numbers for mac
,
how to add cells together in numbers on the ipad
,
how to create vlookup for numbers on ipad
,

how to do a lookup function in numbers for ipad

,
how to do a table reference in ipad numbers
,
how to insert function in numbers ipad
,
if function in ipad numbers
,
if statement numbers ipad
,
insert in numbers
,
ipad apple numbers spreadsheet help
,
ipad numbers tutorials
,
ipad numbers weight tracking
,
lookup function in mac numbers tutorial
,
lookup function numbers app
,
numbers functions ipad help
,
test for a non blank cell in apple numbers tutorial ipad
,
tutorial for apple numbers weight tracker
,
vlookup couldn't find the requested value ipad
,
wieght tracker in apple numbers using template