Filter multiple columns, duplicate values

Hi,

I have rows of support logs where I have put some tags off to the right in order to sort the support issues (for Quickbooks support).

Since there are multiple columns with the tags that I'm making up as I go along, and the tag could be in any of the far right columns,

I would like to do this: Make a filter that uses columns D through H all at once and lets me choose, for example "Billing"

so that every row that has Billing will be left, no matter which of the tag columns Billing appears in.

Attached is a sample of the sheet.

Thanks for any help.

I' not sure I understand your intent and it's a little hard to help without a model sheet, but I give it a try.

Assuming tag filter in cell J1, for example, try this array formula (paste it in desired cell and, while holding ctrl and shift keys down, hit enter):

=IFERROR(INDEX($A$2:$C$11,SMALL(IF($D$2:$H$11=$J$1,ROW($D$2:$D$11)-1),ROW($A1)),COLUMN(A$1)),"")

Then copy across and down to fill columns and rows.

Thanks for the response. I see that since you mentioned column J, I didn't explain it properly.

Attached is a model sheet. On this sheet, for example, I would like to narrow down the rows to only those that have Billing in any one of the Topic columns.

Is there not a way to apply one filter to columns D thru H (instead of a filter for each individual column), to easily pick out the topic from the usual filter drop-down list?

Thanks

I guess the main point is can I have the selection list that shows if one column has a filter, but spread that selection list out over multiple columns (all the Topic columns),
instead of having to put a criteria in some other cell.

Attached is an illustration of what I'm looking for.

I've come up with new idea. Please check attachment.

In K1, a data validation to select Topic from a topics list I placed in column L.

A helper column (I) to populate with topic selected in K1 with formula below.

=IFERROR(INDEX(D2:H2,,MATCH($K$1,D2:H2,0)),"")

That single column will enable desired multi column, row filter.

Please run tests and let us know if it works.

Looks like that worked!

Thanks, I'll have to examine that and get to understand what you did there