Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Trying to calculate next sequential number using multiple columns
Starting in Cell AI8, calculate the next sequential number using the last number from Column B. But only calculate for Cell AI8 if AG8 = "1'.
In the screenshot attached, Cells AI8 and AI9 should remain blank. AI10 should be 1261. AI11 should be 1262. AI12 should remain blank because AG12 is blank. The next sequential number should be 1263 in AI18. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to calculate next sequential number using multiple columns
Can't see your screenshot - resolution too low...
Are you looking for a VBA solution or a worksheet formula? You should take a look at the =MAX() worksheet function, something like: =IF ( AG8 < 1 ; "" ; MAX ( AI$8 : AI8 ) + 1 ) ....that's the worksheet formula, I would make, and then copy down as long as needed. It should be fairly easy to convert this to VBA, if you want to :-) CE "copastor" wrote in message ... Starting in Cell AI8, calculate the next sequential number using th last number from Column B. But only calculate for Cell AI8 if AG8 "1'. In the screenshot attached, Cells AI8 and AI9 should remain blank. AI1 should be 1261. AI11 should be 1262. AI12 should remain blank becaus AG12 is blank. The next sequential number should be 1263 in AI18 +------------------------------------------------------------------- |Filename: Screenshot 2014-04-25 15.05.21.jpg |Download: http://www.excelbanter.com/attachmen...tachmentid=971 +------------------------------------------------------------------- -- copastor --- Denne e-mail er fri for virus og malware fordi avast! Antivirus beskyttelse er aktiveret. http://www.avast.com |
#3
|
|||
|
|||
Thank you for your response! I am looking for a worksheet formula as I am VBA challenged! I tried this formula and it didn't work. I'm not sure what else to do to explain what I am trying to achieve.
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate the number of Columns apart | Excel Programming | |||
Fill Right Variable Number of Columns, then Calculate Using Offset | Excel Programming | |||
calculate average from multiple columns and put results in a new s | Excel Programming | |||
Formula help, calculate dates and name in multiple columns | Excel Discussion (Misc queries) | |||
Calculate sequential value for future date | Excel Worksheet Functions |