Good morning!
I'm looking for a way to count the number of times a certain number appears in a column, but within a certain group. An example is below:
I have three unique identifiers in Column A. In Column B are the unique values I want to count. So, I'd want to see that ID 10 has one value for 6, one value for 7, and one value for 8. ID 12 has three values for 8, and ID 13 has two values for 8.
ID Tag
10 6
10 7
10 8
12 8
12 8
12 8
12 8
13 8
13 8
I was able to use a countIF statement, but that only worked if I only selected a single ID value. I'd really prefer to do the whole column of IDs in one go.
Any and all suggestions are MUCH appreciated! Thanks in advance!
Bookmarks