Similar Posts

Subscribe
Notify of
6 Answers
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Krabat693
Krabat693
9 months ago

This does not work with a formula, so you would have to program a macro which looks line-by-line what is in column C and then delete the line if necessary.

could look like this:

Sub DeleteRows()
   Dim ws As Worksheet
   Dim lastRow As Long
   Dim i As Long

   Set ws = ThisWorkbook.Sheets("Tabelle1") ' Ändere "Tabelle1" auf den Namen deines Blattes

   ' Letzte zeile mit inhalt in Spalte C finden
   lastRow = ws.Cells(ws.Rows.Count, "C").End(xlUp).Row

   ' Schleife von der Letzten zeile bis zum anfang
   For i = lastRow To 1 Step -1
       ' Check ob "Ergebnis"
       If ws.Cells(i, 3).Value <> "Ergebnis" Then
           ' Spalte löschen wenn ungleich "Ergebnis"
           ws.Rows(i).Delete
       End If
   Next i
End Sub
0
Ulli0707
Author
Ulli0707
9 months ago
Reply to  Krabat693

Super, thank you very much, I had to make a macro and to delete the lines in which the word “result” does not occur. I’ll test it right away, thank you very much for the quick help. Greetings

0
Ulli0707
Author
Ulli0707
9 months ago
Reply to  Krabat693

unfortunately has not worked completely, possibly because the text is not only “result” but “…. result” (comes from a partial result that I previously created about data. If possible, a sum can be formed instead of a partial result and the individual items can thereby be deleted. Or must the macro be programmed more detailed? Thank you for your further support, greeting Ulli

0
Krabat693
Krabat693
9 months ago
Reply to  Ulli0707

Change:

Strings:

If ws.Cells(i, 3).Value <> "Ergebnis" Then

Sit for it:

If InStr(1, ws.Cells(i, 3).Value, "Ergebnis", vbTextCompare) = 0 Then
1
JayRaa
JayRaa
9 months ago

Would only work with macro. The code has already been posted.

Alternatively, you could use “Search/Replace” (available under control +f) and then after searching what should be deleted and then replaced by “.

0
eterneladam
eterneladam
9 months ago

You could make a filter, then filter all that does not contain “result”, then mark and delete these lines.

0