Hello,

I am new to this forum and hope to get your help!

I have a complex excel formula with many conditionals, and trying to "apply" the formula to a datasheet of 5,000 rows.

It would actually be difficult to copy the formula 5000 times. I am wondering if it is possible to keep the formula in 1 sheet in excel, and apply it to 5000 rows on another sheet to calculate 5000 results?

I have done a lot of google searching but I don't think I've come up with the right terms to describe what I am looking for, hope to get your help.

Thank you!
Shawn