Aggregate, Min, Exclude 0's

[concreteinterface]

Hi. I am trying to use the aggregate to find the minimum fantasy football player score for a single game. I am using the function as shown in this video https://youtu.be/Oxj-wMGjAW0?t=340 . My code as of this point is:

=AGGREGATE(15,6,ActData!$Q1:$Q20000/(ActData!$B1:$B20000=[@Player]),1)

My problem is, if a player is out for a game, the data is scored as a 0. I don't want the 0, just the lowest score the player had in a game. I've never used aggregate before, so I need a little push in the right direction. Thanks.

 

[Eric W]

Try:

=1/AGGREGATE(14,6,1/(ActData!$Q1:$Q20000/(ActData!$B1:$B20000=[@Player])),1)

 

[concreteinterface]

Try:

=1/AGGREGATE(14,6,1/(ActData!$Q1:$Q20000/(ActData!$B1:$B20000=[@Player])),1)

Thank you.