Delete specific rows

julianhoetzel

Hey guys, 

how can I delete rows with slightly the same dataset? Here is an example:

Customer	Client from our Customer	Finance	Amount	Credit	Volume
A	AA	12	15	5	100
A	AA	24	12	2	120
A	AA	23	23	3	130
	Total amount AA	59	50	10	350
A	AB	10	56	5	130
A	AB	10	56	8	120
A	AB	10	20	9	140
	Total amount AB	30	132	22	390

I'd like to remove the rows with "Total amount AA" and "Total amount AB" to have this output:

Customer	Client from our Customer	Finance	Amount	Credit	Volume
A	AA	12	15	5	100
A	AA	24	12	2	120
A	AA	23	23	3	130
A	AB	10	56	5	130
A	AB	10	56	8	120
A	AB	10	20	9	140

Thank you in advance.

Julian

grossal

Wie wäre es mit einem Filter auf die Spalte der schaut, dass dort nicht "Summe der Debitoren" steht?