Hi guys
I have columns as follows;
Column A - Company Name
Column B - Company Balance
Column C - Company Name
Column D - Company Balance
I want to identify exact/partial matches in columns A and C and find the lower of the two balances
E.g.
Joe Bloggs Limited £100 to be matched with Joe Bloggs Ltd £200 with the result giving me a value of £100
Any ideas how to tackle this would be great.
Thanks
I have columns as follows;
Column A - Company Name
Column B - Company Balance
Column C - Company Name
Column D - Company Balance
I want to identify exact/partial matches in columns A and C and find the lower of the two balances
E.g.
Joe Bloggs Limited £100 to be matched with Joe Bloggs Ltd £200 with the result giving me a value of £100
Any ideas how to tackle this would be great.
Thanks