custom filter data

[dp1979]

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

I understand that the mac version of excel does not offer the neat filtering options like the boxes to select criteria for filtering, but does anyone know how to use the custom filter to filter more than two catagories. I use excel quite a bit for work and I have large spread sheets that I need to see 4 or 5 different catagories within a row and I can only figure out how to get two on. Please Help Me!!

 

[CyberTaz]

AutoFilter does have limitations although I'm not certain what you're
referring to as "different categories within a row". The major constraint is
2 variables within a field [column] but you can filter on as many different
columns as you wish. If AutoFilter is unable to provide the results you are
looking for you might have a look at the Advanced Filter instead.

Another analytical tool to investigate is Pivot Tables. For large volumes of
data they may be exactly what you need.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

I understand that the mac version of excel does not offer the neat filtering
options like the boxes to select criteria for filtering, but does anyone know
how to use the custom filter to filter more than two catagories. I use excel
quite a bit for work and I have large spread sheets that I need to see 4 or 5
different catagories within a row and I can only figure out how to get two on.
Please Help Me!!

And in additions to what Cybertaz has stated the advanced filter work
virtually the same on mac and windows. The criteria are set up the same way
and produce the same results.

 

[CyberTaz]

Unfortunately Excel 2008 Help on the Advanced Filter is woefully missing you
can use this from Excel 2003 Help as a guide... As Bob G says, they're
virtually identical implementations. If you have any difficulty with the
"translation" reply here with your questions:

http://office.microsoft.com/en-us/excel/HP052001781033.aspx

HTH |:>)
Bob Jones
Mac Office MVP

AutoFilter does have limitations although I'm not certain what you're
referring to as "different categories within a row". The major constraint
is
2 variables within a field [column] but you can filter on as many
different
columns as you wish. If AutoFilter is unable to provide the results you
are
looking for you might have a look at the Advanced Filter instead.

Another analytical tool to investigate is Pivot Tables. For large volumes
of
data they may be exactly what you need.

HTH |:>)
Bob Jones
[MVP] Office:Mac

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

I understand that the mac version of excel does not offer the neat
filtering
options like the boxes to select criteria for filtering, but does anyone
know
how to use the custom filter to filter more than two catagories. I use
excel
quite a bit for work and I have large spread sheets that I need to see 4
or 5
different catagories within a row and I can only figure out how to get
two on.
Please Help Me!!