Auto Populate Win Sheet via Numbers in another worksheet

tfrisbie 

If you are still having problems, it may be that

= LET(
      count, COUNTIFS(Data, numbers),
      n,     MAX(count),
      k,     SEQUENCE(1,n),
      wins,  IF(k<=count,"X",""),
  )

would work for you.  I have removed the VSTACK that I used simply to lay out the results sheet because the array manipulation functions came out even later than LAMBDA.  If I were developing this formula for my own use, I would create a custom Lambda function so that the formula has the same look and feel as every other formula throughout my workbook but that has most users feeling faint and reaching for the smelling salts!