Berry Metzger
asked on
Formula to return "1" or "2" (not "All") modified to allow a second column filter to be set
An accepted solution to the formula (cell AC2) to return "1", "2", or "All" using filtered col B works as intended.
However, adding a filter to col A causes the formula to revert to "All" even though only "1" is unfiltered ("2" is hidden).
Can a fix be applied to the formula in AC2 to return "1" when col A has a filter set to show only "1" and specific rows have been selected in col A? File attached.count-visible-TorF.xlsx
However, adding a filter to col A causes the formula to revert to "All" even though only "1" is unfiltered ("2" is hidden).
Can a fix be applied to the formula in AC2 to return "1" when col A has a filter set to show only "1" and specific rows have been selected in col A? File attached.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
Thank you, you've been a great help to me. And it works filtering out Blanks as well. Your formula solution completes the development of this project.
Berry