Possible countif or unique(filter function required

[ollyhughes1982]

Hi all,

I have the ‘All Completed VS’ worksheet (screenshot below and link attached).

The worksheet shows all of the volunteering roles that I have completed at various different parkruns. From this, I am looking to populate the ‘All Completed VS - VRE-I.’ worksheet (worksheet highlighted in red). i.e. List all of the different volunteer roles that I have completed in column B. Then, in column C, to show at how many unique events I have completed each role. I would like the data to be sorted descending, according the value in column C.

I have populated the cells with some manual data, just to show the kind of thing I am after (see screenshot, below).

Link to file is here: parkrun - Volunteering Example.xlsx

Thanks in advance,

Olly.

 

[ollyhughes1982]

Thanks. That works perfectly.

Apologies my earlier logic in A2 should have included 'at least', reading as follows:

'# of Unique Roles that have been completed at at least the same # of Unique Events (Venues). e.g. Completing 5 Unique Roles at 5 Unique Events (Venues), gives a result of 5.'

I have now added this into the statement.

 

[Fluff]

You're welcome & thanks for the feedback.