How to filter a table & delete the filtered visible rows if data available

Question

How to filter a table & delete the filtered visible rows if data available

Mithushal Kandula 0

Hi, I want to delete the visible rows in the filtered table but if the data is not available after filtering then end kindly requesting someone to support

Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff

2024-01-19T08:13:25.52+00:00

Hi, I'm not clearly about your requirement, please be a bit more precise to explain your requirement or you can upload a screenshot so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.
Mithushal Kandula 0 Reputation points

2024-01-19T15:43:42.0333333+00:00
Filter a column

If there is data when filtered then

Delete the entire visible rows

Else

End the code

Showalldata in the Table

1 answer

Your answer

Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff

2024-01-19T08:13:25.52+00:00

Hi, I'm not clearly about your requirement, please be a bit more precise to explain your requirement or you can upload a screenshot so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.
Mithushal Kandula 0 Reputation points

2024-01-19T15:43:42.0333333+00:00

Filter a column

If there is data when filtered then

Delete the entire visible rows

Else

End the code

Showalldata in the Table

Answer 1

Herbert Seidenberg 1,191

Excel 365 Pro Plus with Power Query.
Filter() vs PQ.
Share file if need be.
https://www.mediafire.com/file_premium/28dagzs7w5gc6uj/01_21_24.xlsx/file
https://www.mediafire.com/file_premium/6e57vicya46or0a/01_21_24.pdf/file

Share via

How to filter a table & delete the filtered visible rows if data available

1 answer

Your answer