can autofilters be applied to rows rather than columns?
 

Is it possible to filter a database set out in rows instead of columns?
Alternatively what would be the best way to isolate matching data without
using HLookups?

cheers,
Nadia

I don't think that it will work that way.
Are you able to Transpose your database? If so, then you'd be able to use
the Auto Filter.
Rgds,
ScottO

"Nadia" wrote in message
...
| Is it possible to filter a database set out in rows instead of columns?
| Alternatively what would be the best way to isolate matching data without
| using HLookups?
|
| cheers,
| Nadia

Thanks Scott, that was my immediate thought.. but you never know. I never
assume I know all the tricks especially with excel.
cheers,
Nadia

"ScottO" wrote:

I don't think that it will work that way.
Are you able to Transpose your database? If so, then you'd be able to use
the Auto Filter.
Rgds,
ScottO

"Nadia" wrote in message
...
| Is it possible to filter a database set out in rows instead of columns?
| Alternatively what would be the best way to isolate matching data without
| using HLookups?
|
| cheers,
| Nadia