hi!
i am having the following data in A1:B22
1000 DR
1000 CR
1500 DR
1000 DR
2000 DR
1000 DR
1500 CR
2000 CR
1000 DR
1000 CR
1000 DR
2000 CR
2000 DR
1500 CR
1000 CR
3000 DR
1000 CR
4000 DR
3000 CR
2000 DR
2000 CR
1500 DR
here in the list
1000 DR - 5 rec
1000 CR - 4 rec
1500 DR - 2 rec
1500 CR - 2 rec
2000 DR - 2 rec
2000 CR - 3 rec
3000 DR - 2 rec
3000 CR - 1 rec
4000 DR - 1 rec
4000 CR - nil
what i want is to shortlist the records
1000 DR
2000 CR
3000 DR
4000 DR
using worksheet function in COL C
to mark some flag like
"matched", "unmatched"
hopes that explained the things better!!
-via135
--
via135
------------------------------------------------------------------------
via135's Profile:
http://www.excelforum.com/member.php...o&userid=26725
View this thread:
http://www.excelforum.com/showthread...hreadid=561822