inputting sequential numbers from one cell

[stephen1000]

Hi Guys

novice to say the least, but really getting into math and formulas

I am trying to make excel list in a column like 1,2,3,4,5. this is dependant on a value i place in one cell eg 5

i want excel to then place 1,2,3,4,5 in seperate cells down a column. does this make sense.

then the calculations will only appear the the numbered cells.

help can this be done

[Cheeky Charlie]

Title your thread better, then perhaps post an example, probably because you're not very used to Excel, your decription is a little unclear.

CC

PS you will not get any help until you retitle your thread

[stephen1000]

sorry for being thick what should i rename it to, I know what i want to achieve, but do not know the question.

[stephen1000]

please help, and i am sorry you have stumbled into to this

[stephen1000]

Hi I think I have attached the workbook

please feel free to look at it page 3 is the page I am trying to sort out.

page 1 is another calculator i have made

cheers

[stephen1000]

Hi Iam trying to populate a column with numbers ie 1,2,3,4,5 from one cell showing ie 5

I know what I want to acheive but do not know the question

sheets 3 is the sheet

no of pockets =5.5
i want the column to number down 1,2,3,4,5 so that the calculations add from 2 to 5 adding the one before to the next.

does that make sense not sure please take a look.

have a look at sheet 1 its another calculation we use

thanks anyone

[shg]

Are you talking about the calculation on Sheet3?

Are the numbers that are there correct?

Can you provide some background on what you're trying to do?

[stephen1000]

Hi yes sheet 3

we manufacture soft furnishings drapes and blinds.

E3 is the finished drop of the roman blind.

E5 is the allowance to take off for the headrail it is attached to.

E7 is the number of pockets we require this changes depending on the size of the blind (drop)

E10 is the distence down from the top of the roman blind (where we sew a pocket.
E11 is the distance of the second pocket from the top of the blind.

and so on
column D needs to return the 1,2,3,4,5 etc of the inputted number in E7

at the bottom of the blind there is a half pocket this is where it gets complicated

do you understand what i am trying to acheive?

sheet 1 is another calculator i designed it does not add one measurement to the next, but works. I am looking into alternatives


cheers

stephen

[shg]

So are the numbers in E10:E18 correct, and if not, what should they be?

[stephen1000]

the values are correct, but you see there are 9 it needs to show 7

if E7 shows 5 then I want only to show 5 and the values in the next column to go upto 5

[Cheeky Charlie]

How about this in D11 copied down?:
=IF(ROW()-9<$E$7,ROW()-9,"")

You might want to change E11 to:
=IF(D11="","",($E$3-$E$5)/$E$7+(E10))
and similar copied down

HTH

PS thanks for editing your title etc. it makes the forum so much better to search... and the flurry of posts look ridiculous but we know you mean well

[stephen1000]

normally there are no more than 10 pockets to a blind

[stephen1000]

sorry cheeky, not sure what you mean?

[stephen1000]

pasting into D11 returns a circulat reference

[Cheeky Charlie]

put 1st formula in D11 (typo in post before)
put 2nd in E11

Copy down.

Life is good and has meaning.

God is good.

What don't you understand?

CC

[shg]

This looks correct to me ...

[stephen1000]

I think I know what you are saying looking good

[Cheeky Charlie]

pasting into D11 returns a circulat reference

Not on the example workbook I have...

[stephen1000]

we are cooking

now.

the values returned ie 7.5 only needs to show 7 and then 1/2 pocket is E3 - E5 / E7

you guys are amazing been looking at this for two days. not quick but so willing to learn.

thanks

[stephen1000]

cheeky just uploaded your spreadsheet looking good

[Cheeky Charlie]

What an enormous thread for a fairly small question!

If the thread is solved, please mark it so, if not, ask shg, I'm going to bed! Hope it all works out.

CC

[stephen1000]

getting there, only thing now all of the pockets ie 1,2,3,4,5 etc plus the 1/2 pocket needs to add up to E3?

[stephen1000]

sorry shg can you shed light on why the values do not add up to E3?

you guys are amazing, so helpfull to a mear mortale.

thanks

[stephen1000]

shg are you still around?

I am logging off now

thank you for your input.

[stephen1000]

Thanks to shg & cheeky charlie