Excel on Mac Help

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

  1. kb22stang macrumors newbie

    Dec 15, 2009
    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


    May 26, 2004
    South Mississippi y'all, near the water!
    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

    Dec 15, 2009
    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

    Dec 15, 2009
    Got it, thanks for the help

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

Share This Page