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
6 years 7 weeks ago
6 years 45 weeks ago
7 years 5 weeks ago
7 years 7 weeks ago
7 years 8 weeks ago
7 years 14 weeks ago
7 years 22 weeks ago
7 years 23 weeks ago
7 years 23 weeks ago
7 years 23 weeks ago