I have 2 columns in power query.
I want to assign the best approximation to column 1 from column 2
For example: For the phrase column 1 https://www.screencast.com/t/KafThnRPS
Best match is https://www.screencast.com/t/CZiJINVA20v
in column 1 can be from 1 to 4 words compatible...
Hello to every one, Ioan here
I don't succeed to create dynamic array for range of cells, this dynamic aaray will be usefull to aproximate a specific value:
Please watch the image to understand what i want to say
I am using RANK but because the values in the Range are calculated the number that I am trying to determine the rank of does not match.
Is there a way of doing an approximate match using the rank function.
I tried FLOOR but that did not eliminate my problem.