Columns Matching...

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
well you did not post the link to the file completely