Help - Very easy Question - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Help - Very easy Question

Author

Topic

rchau861
Starting Member

5 Posts

Posted - 2012-12-12 : 13:19:48

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 - 2012-12-12 : 13:35:28

Highlight the cells that will be sorted
Click the Sort & Filter button on the Home tab
select the one you want to filter

RajanThan
Starting Member

7 Posts

Posted - 2012-12-13 : 02:17:31

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources