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 in that row. The lowest 10 from Column C are shown in P784:P793 and the corresponding description from Column B is shown in Q784:Q793. How do I get the dates in Column A for the corresponding date to show in R784:R793. I have been some of the proper data to show in R:784-R793, but if there are ties then only one date is shown. I hope this makes some sense. Thanks for any help.
1 Reply
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
