Duplicate Data Index Match. Once match runs the formula simplifies to. Index match remove duplicates in the attached workbook i m trying to create a drop down list d2 to return matches to skew c2 without duplicates from array c5 d3240.
Is there any way to rewrite this formula to return a list of unique distinct values and avoid duplicate returns. Hold down the alt f11 keys to open the microsoft visual basic for applications window. Index a 2 a 11 match large b 2 b 11 e2 b 2 b 11 0.
Hold down the alt f11 keys to open the microsoft visual basic for applications window.
Click insert module and paste the following code in the module window. Please login or register to view this content. Index a 2 a 11 match large b 2 b 11 e2 b 2 b 11 0. It will not fetch the second name of duplicate score.
