OK, I'm stumped or stupid

[Mark1]

Maybe it's because I've been working for 10 straight
hours, but I just cannot figure out the best way to do
this:

I've got two columns. One has names and the second has
titles. Example:

A B
Joe Blow Vice President
John Smith President
Big Daddy Office Worker
Wayland Smithers Vice President

Keep in mind, the real sheet has 42,000 records and
hundreds of titles. I want to delete all rows (or at
least clear all of them) if the title IS NOT Vice
president. I want my spreadsheet to look like this:

A B
Joe Blow Vice President
Wayland Smithers Vice President

What is the easiest way? Thanks!!!

 

[Don Guillett]

use data>filter>autofilter>custom> then <> "vice President"

 

[Domenic]

One way would be to use AutoFilter...

1) Select a cell within your table
2) Data > Filter > AutoFilter
3) Select "Vice President" from the dropdown arrow in Column B

Hope this helps!

 

[AlfD]

Hi!

Have you tried Data>Filter>Autofilter?

Al

 

[Dave Peterson]

With 42000 rows, I'd sort by column B.

Then delete the top section (finding the first "vice president"), then go past
the last one and delete the remaining rows.

 

[Dave Peterson]

The reason I didn't suggest Data|Filter|autofilter.

If your rows to keep is "evenly distributed", then deleting those visible rows
(with 42000 to start) could take longer than sorting.

But you could sort, then use data|filter|autofilter and it's not too bad.