How do I delete specific row that is meeting the condition

Help StudioX
1

Hi guys,

So I have an excel file and I would like to delete rows that contain certain words in a certicertainain cell.
I tried to do this by: filtering by the word first, and then using “delete rows” but it returns an error.

Do you have any other ideas how to solve it?

I was thinking:
image

I want to delete all rows that in the age column contain “99” so these highlighted yellow.

Can I do this by this activity?

image
image692×603 16.7 KB

If so, what is the expression I should use? I never used VBA etc. so I would greatly appreciate your help. I want to delete all row meaning not only data inside but the row in general so the outcome is:

image

Please help good people.

2

@anon40731888

Please use filter first with 99 and give the column name

Then use delete rows with visible rows or hidden rows as per he filter you applied

Cheers

3

Hello I tried this and it returns an error.

4

@anon40731888

Can you please tell what error youa re getting and what you tried then we xan help you better

Cheers

5

Yes yes, you were right, the excel was broken sorry. IT worked

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.