Previous Topic Next Topic

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

Answer 1 / 1
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

Similar discussions

We received your account.
baldevbhai -
dwebb -

1 response
Facebook says that my email doesn't match my facebook email
@@@@@@@@@@@ -
Ambucias -

1 response
Match value in 2 separate columns and return a value from a 3rd
JD_Silver -
TrowaD -

1 response
Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses
We received your information
Tth5h3g34h4hgr -
ElenaKM -

1 response