Current location - Loan Platform Complete Network - Big data management - The following set of data: Find the largest number in column A and return the corresponding value in column B; then return the second, third... Large values, duplicates to be found together
The following set of data: Find the largest number in column A and return the corresponding value in column B; then return the second, third... Large values, duplicates to be found together
Repeated values, we must add a correction value in the formula, VLOOKUP function can not be resolved, you can use INDEX or OFFSET function to solve.

=INDEX(B:B,MATCH(LARGE($A$1:$A$100*10^4-ROW($A$1:$A$100),ROW(A1)),$A$1:$A$100*10^4-ROW($A$1:$A$100),),)

Press CTRL+SHIFT+ENTER to end

Press CTRL+SHIFT+ENDER. ENTER to end

Scroll down the formula and you're done

Related articles
  • Projection mooncake using what black technology?
  • What media platforms are there?
  • Does it make sense to exceed 1000 pure electric range? Is mileage anxiety necessary? Where is the pit?
  • Lv Wen Big Data Platform, Shaanxi Province
  • How to consider the injury situation and rotation strategy of the team in the prediction of corner kick size?
  • Advantages of Active Data Governance, Problems to Avoid in Data Governance
  • Song ci meets big data
  • What does a real-life sibling relationship look like? Would it be tiring?
  • What software is used to write copy?
  • Is it good to be a licensed herbalist,how hard is it?

    • copyright 2024 Loan Platform Complete Network All rights reserved