May 30 2021 06:58 PM - edited May 30 2021 07:02 PM
May 30 2021 08:25 PM
May 30 2021 08:55 PM
May 30 2021 10:05 PM
May 31 2021 01:16 AM
Did you try to apply filter to column C (select it, Data->Filter) and uncheck FALSE in filter drop down?
May 31 2021 01:19 PM
Solution
Sergei is correct. The easiest way to do this without VBA code is to apply a filter to the column.
1. Add a column header then select the column range and then click Data > Filter
2. Click the dropdown arrows and uncheck 'FALSE'
3. The rows with 'FALSE' will now be hidden
NOTE: The filtered rows will not automatically updated if values change. You will have to refilter it each time by unchecking and then rechecking 'FALSE' in the filter
May 31 2021 04:37 PM
May 31 2021 01:19 PM
Solution
Sergei is correct. The easiest way to do this without VBA code is to apply a filter to the column.
1. Add a column header then select the column range and then click Data > Filter
2. Click the dropdown arrows and uncheck 'FALSE'
3. The rows with 'FALSE' will now be hidden
NOTE: The filtered rows will not automatically updated if values change. You will have to refilter it each time by unchecking and then rechecking 'FALSE' in the filter