Guys,
The Large() function does not return the correct value in a range that has been filtered. As a workaround I have to copy the filtered range into a new sheet and apply the large function to get the correct result. While this method is clunky, it works.
Just wondering if there is any other built in formula to return the nth largest value in a filtered range without having to do the copy and paste. Or an array formula?
Regards
Bookmarks