Here is an interesting question someone asked me recently,
If I have to delete all rows with “John” in it. Do you know how to do it?
Well, it looks like they really hate John. But it is none of my business.
So lets go ahead and understand a dead-simple way to get rid of all cells with John or whoever else you fancy.
- Select all your data
- Press CTRL+F and search for “John”
- Click on “Find all” button
- Now, select the first result.
- Scroll down, holding SHIFT key, select the last result. This will select all search results.
- Close the Find box.
- Press CTRL – (to delete cells)
- Select “Entire row”
- Click ok
- Now poor John is history!
See this demo to understand:
More tutorials on removing stuff…
If you often find yourself with more data than you need & spend a lot of time deleting Johns from your data, then you will find below tutorials very useful.
- Remove duplicate values from Excel [More ways to do it]
- Remove blank rows in your tables
- Extracting specific data using advanced filter
- Remove un-necessary portions form text values
PS: As I was traveling in last 2 weeks, I could not write often. Starting Monday, you will see your favorite awesome Excel tips regularly.
6 Responses to “Using Lookup Formulas with Excel Tables [Video]”
H1 !
this is my very first comment.
Can you use same technique with Excel 2003 lists ?
thanks 😀
Thanks, Chandoo! I like seeing the sneak peak of what's to come on Friday too 🙂
@Damian.. Welcome to chandoo.org. Thanks for the comments.
Yes, you can use the same with Excel 2003 lists too.
@Tom.. You have seen future and its awesome.. isnt it?
[…] Using Tables – Video 1, Video 2 […]
[…] Using Tables – Video 1, Video 2 […]
Hi, is there a vlookup formula for the second example (IDlist)? I used a similar formula to look up the ID for the person, but the reverse way (look up the person with the ID) comes up N/A.