Filter basic .

[Sunline]

Hello all , have read thru the search area here and am trying too filter for data in a similar way to M/s Access advanced filter sort .

Could someone point me too where i should be looking to learn this and what it may be called in Excel . I have only used basic filter so far . Thanks .

 

[xenou]

Excel advanced filter is something like what you want, but not exactly what's in Access. It seems to be better in 2010, even with your basic filter tools.

http://www.excelfunctions.net/ExcelAdvancedFilter.html
http://www.contextures.com/xladvfilter01.html
http://www.contextures.com/xladvfilter02.html

With Excel 2010:
http://blog.contextures.com/archives/2010/07/12/new-search-feature-in-excel-2010-autofilter/
http://blogs.office.com/b/microsoft-excel/archive/2010/01/25/table-improvements-in-excel-2010.aspx

 

[Sunline]

Thankyou .