can autofilters be applied to rows rather than columns?

N

Nadia

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
 
S

ScottO

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

| 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
 
N

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
 
Top