Delete rows based on 3 columns

[nitin1309]

Hi,
I have 3 columns with data.

I want to delete the entire row if these 3 columns are having the same data.

Do you know how I can do this..


Thanks!

Nithin

[Mordred]

Just curious, would you have people guess the three columns or better yet, exactly which cells? Would you also have people guess the criteria of the data?

[nitin1309]

Its column A, B and C .. If they all have "Data invalid", then I want to delete the entire row.
If its its just 2 columns and the 3rd column has data, then I want to retain the row.

[Mordred]

Just to make this clearer, if A2 = Data invalid and B2 = Data invalid and C2 = Data invalid then delete Row 2 else leave it alone?

[nitin1309]

Yes all 3 columns have "Data Invalid" then only delete the entire row.. Thanks!

[Mordred]

Alright, try the following on a sample set of data

Please Login or Register  to view this content.

[nitin1309]

I copy pasted the same code and changed the name of the Sheet1 to my sheet name..
It didnt work..

[Mordred]

Hi nitin1309,

Sorry about that, I didn't take into account case sensitivity. Try the following

Please Login or Register  to view this content.

[Mordred]

So does this solve your problem? I see you've come back to see my last post but you haven't marked it as solved, given a rep point, or even responded to let me know.

Seriously!

[nitin1309]

Mordred, you need to chill out dude..

I really appreciate you taking out your precious time in helping me out but the Excel Sheet I had constructed had a lot of other logic in it and it crashed this morning.
Which means that I am re-creating all those VBA scenarios before I can implement your code..

And I have been thrown under the bus to do 12 more tasks since my team's off-shore production failed..

[Mordred]

I don't need to chill, and your problems aren't mine own. Being respectful to those that help takes a person a long way. I have a passion for helping people and sometimes people need to be held in check. Check!