Forum Discussion
Solved
Help on a Formula for checkbook register
I am using excel as a checkbook register. I print my own checks but sometimes hand write a check on the same account so the numbers are not in series. I have a formula to auto increment my check nu...
=IF(B2="Printed Check",(XLOOKUP(1,ISNUMBER($A$1:A1)*($B$1:B1="Printed Check"),$A$1:A1,,,-1)+1),"-")
How about this formula in cell A2? Cell A1 has the start value 15100. Then fill the formula down from A2.
=IF(B2="Printed Check",(XLOOKUP(1,ISNUMBER($A$1:A1)*($B$1:B1="Printed Check"),$A$1:A1,,,-1)+1),"-")
How about this formula in cell A2? Cell A1 has the start value 15100. Then fill the formula down from A2.
That works great, thank you!
