In C9 I have 14
In C15 I have 27
C10 - C14 I want to fill in even spaced numbers
(27 - 14)/6 cells = 2.166666 which would be applied to cells C10 - C14
C9 = 14; C10 = 16; C11 = 18; C12 = 20; C13 = 23; C14 = 25; C15 = 27
I have a bunch of different numbers in the column that I want to easily apply this to. How is this done with a formula??
Hi and welcome to the forum!
Highlight the range C9:C15. Go to Home/Fill/Series. Excel should be able to detect what you wish to do (you should see a Step value of 2.16666666666667, etc.). Just press OK.
Format cells with desired number of decimal places.
Regards
Try This
14
=C10+($C$15-$C$10)/6
=C11+($C$15-$C$10)/6
=C12+($C$15-$C$10)/6
=C13+($C$15-$C$10)/6
27
Thanks a lot! That was just too easy
I have to do this to over 100 different times in the same column...is there an easy way to apply to the whole column??
Can you post a sample workbook so we can see precisely how your data is laid out? It doesn't have to be your actual data - a mocked-up version with dummy data will do, just so long as it illustrates what you are trying to achieve.
Regards
Here is a short example of what I am trying to do.
Apply between 126 & 150; 155 & 180; 186 & 281. I have over 100 to apply this to...what is the easiest way?
C2 126
C3
C4
C5
C6 150
C7 155
C8
C9
C10
C11 180
C12 186
C13
C14
C15
C16
C17
C18
C19
C20
C21
C22
C23
C24
C25
C26
C27
C28
C29
C30
C31 281
Here you go.Excel Help.xlsx
See attached to see it in action
Please Login or Register to view this content.
How do I use this as a template? I want to be able to past different numbers in the file.
Not sure what that means.
Did it work for you?
Yea I didn't explain it very well
I want to be able to use this as a template for other times I can paste numbers in and get the results. I messed with it a little bit and it seems to work when I past numbers in column H.
Yep, just change the columns.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks