Likely UNIQUE FILTER / SUM PRODUCT solution

[ollyhughes1982]

Hi all,

Would anyone please be able to help with calculations in my ‘All Completed Runs - TOM’ worksheet? In my ‘All Completed Runs - Summary’ worksheet (cell B85) I have need a count of the number of events (venues) that I have completed two or more times. The result, for me, should be 8.

However, I have had to manually input what my results should be (yellow cells), in the ‘All Completed Runs - TOM’ worksheet. I need to find a way to do this automatically.

I think this will be some sort of unique filter type solution for the ‘All Completed Runs - TOM’ worksheet and possibly a sum product type solution for cell B85 of the ‘All Completed Runs - Summary’ worksheet, as has been the case in other similar areas of my workbook.

Link to file here: Twice or More.xlsx

Thanks in advance!

 

[ollyhughes1982]

Hi all.

I still haven't been able to solve this problem, if anyone might be able to help, please?

Thanks.

 

[ollyhughes1982]

Also now posted on Excel Forum. Listing items that have appeared twice or more in a list

 

[ollyhughes1982]

This is now solved. Thanks