Excel on Mac Help

[kb22stang]

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.

 

[iSaint]

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.

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.

 

[kb22stang]

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.

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.

 

[kb22stang]

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.

Got it, thanks for the help

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

 

[iSaint]

Great!