1819
03-26-2016, 10:55 AM
I would like a macro to delete rows where the first 4 words of text in column A are duplicated.
So:
Cell A1: I have a dream today.
Cell A2: I have a meeting today.
Cell A3: I have a dream today.
Cell A4: I have a dream today. And I will wake up tomorrow.
Cell A5: I have a meeting tomorrow.
would become:
Cell A1: I have a dream today.
Cell A2: I have a meeting today.
This was previous posted in Sep 2015, but not answered, at: http://www.excelforum.com/excel-programming-vba-macros/1105085-vba-to-delete-rows-where-first-4-words-of-text-in-column-a-are-duplicated.html
Many thanks.
So:
Cell A1: I have a dream today.
Cell A2: I have a meeting today.
Cell A3: I have a dream today.
Cell A4: I have a dream today. And I will wake up tomorrow.
Cell A5: I have a meeting tomorrow.
would become:
Cell A1: I have a dream today.
Cell A2: I have a meeting today.
This was previous posted in Sep 2015, but not answered, at: http://www.excelforum.com/excel-programming-vba-macros/1105085-vba-to-delete-rows-where-first-4-words-of-text-in-column-a-are-duplicated.html
Many thanks.