Match Criteria

hi,

It would be great if you could attach a zipped example xls file & we may be able to help in getting your PT to work.

To add to Roly's countif suggestion check out my attached untested version &/or the below links which may be helpful:

http://www.cpearson.com/excel/Duplicates.aspx

http://www.j-walk.com/ss/excel/tips/tip52.htm
- The formulae using "frequency" seems the most promising & you may be able to adapt it if my attached example isn't quite what you want.


hth
Rob