K Kromulis New Member May 13, 2015 #1 I'm looking to hide a row if no columns in the row contain the word "Investigate" and the value can be in multiple columns? So in the end all I'm showing is rows that contain investigate in any column.
I'm looking to hide a row if no columns in the row contain the word "Investigate" and the value can be in multiple columns? So in the end all I'm showing is rows that contain investigate in any column.
Luke M Excel Ninja Staff member May 13, 2015 #2 I'd build a helper column with the formula: =COUNTIF(A2:Z2,"Investigate")>0 and filter that column for TRUE.
I'd build a helper column with the formula: =COUNTIF(A2:Z2,"Investigate")>0 and filter that column for TRUE.
