Filtering results from multiple columns containing the same number.

[lonniepoet]

I'm doing a project for work and it has columns that extend out to 'BH' and 3,416 rows. Columns S through BH contain a specific item number that I would like to filter out and display separately. I would like to only see the rows for customers that have a specific item number in one of their columns. However, my problem is that when I filter the data it only displays the results for one column. For example, I can display all the fields in column 'S' that display 4201-4445, but it doesn't display anything for the rest of the columns. Is there some way to pull and display all rows that contain item number 4201-4445 from multiple columns?

 

[eliW]

Welcome to the board.
In Column BI2 enter the function:
IF(COUNTIF(S2:BH2,"4201-4445")>0,1,0)
And copy down
then FILTER all "1" in column BI.
HTH

 

[lonniepoet]

Awesome. I think that will do the trick. Thank you so much!