Hi Bosco and Siga
many thanks for both of your help. Bosco's formula works perfectly for what I asked for however I realise now what was missing in my question.
Take the first line for example, the rate returned is 2.9. The answer I was looking for is actually 2.5. This is because i wanted...
Hi Ashokkumarkolla
Many thanks for your quick reply and the tip to upload the file instead of the image.
The formula would only work if it is a one-on-one match however if I change the order of the data in the table on the right hand side, it would not work. It will have to be something like...
Hi
I'm new to this forum (the only forum I have ever joined) and i hope to learn a few things to improve my excel skills.
I'd like to get help with a formula that does this please
Also, if you are able to provide the VB codes for this that'd be even more awesome.
Many thanks in advance...