Say I want the following cells to be captured up to 999 but every other one.
B2,B4,B6 ect to G2, G3, G4 and
B3,B5,B7 ect to H2,H3,H4 and so on.
Is there a formula that can do this? I use the following formulas to generate serial numbers as seen in the attached. So far I have manually set the above mentioned locations but was hoping to do this with a formula instead similar to how my sequence formula works.