# How can I code this in excel better?

I need to produce a set of numbers like:

(A,A+5,A+10,A+15,A+1,A+6,A+11,A+2,A+7,A+12, etc.)

It is not in sequence but more like a combination of sequences. Can it be done with less code?

Update:

I forgot to add that the numbers must be produced by a macro. I'm not sure how it is written though.

Relevance
• 6 months ago

YOur formula is missing a Function. Can you describe your excel sheet and perhaps we can get closer to what you may need.

What I mean is, what cells have what information and how does it all pertain to eachother? For example, the first A in your sample above refers to a column, not any particular cell. Being in parenthesis means it's some sort of excel formula, but has no function. As an example =SUM(a1+B1) would give you the total of adding the number in cell A1 to the number in cell B1. So, more info would help....

You don't need a macro, you can do this with a function RANDBETWEEN Read more here

https://exceljet.net/excel-functions/excel-randbet...

As an example, you would put the FORMULA

=RANDBETWEEN(lowest,highest) in cell A1

then each of the cells across the row would do your math for you.

B1 would be =A1+5

C1 would be =A1+10

D1 would be =A1+15

etc.

does this do what you needed?