Hello,

I'd like to have a formula to return the 2nd most common value from a column on one cell, and the 3rd one on another cell. Right now I'm using this one for the most common: =INDEX(RawData!O1:O10000,MATCH(MAX(COUNTIFS(RawData!O1:O10000,RawData!O1:O10000,RawData!K1:K10000,C1)),COUNTIFS(RawData!O1:O10000,RawData!O1:O10000,RawData!K1:K10000,C1),0))

One thing to bare in mind is that I'm restricting the values, such that another column has to return a certain value, hence Mode function probably wouldn't work.

Thanks for helping out!