![]() Normally, you would give COUNTIF a range like A1:A10 and a simple criteria like ">10". ![]() ![]() The COUNTIF function will count things in a range that meet your criteria. You don't care about the order that the items, you just want to know how many items in list 2 appear in list 1. You want a formula that compares the values in the 2nd list to see how many of them appear in the first list. Suppose you have a "master" list of some kind, and also have another list that contains some of the same items.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |