deleting lines based on the values of a column

[Nils_Junker]

hi everybody,
i have the following data (just a snippet, it goes further down)

A	B
F000034602	LE6300
F000034461	LE6300
F000034603	LE6300
7517701​	Dummy
F000044070	LE6300
F000117104	LE6300
F000115754	LE6300
F000115752	LE6300
F000035619	LE6300

I want to delete all lines containing dummy in column B.
How do i do that (if possible without VBA)
Thanks for helping
BR

 

[ExcelToDAX]

You could use Power Query to filter it out and then it would create a new table that you can reference.

 

[Nils_Junker]

hi everybody,
i have the following data (just a snippet, it goes further down)

A	B
F000034602	LE6300
F000034461	LE6300
F000034603	LE6300
7517701​	Dummy
F000044070	LE6300
F000117104	LE6300
F000115754	LE6300
F000115752	LE6300
F000035619	LE6300

I want to delete all lines containing dummy in column B.
How do i do that (if possible without VBA)
Thanks for helping
BR

there are of course more lines containing the word Dummy in column B

 

[Joe4]

You can use the FILTER function again, just like I showed you on your other question, i.e.

Formula for cell D2:

=FILTER(A2:B10,B2:B10<>"Dummy")

 

[Georgiboy]

Or a quick and dirty manual method might be to apply an auto filter, filter column B to 'Dummy', delete the visible lines, remove the filter.

 

[Nils_Junker]

Or a quick and dirty manual method might be to apply an auto filter, filter column B to 'Dummy', delete the visible lines, remove the filter.

can you explain me how exactly that works

 

[Nils_Junker]

You can use the FILTER function again, just like I showed you on your other question, i.e.
View attachment 106410

Formula for cell D2:

=FILTER(A2:B10,B2:B10<>"Dummy")

problem is that on the right there are important columns who have to match exactly to A and dB

 

[Georgiboy]

can you explain me how exactly that works

Select columns B:C or however many columns you want to include in the filter.
Go to 'Data' in the ribbon.
Select the 'Filter' button.
Click the dropdown that appears in column B.
Untick 'Select All'.
Tick 'Dummy'.
Click 'OK'.
Select all of the rows that are now visible.
Right click and select 'Delete Row'
Hit the 'Filter' button again in the ribbon.
Done

 

[Joe4]

problem is that on the right there are important columns who have to match exactly to A and dB

I don't know what that means. What are you trying to say?

How about posting a more realistic example of your data?
Don't oversimplify it for our sake, or you may get an answer that works for your oversimplified example but not your real data.
And then show us what your expected result should look like.