|You haven't provided enough information for us to help you. Please click on the link at the bottom of this post and read the instructions on how to post example data in this forum. Then post a small sample of your data and some more details about what you are trying to do, using the example data to clarify your requirements.|
Excel has various counting and matching functions that might work, but it wouldn't do much good to suggest anything until we know a little more about your needs.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.