Forum Discussion
Excel formula help needed
I have an excel spreadsheet that contains data in Colums A-J and rows 3-1000. I have done a formula to get the lowest 10 numbers (including ties) from column C to match the description in column B i...
The new FILTER function, combined with SMALL, may do all of the work you're talking about. Here's a video I watched just yesterday that shows how.
https://exceljet.net/lessons/how-to-show-top-or-bottom-n-results