How to Ignore Duplicate find and match
hi everyone
i am having a problem with duplicate find and matching text, value in excel
using this formula
=INDEX($K$29:$K$62,MATCH(L22,$L$29:$L$62,0))
=LARGE($L$29:$L$62,$J22)
=INDEX($M$29:$M$62,MATCH(K22,$K$29:$K$62,0))
when same number match it match the same name
please review the attachment

Recent comments
7 years 25 weeks ago
8 years 10 weeks ago
8 years 22 weeks ago
8 years 25 weeks ago
8 years 26 weeks ago
8 years 32 weeks ago
8 years 40 weeks ago
8 years 40 weeks ago
8 years 40 weeks ago
8 years 40 weeks ago