Hi Geniuses,
I am looking for a formula to do the following:
1. Take a value (($100, for example))
2. Divide by X ((4, for example))
3. Apply the quotient ((25)) across X # ((4)) of Columns starting at a particular column as noted by Month and Year
 If a column is NOT relevant, it should be blank. I may extend the month and year combos in any direction (Months 2022 through Months 2025, for example)
 I want to be able to edit values in A2  C2 and have this formula autopopulate (for exmple, change the value, Divisor or date or any combination)
Visual:
Thank you!
I am looking for a formula to do the following:
1. Take a value (($100, for example))
2. Divide by X ((4, for example))
3. Apply the quotient ((25)) across X # ((4)) of Columns starting at a particular column as noted by Month and Year
 If a column is NOT relevant, it should be blank. I may extend the month and year combos in any direction (Months 2022 through Months 2025, for example)
 I want to be able to edit values in A2  C2 and have this formula autopopulate (for exmple, change the value, Divisor or date or any combination)
Visual:
Header Row  A1 Value 

 D1 Aug 2024  E1 Sept 2024  F1 Oct 2024  G1 Nov 2024  H1 Dev 2024  I1 Jan 2025  
Data Row  100  4  Sept 2024  25  25  25  25 
Thank you!