How to repeat a formula automatically every nth rows?
Hi there,
I need to have a formula to repeat every 24 rows. This formula calculates the rate of change for every 24 hrs of inches of water in a tank in percentage.
I need to have this formula display every 24th row (for each new day)
There is no way I am going to do it manually for thousands of rows...
I don't know how to do this and any help would be greatly appreciated.
Thanks!
Hi,
Here's a quick way to do it :
In F1 type "Temp"
In F2, type =MOD(ROW(), 24)
Your formula is on the value 15.
So filter your data on row F on value = 15
Now go in E15 and copy (CTRL +C)
Move one cell right
CTRL + DOWN
LEFT ARROW (you should be in E11799)
CTRL + SHIFT + UP
CTRL +V (to paste data)
Unfilter data in column F and delete this temp column.
Done!
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
I think this way of generating the formulas wouldn't work out as intended.Originally Posted by GC Excel
Edit : I'm not intending to add any disrepute to the above post, but I tried this solution and it was not working. Just wanted to highlight the same. My sincere apologies XOR LX.
Last edited by Saarang84; 05-20-2014 at 02:58 AM.
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
Hi,
How about, in E2 and copy down:
=IF(INT(A2)=A2,(B25-B2)/ABS(B2),"")
@Sarang That's not a very constructive comment: perhaps you could explain why you think that, rather than just saying "I don't think that will work".
Regards
Hi ,
Clarify the formula in E39,E63 & 87, they are varying pl z check and confirm which was to be taken into consideration .
Regards
Ravi
Hi ,Backup System Rate change.xlsx
Please have a look this sheet .
Regards,
Punnam
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks