Hi. I have a problem when using excel:
I am using the following formula:
=(1/(2*B20))*SUMPRODUCT(OFFSET($B$2:B14;0;0)-OFFSET($B$2:B14;F3;0);OFFSET($B$2:B14;0;0)-OFFSET($B$2:B14;F3;0))
My problem is that when I draw this formula down, the B14 increases to B15 and so forth. I would like the opposite to happen: When I drag it downwards, I would like B14 to become B13 and so forth. Is this possible?
We would need to know the starting row
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
My starting row is 2.
I don't know what values you have or much else about your worksheet. This however might work for you. It does count backwards from B14 as you fill the formula down the column.
Formula with commas
Formula:
Please Login or Register to view this content.
Formula with semi colons
Formula:Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Okay. Thank you very much for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks