G
Guest
Hi,
My worksheet looks like this ---
A B
C
Department File Location
Course Offered
1 Health server1.abc.edu, server2.abc.edu
<checkbox checked>
2. Business server1.abc.edu
<checkbox checked>
I have 2 filtering questions --
1) In my worksheet I have column C with checkboxes. I would like to filter
this column with checkboxes that are selected (or vice-versa). I tried to
custom filter with criteria "equal to - True". Only one row is displayed
though there are two rows that have checkboxes selected. Is there a way to
filter this column?
2. Can a custom filter be saved so that end user does not have to enter the
criteria every time. If not, is there another way to filter data where the
criteria is saved?
Any help is appreciated.
Thanks, UT
My worksheet looks like this ---
A B
C
Department File Location
Course Offered
1 Health server1.abc.edu, server2.abc.edu
<checkbox checked>
2. Business server1.abc.edu
<checkbox checked>
I have 2 filtering questions --
1) In my worksheet I have column C with checkboxes. I would like to filter
this column with checkboxes that are selected (or vice-versa). I tried to
custom filter with criteria "equal to - True". Only one row is displayed
though there are two rows that have checkboxes selected. Is there a way to
filter this column?
2. Can a custom filter be saved so that end user does not have to enter the
criteria every time. If not, is there another way to filter data where the
criteria is saved?
Any help is appreciated.
Thanks, UT