GoFuckYourself.com - Adult Webmaster Forum - View Single Post

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

03-27-2009, 02:11 PM
RuthB Let's Get Paxumized! Industry Role: Join Date: May 2005 Location: Vancouver, Canada Posts: 7,248	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