Data filtering and deleting basis tect

[divumj]

GM All

I am looking for a solution where I would like to find specific text in one column that to first occurence as I have multiple values in same column.

Once it identified we need to delete all the data above that. For e.g. I am looking for text having abc and I have first occurence on row 5000 having field 123abc.

[divumj]

@AlienSx 

This will remove entire data... requirment is to find it and remove all data above that , that to for first occurence...

As my data had multiple text having that data and we don't want to remove all data...only for the first one from the top

[AlienSx · Accepted solution]

Table.Skip

[divumj]

@AlienSx not able to apply that...could you please gave me excel working examples...ask is that first need to check the first occurence for text with contain function and then delete the above all data only...

[AlienSx]

Read this article with lots of examples. 

[divumj]

@AlienSx Thanks I got the issue and it did worked...many many thanks 

[AlienSx]

Table.Skip(your_table, (x) => not Text.Contains(x[column_name], "specific_text"))