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 th...
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
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.
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- In fact, I want to compare if in W, we can find the same amount as in G. Surely, the 2nd dataset (P to AA) contains more information than A to K but I want to reconcile W from G.
So, I would like sort every matched value in order to see below the missing or different value.
Using Power Query is interesting but now I work on Excel 2010 version and I don't have it yet.
Thanks.Hi Tsiry,
The problem you are going to face is that both sets of data contain duplicate values (See screen shot), and therefore any automation will be very difficult. Can you also add Date as a parameter for the comparison? E.g compare data and value in data set 1 with date and value in data set 2?
On a side note, Power Query is available as an add-in for Excel 2010 https://www.microsoft.com/en-au/download/details.aspx?id=39379
I'd suggest it is one of the most important things you should learn in Excel
