In your example, with all values being the same, we don't know which pair
don't match. Using COUNTIF for CR & DR we can identify that there are 2 DRs
"not matched" (counts of 10 and 12 respectively).

Is this sufficient? Or do you want to compare to find balancing CR/DR values?

"via135 via OfficeKB.com" wrote:

i am having the following data in A1:B22

COL A COL B

1000.00 DR
1000.00 CR
1000.00 DR
1000.00 DR
1000.00 DR
1000.00 DR
1000.00 CR
1000.00 CR
1000.00 DR
1000.00 CR
1000.00 DR
1000.00 CR
1000.00 DR
1000.00 CR
1000.00 CR
1000.00 DR
1000.00 CR
1000.00 DR
1000.00 CR
1000.00 DR
1000.00 CR
1000.00 DR

what i want is to flag off the 2 items of
1000 in COL A which are unmatched with ref to COL B,
ie)

1000.00 DR
1000.00 DR
in COL C

using appropriate formulae in C1: C22

hlp pl?

-via135

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200607/1