Help with scrubbing a list

[boothexcel]

Hello,

I can achieve the desired outcome in the attachment by marking the desired rows, then filtering, then deleting.

Is there a way to do it more efficiently, e.g., something like finding all blank cells and then deleting those rows in one operation?

Thank you.

[FDibbins]

I know that is just a sample, but I used a different approach. Instead of deleting what you dont need, I used the ARRAY formula below to extract what you DO want...
=IFERROR(INDEX(A:A,SMALL(IF($A$2:$A$39={2,5,8},ROW($A$2:$A$39)),ROWS($A$1:A1))),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Then copy down as needed

[sourabhg98]

Macro Solution-

Please Login or Register  to view this content.

Check attached for a Sample.

[hemesh]

another way may be
in B2 copy paste below
=MATCH(A2,{2,5,8},0) then drag down
now select B2 to B39 and click find and select go to special===> formula ====> select only errors hit ok then right click an higlighted cell in column B and click delete entire row