Forum Discussion

TimeToAscend's avatar
TimeToAscend
Copper Contributor
Dec 14, 2022

Urgent help with formula.

Hi there, I have been stuck for days trying to figure out a seemingly very simple task. Help would be greatly appreciated!!!

 

In 'column S', I am trying to make every 24 rows fill with the data found in 'Column K' in the following trend = 

 

First 24 rows i.e. each row with ID (Column P) of '1', should be filled with value '49.85' found in 'Column K'. 

 

Then each row with ID '2' should be filled with value '102.03' from 'Column K', and so forth. 

 

I have absolutely no idea. 

 

Thanks for any help!

Resources