Excel: Delete row if a cell text equals the cell below

I create a report worksheet that varies in length. The report includes "*Phase" title rows that may or may not include data rows before the next title row. I want to delete the title rows that do not have data rows following the title row. The cell in column C of each title row has the text "*Phase". How do I write the code to delete the row if the text "*Phase" in cell C of the row equals the text "*Phase" in cell C of the row immediately following? The report worksheet has a header row that does not list *Phase in the header for column C.

This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of April 29, 2017.

For more resources for Microsoft Excel