Increase flexibility of my IF(SUBTOTAL formula (or any formula) to return ALL (ANY) unique value, beyond the current, limited design of just returning three results, Team "1" or "2", or, if AutoFilter is set to show more than one Team, then "All" is returned. The current IF(SUBTOTAL operates with only two Teams, 1 and 2. A new design will return *ANY, UNIQUE* Team number (value) when a filter is set on Column B.
The purpose is to cause a chart title to properly reflect exactly which Team number, [1, 2, 3, ...n] has been filtered [is visible] when only a single team is [uniquely] visible. Otherwise, "All" (meaning several) is returned signifying more than one team has been selected with AutoFilter.
I prefer a non-array formula solution if calculation will be excessively slow.
A .XLSX file is attached with needs detail and to experiment on.