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
5 years 41 weeks ago
6 years 27 weeks ago
6 years 39 weeks ago
6 years 42 weeks ago
6 years 43 weeks ago
6 years 48 weeks ago
7 years 4 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago