Code or Formula to delete rows based on multiple criteria

[lucasc10]

Hello all!

I am looking for a code or formula to delete the entire row if it meets the following conditions... I would like the entire row deleted if "Column B" is the first instance (by column A) and it correlates to an "N" in "Column C". I would also like every row that contains the same number in "Column A" as the one that was deleted to be deleted. I know that this is confusing, so I will explain my example sheet below...

I would want everything that is highlighted in the example to have the whole row deleted.

1234 should be deleted because the first instance of it has an "N" in Column C.

1245 should be deleted because the first instance of it has an "N" in Column C.

1356 should NOT be deleted because the first instance of it does not have an "N" in Column C.

1589 and 1679 should be deleted because the first instance of them have an "N" in Column C.

Note: Column B does not have to be "1" to be deleted, but rather the first number of the set.

[PCI]

See next code

Please Login or Register  to view this content.

[lucasc10]

Thank you! I have one question... What if Column B and C were Column AD and AE, respectively?

[PCI]

See next code and adjust Const value to your next need.
Note column "B" is not used.

Please Login or Register  to view this content.

[lucasc10]

See next code and adjust Const value to your next need.
Note column "B" is not used.

Please Login or Register  to view this content.

Thank you as always!

[PCI]

You're welcome

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

[lucasc10]

https://www.mrexcel.com/board/thread...2#post-5403552

Above is the link in another publication. I'm sorry!