Hi guys, here is my question..
Imagine you have two columns: One with values a, b, c or /; and the other with values ranging from 69 to 84 (these are short for years).
I have attached a sheet to make it more clear.
What I need is to count how many values a, b and c I have in each year.
What I have done so far is filtered the sheet, and then used a count function for each combination of (a,b,c) with (69-84).
This works fine, but takes a lot of time, so I wanted to see if there is a shortcut.
Thx
Bookmarks