stemer2003
New Member
- Joined
- Sep 17, 2020
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hi, sick of banging my head on this one. Hoping someone can help. I am okay with implementing VBA script, but not creating it, so I will take VBA or excel formula, whichever works best for you.
1) I need to find the maximum value for ? number of rows that is set by the structure level (Column A). In other words, if the value @ A4=2 then I need to know the maximum value in column C from A4 until the next 2 in column A but not including that row, so A8 in my example but don't include A9. A9 and the levels below it will roll up into A3 and A2.
2) Doubling up here, I also need to copy the data in a row (See E14 for example) to column (F) and copy it down until the next lower level level (F8 in my example).
Any help would be greatly appreciated!!
1) I need to find the maximum value for ? number of rows that is set by the structure level (Column A). In other words, if the value @ A4=2 then I need to know the maximum value in column C from A4 until the next 2 in column A but not including that row, so A8 in my example but don't include A9. A9 and the levels below it will roll up into A3 and A2.
2) Doubling up here, I also need to copy the data in a row (See E14 for example) to column (F) and copy it down until the next lower level level (F8 in my example).
Any help would be greatly appreciated!!