Formula repeat problem

[szhabi]

Hi,

As my issue I am trying to avoid some manual work and have some more elegant method using formulas to address my issue.

Instead of trying to copy over my formula in the bottom, and then pull over the formula to the correct columns, I tried to identify the rows which I have to copy. I was able to identify the columns which I am targeting but having issue copying that array into the formula.

Is there a way to do this?

I would like to somehow automate it so you only have to copy over the two columns in the bottom and then it will automatically match.

I am trying to avoid macros and focusing on formulas only.

Thank you in advance.

[szhabi]

I really struggled with this for a few days now, and couldn't find any solutions online or anywhere else, so I am hoping some of you more experienced folks would be able to help me out. Thank you

[szhabi]

I was hoping someone would be able to help me out with this.

[FlameRetired]

szhabi please stand by. I've been working on this one. It has been taking me a while.

I have a question. In row 92 I see CW1, CW2 ... 3,4 etc. Each is separated by a blank cell. May we fill in those blanks with their "twin" CW#s mates? It makes an already complex problem slightly less complex. If not it can still be done.

[szhabi]

Dave,

Yes of course. That is not an issue. Appreciate your help.

[FlameRetired]

szhabi in row 92 of the attached find the modified headers I referred to.

It is difficult to verify correct returns because of the RANDBETWEEN functions in the source data. The attached retains those.

This formula in B93 filled down and across does what the manual formulas did. I left the #N/A errors in place. If you don't want those wrap IFERROR around them.

Please Login or Register  to view this content.

[szhabi]

Wow! Amazing! I am trying to understand your formula, it is very impressive. Thank you!

[FlameRetired]

You are welcome. Thank you for the feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.