Macro to filter cells containing a word ONLY if cell above doesn't contain another word!

[MatLCFC]

Title sounds way more complicated than my problem!

Basically, I have worked out a macro to reconfigure a csv. All working great but for one issue.

Data is split by different companies (A, B & C in example below).
I need the headers - Debtor Name (Row 1) followed by Debtor Account (Row 2).

However, the debtor account no. is "repeated" on it's own in between some of the lists of invoices.
I need to delete these "repeat rows" (Row 12, in example below) but keep the headers (Rows 1&2, Rows 4&5, Rows 14&15).

My thinking was a filter (on Row A) that would list the cells with "Debtor Account" if the cell above did not contain "Debtor Name".

Sorry, if the explanation is rubbish... I'm sure you can see what I mean from the pic.

Can anyone help!

Thanks Matt

[TMS]

Can't you just "Remove Duplicates"?

[TMS]

See: https://support.office.com/en-gb/art...1-8daaec1e83c2

[MatLCFC]

Thanks for the reply

Hmm... No I don't think that will work. Unless someone can explain exactly how I would implement it.

I thought I would be able to filter for a cell containing "Debtor Account" ONLY IF Cell above DOES NOT contain "Debtor Number" - Is that possible?

[MatLCFC]

Another way round of looking at... If I filter "Debtor Name" & "Debtor Account" (as below).

I want the pattern to be Debtor Name then Debtor account. If debtor account appears again (highlighted yellow), I want that line deleted.

Any ideas people? This is the last problem I need to fix & I have a working macro! AGGGGHHH

[TMS]

This is the last problem I need to fix & I have a working macro!

Probably an idea to share what you have and ideally a sample workbook, not a picture of a worksheet.