I am working with large Excel stocks data. I have the data in a format like this,

What I need to do is, I need to set that stock ticker name in front of the cell which loss is less than -10%.

I can try with the simple =IF(B2<-0.1, "AAL", "") formula, but this will work until the next stock starts, I mean in AADI also it will print "AAL", that's the problem. I need to print the right ticker if this condition is true. If it's AAPL, the ticker AAPL should print in front of the loss cell. So, How can I do that?

Don't know how to complete this while I am having millions of data points. I should know a good solution using Python, VB, or Excel formulas.

CodePudding user response：

IIUC, here is a simple proposition using