I have a formula to find 2nd largest value in a range with dulicates
=LARGE(IF(rangeB<LARGE(B2:B500,1),B2:B500),1)> < LARGE(</LARGE(B2:B500,1),B2:B500),1)>rangeB,1),rangeB),1)
I also have another formula to find the second largest value given the condition that the
=LARGE(IF(rangeA="cell...