Formula

[Foxtrot]

Hi, i will appreciate if someone can help me?

I have debits and credits which i need to match, ie debits in column A1:1000 and credits in column B1:1000 - they are not next to each other. When a debit and credit matches then in column C1:1000 it must indicate ZERO nextto exach one or anything else. I need to be able to see which ones matched/cleared because i need to investigate the ones not been matches/cleared. This is like doing recons in accounting. Thanks

 

[jasonb75]

If you try it you would answer your own question.

Excel Workbook
	A	B	C
1	5.00		Audit Required
2		4.00	0
3	4.00		0
4		3.00	Audit Required
Sheet

 

[Foxtrot]

Sorry, typo. Thank you so much, please accept my appreciation.