Hi Team,
I am having an Excel sheet in that I need to match 2 columns and If it matches I need to get results in Percentage
say for example :
Like this I am having 2 column I need to find out matching Percentage of these.
Any ideas of how to do?? Thank you in advance!!!
Thanks for the response .
what you given is very much useful 👍 Thanks a lot again!!!
Hi @Abisheck_Canary,
Can you clarify you definition of match? Does it need to match the exact value of column1 or can it match against part of the value as well?
In case of the first scenario you can use something like the example below.
In an update row I use the following expression in a new percentage column.
This expression uses a indexOf to check if the value of column1 is is found in column2. If that is the case (not equals to -1). The length of both values are converted to float values and used in a div calculation and formatted as a percentage value via formatnumber with the P2 format.
if(equals(indexOf(item()?['column2'], item()?['column1']), -1), 0, formatnumber(div(float(length(item()?['column1'])), float(length(item()?['column2']))), 'P2'))
This would result in the following percentages