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 auto-populate (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 auto-populate (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!
