Autofilter across a single row -- is this possible? (repeat, sorry

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

Guest

Hi, I'm hoping there is some way to filter across a row, as opposed to a
single column. Can this be done with autofilter? If it can, I'm not doing it
right, so please help!
 
If you mean to only show values in a row that correspond to some criteria, and hide columns, then
no, not without a macro. The best solution in that case would be to transpose your data table.

HTH,
Bernie
MS Excel MVP
 
I'm sorry - what do you mean without a macro? Sort of an idiot when it comes
to excel!! How would I do this?
 
Ah! I see you have posted twice. Please do not do this as it fragments
any responses you might get and wastes respondents' time. My answer
(elsewhere) is similar to those you have received here.

Pete
 
I mean that you need to use a macro to hide columns based on values in a
row - unlike hiding rows based on values in a column, which is built-in. A
macro is computer code that tells Excel what to do - you can do almost
anything - but I'm not clear on exactly what you want to do.

Post a short example of what you have, and what you want, and we can go from
there.

HTH,
Bernie
MS Excel MVP
 
Back
Top