Hi everyone.
Firstly, apologies....I know there are plenty of threads about this issue online - after many many wasted hours, I simply can not get it working with my data.
What I am after is a formula which counts the number of unique values from column B (Employer name), when 3 different criteria are met (year, type of event and event cancelled <>Y). For example, if IBM appeared twice in the raw data when "Year= C34" and "Type= B34" and "Cancelled <> Y" - 2 would be the result.
I have data in one sheet, and the results in another. I am stuck with cells D34 in the 'Review of events' sheet, I can then use the same formula for all "Employer participation" stats.
Employers.xlsx
Any help would be greatly appreciated.
Many thanks.
Bookmarks