Trouble Displaying List of Names from a Countif Formula
Please help :)
I have used the Countif formulae to bring back the number of times the value "Red" Appears in smart sheet.
This brings me a value of 4. (So I am displaying the Value 4 in a Dashboard)
I now would like to display the Names of the Client (Located in Column Name 'Client) so I would see the 4 Clients listed?
Is there a formula that could work this out? Have tried HAS Functions, COUNTM, even INDEX and MATCH but to no avail.
Any help would be appreciated :)
Help Article Resources
Check out the Formula Handbook template!