Forum Discussion
Wrong usage of XMATCH in Microsoft's Example
Is it just me or the interpretation of example 2 in this https://support.microsoft.com/en-us/office/xmatch-function-d966da31-7a6b-4a13-a1c6-5a33ed6a0312 is wrong? The example 2 is what is in the imag...
Since the Total Sales amounts are sorted in descending order, the index of the last value greater than or equal to 15000 (the number returned by XMATCH) is also the number of Total Sales amounts larger than or equal to 15000.