hard20 pts · first answer countsexcellookupsperformance
Fast lookup on a million rows
To speed up a lookup over 1 million rows, someone sets XMATCH search_mode to 2 (binary search). What must be true of the data?
Discussion 0
Join free to post in the discussion.
Related questions
- What a pivot table doesData Analyst
- Absolute references in ExcelData Analyst
- VLOOKUP returns wrong pricesData Analyst
- SUMIFS with two conditionsData Analyst
- Lost leading zeros in IDsData Analyst
- Finding the slow visualData Analyst
- What the F4 key does in a formulaData Analyst
- COUNT versus COUNTAData Analyst