Does anyone know how to go about creating a formula in Excel that would convert a cell saying 1-100

into a cell saying 1, 2, 3, 4, 5 (etc. until it has reached 100)

thanks!

cell a1

1

cell a2

=A1+1

drag cell a2 to cells a3-a100

done

i know that one, what i'm trying to do is to put all those values (1 thru 100) into ONE cell with a comma space seperating them.

like this:

I'll see if I can do it, possibly with a macro? hmm

you'd be my hero.

1. Go to Tools -> Macros -> Visual Basic Editor
2. In Visual Basic Editor, go to Insert -> New Module

In the window that comes up, enter this:


Save and close Visual Basic Editor.

3. Enter this in the cell you want the list to appear in:

Except replace "D7" with whatever the cell with the "m-n" value is in.

thanks so much for trying to help me out, but it doesn't work...

Are macros enabled? Did you replace all the occurrences of "D7" with the correct cell?

Try just entering "=LIST(1,10)" in a cell and see if it works. If that doesn't work, then it's either a security setting or something went wrong entering the code.

its working now thanks so much man!!

a question though; will this also work if the cell for example is like this:

1, 3, 5, 7-10, 11, 12-14, 16 ? or does the orginal cell have to be value-value?

also i need a comma space instead of just a comma



would that fix that issue?

That would fix if, or you could just put the space right between the comma and end quote.

And it will only work for "value-value".

oh man this is gonna help me so much, thanks so much $úñ_DëV|L.

$úñ_DëV|L is wicked smart.

and we're back.

right now i have a formula like this:



and it works perfectly fine.

but some new columns were added to the spreadsheet, so i have to edit the formula, like such: (new part is in red, part that doesn't work in blue )



but like i said the blue part is fucking up the formula, at least that's what excel says.

Me and a bunch of co workers have been working on this now and even rebuild the formula from scratch, but it won't work. it keeps ignoring the blue part.

anyone have an idea?

yeah that's it, keep them coming.

i found a way around it, but for future reference i'd love some suggestions(/a suggestion).

Sorry bro. I hate excel, and I hate formulas

</END THERMONUCLEAR DEVICE>

that's cool. i love anything number/formula related, which is why i'm so frustrated that i can't figure it out.

First of all, the formula is not using a circular reference is it? What type of error are you getting?

The other possibility is that excel only allows a certain stack height when it comes to function calls. I would recommend a 10-deep nesting of if statements.