+ Reply to Thread
Results 1 to 3 of 3

Counting instances of unique entries, with conditions

  1. #1
    Forum Contributor
    Join Date
    03-30-2020
    Location
    Wales, UK
    MS-Off Ver
    365 (Mac)
    Posts
    191

    Counting instances of unique entries, with conditions

    Hi all,

    Would anyone please be able to help with calculations in my ‘All Completed Runs - Piper’ worksheet, please?

    The definition of what is needed here is: ‘Run at 5 different events (venues) in each of 5 different countries (pC-Index of 5).’

    I have populated in the separate table below the main table (in yellow) what the results should be.

    I think this will be some sort of unique filter or index match type solution, as has been the case in other similar areas of my workbook.

    I have now added a helper column (the last column in the 'All Completed Runs' worksheet) which lists the instance of each country and has helped me solve some of my other queries. I'm still stuck on this one though. I am struggling to find a way to specify finding the first country and then the first five events for that country, then the first five for the second country and then the first 5 for the third country and so on. I need to do it for the first five countries. Up-to-date link is here:

    https://drive.google.com/open?id=1ck...6rWstvwRWU3lsZ

    Thanks in advance!

    Also posted on Mr Excel: https://www.mrexcel.com/board/thread...tions.1131891/

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Counting instances of unique entries, with conditions

    you are more likely to get a reply if you upload as per large yellow banner at head of page.
    most members will not download from unknown links.

  3. #3
    Forum Contributor
    Join Date
    03-30-2020
    Location
    Wales, UK
    MS-Off Ver
    365 (Mac)
    Posts
    191

    Re: Counting instances of unique entries, with conditions

    OK, thanks. Please see attached.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Counting unique instances based on 2 criteria.
    By j9mcl in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-11-2019, 09:29 AM
  2. Counting unique instances of a word?
    By mrbusto71 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-19-2016, 06:49 PM
  3. Counting unique entries with conditions
    By sbe70 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-04-2015, 04:38 AM
  4. Counting unique instances above a certain quantity
    By ammartino44 in forum Excel General
    Replies: 9
    Last Post: 10-03-2014, 03:04 AM
  5. [SOLVED] Counting unique text instances with conditions
    By kazaly in forum Excel General
    Replies: 8
    Last Post: 11-19-2012, 11:44 PM
  6. Counting unique instances in an array.
    By Jerry McM in forum Excel General
    Replies: 2
    Last Post: 02-13-2009, 05:58 PM
  7. Counting Number of Instances with Conditions
    By excalibur69 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-02-2008, 02:44 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1