Spreadsheet question

[Sly]

Say I have a spreadsheet with 5000 rows of data. In column B of each of those rows it says what kind of car it is (Chevrolet, Honda, etc.) I want to filter out all of the rows that are Chevrolet and only keep the rows that are Honda. How do I do this?

[EDepth]

Sort your column by selecting it and then hitting the A-Z button, then copy & paste?

[Sly]

Looks like that worked perfectly... thanks.

[RuthB]

I'm using Office 2007, so not sure if you're using that or another one, but this is how I'd do it in Excel 2007...


Make sure you're on the HOME tab, and then to the far right on the menu bar you will see.. "Sort & Filter" as an option

Click that and then select Filter (you should have column headers for this to work best)

You will then see a drop down arrow next to each entry in the top row (Row 1) which should be your headers. Go to the column that contains the model and click the arrow

Now scroll down the drop-down list to TEXT FILTERS and go to CUSTOM FILTER

You will see it says 'Show rows where: 'column title' ..."

From that drop-down select 'DOES NOT EQUAL' and then type in Chevrolet, or however you have that phrased

Then click OK and it will no longer show any of the rows (all information in each row is suppressed) that have Chevrolet in it

That's using Office 2007

[Sly]

Thanks Ruth.

I do have Office 2007 but find that Excel is too slow... so typically I use the Open Office version. It works pretty well and loads a lot faster.