Working on creating a Top 10 and Bottom 10 report however when Indexing and Matching it is bringing back duplicate responses. Have tried a lot and no success.
Below is the image of the cells and here is the formula I am using.
=INDEX('Missed Opportunities'!$C$3:$C$65,MATCH('Market Preview'!B5,'Missed Opportunities'!$O$3:$O$65,0))
Screenshot 2023-08-25 at 10.22.44 AM.png
Bookmarks