SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Help - Very easy Question
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

rchau861
Starting Member

5 Posts

Posted - 12/12/2012 :  13:19:48  Show Profile  Reply with Quote
Hello I am not good at excel 2007.

How do I filter a column in excel 2007 the way i would in SQL?

Lets say I do not want to see certain values.

In SQL i would say

select ***********

NOT IN('a','b','c')


How do I accomplish this task in Excel 2007?

shilpash
Posting Yak Master

103 Posts

Posted - 12/12/2012 :  13:35:28  Show Profile  Reply with Quote
Highlight the cells that will be sorted
Click the Sort & Filter button on the Home tab
select the one you want to filter
Go to Top of Page

RajanThan
Starting Member

India
7 Posts

Posted - 12/13/2012 :  02:17:31  Show Profile  Reply with Quote
select Data in the top of Excel book. you will find Filter icon in the ribbon.

Select the column you want to apply filter, then click the filter icon from the ribbon.



Rajan
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000