Complex challenge

[Ulasowski Mark]

 From an ongoing competition spreadsheet

 There are 8 columns from A to I. The columns are titled, in order, Artist, Song, Round, Theme, Nominated by, Votes, Billy, and Pos. There are 26117 rows. I want to extract into a table the following information: For each contestant ("nominated by")  I need to know how many of their unique "artist" column values were nominated first. By first I mean the earliest round  value. I'd like this info presented in a table with "Nominated by", Artist, Round  

[Ulasowski Mark]

In summary, I'm trying to find which contestant has nominated the most artists that hadn't previously been nominated

[Gina Maylone]

=ARRAYFORMULA(
   SORT(
     UNIQUE(
       FILTER(A2:E26117, C2:C26117 = MIN(FILTER(C2:C26117, A2:A26117 = A2:A26117)))
     )
   , 3, TRUE)
)

The resulting table will have:

• Nominated by | Artist | Round
  
  For further aggregation (e.g., a count of first-time nominees per contestant), use a pivot table or a GROUP BY QUERY function: =QUERY(

    ARRAYFORMULA(
      FILTER({E2:E26117, A2:A26117, C2:C26117}, C2:C26117 = MIN(FILTER(C2:C26117, A2:A26117 = A2:A26117)))
    ),
    "SELECT Col1, COUNT(Col2) GROUP BY Col1 ORDER BY COUNT(Col2) DESC", 1
  )
  This will show, for each contestant, the count of unique artists they were first to nominate, helping identify the top contributors in your contest
  
  HTH!