Second Largest Value with criteria in excel
I'm trying to find the second largest value of a given criteria in excel. So the formula I was trying to use was
The problem is that it is returning the second largest overall value, but I want the second largest value where column B is 1. Better Answers would be helpful.
You are using an array (CSE) formula and you did not enter it the key combination for array formuas. Edit the cell again and click
Or if you want a normal (non CSE) formula, use this: