Berry Metzger
asked on
formula to return the unique entry in filtered list or "All" if a combo exists
I need a formula that returns from text in column B "All" if visible rows under "Team" in col B contain more than 1 unique text value, or returns "1" if all visible rows contain only "1" or returns "2" when all visible rows only contain "2" ... all this as a result of having AutoFiltered on "Team", col B. A sample file is attached.
Berry
count-visible-TorF.xlsx
Berry
count-visible-TorF.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Berry