Help ! Need to delete rows when with special criteria

Hi Everyone,

Really appreciate if you guys can help me to create VBA for Delete the Rows when the criteria is met.
The Criteria is If the Cell on Column A is Blank, and the Data on Column B is Duplicate, I need to delete both Rows (the Blank row and the Duplicate row) so there's two rows that I need to Delete.


You can see the example on Image Attached. I need to delete the rows with X marks.

the Data.png

Thank You,

It's not easy to work with a picture (see yellow banner near top of the page) but basically in your couln E you could use countif or countIFS function (and write result of (value returned by) the function in column E then delete all rows where value in E is >=2

In column E, use:

Formula:

Please Login or Register  to view this content.