Spreadsheet question - GoFuckYourself.com

Sly · 03-27-2009, 01:46 PM

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 · 03-27-2009, 02:04 PM

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

Sly · 03-27-2009, 02:08 PM

Looks like that worked perfectly... thanks.

RuthB · 03-27-2009, 02:11 PM

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 · 03-27-2009, 02:16 PM

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.

03-27-2009, 01:46 PM	#1
Sly Let's do some business! Industry Role: Join Date: Sep 2004 Location: Austin, TX Posts: 31,326	Spreadsheet question 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? __________________ Vacares - Web Hosting, Domains, O365, Security & More - Paxum and BTC Accepted Windows VPS now available Great for TSS, Nifty Stats, remote work, virtual assistants, etc. Click here for more details.

03-27-2009, 02:04 PM	#2
EDepth Confirmed User Join Date: Nov 2005 Location: Seattle, WA Posts: 510	Sort your column by selecting it and then hitting the A-Z button, then copy & paste? __________________ ICQ: 275335837

03-27-2009, 02:08 PM	#3
Sly Let's do some business! Industry Role: Join Date: Sep 2004 Location: Austin, TX Posts: 31,326	Looks like that worked perfectly... thanks. __________________ Vacares - Web Hosting, Domains, O365, Security & More - Paxum and BTC Accepted Windows VPS now available Great for TSS, Nifty Stats, remote work, virtual assistants, etc. Click here for more details.

03-27-2009, 02:11 PM	#4
RuthB Let's Get Paxumized! Industry Role: Join Date: May 2005 Location: Vancouver, Canada Posts: 7,247	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 __________________ Send & Receive Mass Global Payments - Mass P2P/Wire/EFT/SEPA - Adult Industry Friendly - Award Winning Payment Service - Fast, Reliable & Secure! Paxum ...... Paxum Bank Email: [email protected] ~ Telegram: PaxumRuth

03-27-2009, 02:16 PM	#5
Sly Let's do some business! Industry Role: Join Date: Sep 2004 Location: Austin, TX Posts: 31,326	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. __________________ Vacares - Web Hosting, Domains, O365, Security & More - Paxum and BTC Accepted Windows VPS now available Great for TSS, Nifty Stats, remote work, virtual assistants, etc. Click here for more details.