Forum Discussion
IF conditions
Hello,
I am struggled with excel formulas since I am a beeginer.
I work on a financial account reconciliation and need to create a formula corresponding to the following criteria:
IF the the column W contains the same value as Column G, so I would like to make Column [A to K] and [P to AA] automatically side by side and rank them upper. Those who have different values can be ranked lower.
After that, I would also want to color matched W&L columns to red.
I attached the excel file.
Your help is very appreciated.
- Hi Tsiry, can you give a bit more information. What identifier are you using to compare? So A to K is data set 1 and P to AA is data set 2.. And you would like to comapre the value in column W with the value in column G.
Is it a straight forward line by line comparison purely based on comparing the values in those 2 columns, or is there some common key / lookup reference?
Also not sure on you reference to column s W & L.
L appears to be empty- Dear Wyn, you got it indeed, A to K is data set 1 and P to AA is data set 2. Since values on W should match those on G, I want to ease my conciliation by comparing the two columns and after that, putting matched line side by side (I mean for example if W2 match to G8, I wish to align A2 to K2 and P8 to AA8 side by side and color matched values by red.
Column L, M, O are not necessarily to be included.
Thanks for helping me.- So, are there going to be duplicate values in column W, or in column G?
If so what rule are you going to apply ?
Which value in W or G gets treated as the reconciling one?
If there won’t be duplicates then Power Query will be really helpful for what you want to do.
Let me know what version of Excel you are on
