Excel on Mac Help

Discussion in 'Mac Basics and Help' started by kb22stang, Oct 30, 2011.

  1. kb22stang macrumors newbie

    Joined:
    Dec 15, 2009
    #1
    Ok, I'm creating a spreadsheet to keep my check register and categorize my expenses. I have created drop downs for debt/check/deposit and for the categories of expenses. The only thing left to do at this point is that I want the spreadsheet to autofill the next check number when I use the drop down for "check". Does anyone know how this can be done?

    Thanks in advance.

    ----------

    For example:
    If(d1="check", last check #+1, 0)

    The section in blue is what I don't know how to do.
     
  2. iSaint macrumors 603

    iSaint

    Joined:
    May 26, 2004
    Location:
    South Mississippi y'all, near the water!
    #2
    last check # would be the cell number of the previously used check. I guess not all of your transactions are checks, though. If the cell is blank when it's not a check, then you could tell it to keep looking until it finds a cell with a number in it.
     
  3. kb22stang thread starter macrumors newbie

    Joined:
    Dec 15, 2009
    #3
    Thanks, any idea how to do that? I know a little about Excel but I'm out of my depth here. If I can get an idea of where to start I might be able to figure it out.
     
  4. kb22stang thread starter macrumors newbie

    Joined:
    Dec 15, 2009
    #4
    Got it, thanks for the help

    Here's the formula: =IF(B6="Check #",(MAX(C$2:C5)+1)," ")
     

Share This Page