• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Compare two sets of data

V

VISHAL BHARDWAJ

New Member
Have to check 2 sets of data to find differences in amount of around 250 parties each for 48 months, both have same parties but with a bit of change in names as mentioned below: -

1 ABC INDIA PVT. LTD. 3000/- M/S ABC INDIA PVT. LTD. 4000/-
2 ABC INDIA PVT. LTD. 5000/- ABC INDIA 5500/-
3 ABC INDIA PVT. LTD. 4500/- ABC INDA PVT. LTD. 6500/-
4 ABC INDIA PVT. LTD. 1000/- ABC INDIA PRIVATE LTD. 1000/-

I want to bring numeric value of one data adjacent to other to check for differences.
Is there a way to find as ABC which is common in both the datas

Please Help

Warm Regards,
 
Hi Vishal..

Can you please put this in excel with couple of more examples...along with expected result..

Here, I have a question - are we supposed to sum all the numerical values for ABC in Column and then compare with the sum of all numerical values in another column for same customer...

please explain...??
 
Hi Asheesh,
Thanks for replying
These are two sets one is maintained at branch and other at main office, now we are checking for any differences, but problem is that both have maintained different particulars (something added or missing) with just a few words common in it.
I tried it through vlookup, but as nothing is common, it didn't give any result
What I am trying is to bring one value adjacent to other through vlookup and checking for difference in next column.
 

Attachments

  • sample.xlsx
    8.1 KB · Views: 0
Hi Vishal,

If few of your starting words are same in both sets, I think you can go with simple SUMIF:

=SUMIF($A$2:$A$10,LEFT(A2,8)&"*",$B$2:$B$10)-SUMIF($D$2:$D$10,LEFT(D2,8)&"*",$E$2:$E$10)

Regards,

 
Thanks Asheesh,
For most of the data ur formula has solved my problem but I forgot to mention few more conditions like if a party has prefixed something (e.g. M/s or floor/shop no.) before party name, then is there any way

Regards,
Vishal
 
You must log in or register to reply here.
Back
Top