Forum

Notifications
Clear all

Filter Using Based on Criteria Changes

4 Posts
2 Users
0 Reactions
59 Views
(@mekuzey)
Posts: 6
Active Member
Topic starter
 

Hi Dears;

On my table; my activities information coming from formula based on criteria; regarding that not all of them has quantity (Some of them empty but it is changing by criteria). For example when you use one criteria row-1,3,5,7 is empty (On the same column) and for other criteria row-2,4,6,8 is empty. I want to use a filter without macro when criteria is changing I want to see always not empty cells. Is it possible?

Many thanks...

 
Posted : 28/08/2020 1:24 am
Philip Treacy
(@philipt)
Posts: 1632
Member Admin
 

Hi Gokhan,

You haven't attached a workbook I don't know if you have your data in an Excel Table or not.  But if you do then you could just use the table filters.

If you haven't got your data in a table, select the data, then CTRL+T to create a table.

Failing those options, select the data you want to filter and then from the Ribbon -> Data -> Filter.

If you need more help please attach your workbook.

Regards

Phil

 
Posted : 28/08/2020 5:04 am
(@mekuzey)
Posts: 6
Active Member
Topic starter
 

Hello Phil;

I added the file. I want to filter (hide blanks) on column B and when I change the criteria which is highlighted by yellow on the same sheet; I don't want to see any blank cell. Is it possible without macro?

Thanks...

 
Posted : 28/08/2020 9:27 am
Philip Treacy
(@philipt)
Posts: 1632
Member Admin
 

Hi Gokhan,

You will either have to use VBA for this, or do it manually by going to the Ribbon -> Data -> Sort & Filter -> Reapply.

Attached is VBA to do the job.

   Private Sub Worksheet_Change(ByVal Target As Range)

      AutoFilter.ApplyFilter

   End Sub

Regards

Phil

 
Posted : 28/08/2020 7:08 pm
Share: