Filtering column with checkboxes and multiple entries in cells

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
The worksheet is not displaying correctly.
Here it is again ---
A B C
Dept File Location Course Offered
1 Health server1.abc.., <checkbox checked>
server2.abc...
2 CS server1.abc... <checkbox checked>
 
The worksheet did not display correctly.
Here it is again ---

A B C
Dept File Location Course Offered
1 Health server1.abc.., <checkbox checked>
server2.abc...
2 CS server1.abc... <checkbox checked>
 
Back
Top