Columns Matching...

Closed
khan - Nov 13, 2011 at 06:29 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 1, 2011 at 07:06 AM
Hi, 

I have a workbook in which there are 3 sets of 3 columns names

(Narration, Debit, Credit)
(Doc. No.,	Debit,	 Credit)
(Diff,	Debit,	 Credit)

File can be viewed and download through this skydrive link:

https://skydrive.live.com/view.aspx?...76EBB74A%21264

Now on third column set i want those entries which are not matching,

The matching criteria i apply manually is that i match "Doc. No." with Chq number or Slip number given in "Narration" in second column set.


Thanks,


Khan

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 1, 2011 at 07:06 AM
well you did not post the link to the file completely
0