Dear fellow forum members,

I have to equal sheets (dates in column A and Tickers in row 1) that choose stocks with two different metrics (gives the return from a returns sheet for a ticker in a given period if the metric statement is true).
I now want to combine those two metrics, is there a way to combine/consolidate the selections from the two sheets in a new sheet, where the returns from either the one or the other shows up, and in the unlikely event that the two are the same that it only will return the returns from that month once (i.e. a simple addition won't work..)

Hope this makes sense..

Many thanks for any input.

Best,
vonborge