can autofilters be applied to rows rather than columns?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

| 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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

autofilter with summary row 1
Autofilter Not working completely 2
Autofilter misses last line 7
Autofilter to filter out non-numeric rows 3
Excel Help to copy information from one row at a time to another sheet 1
Autofilter functionality 3
Filter for "blanks" in multiple columns simultaneously 2
Apply all autofilters 1

Back
Top