software

I want to extract each row from a range when one specifice value exists in
that row.
CATSCAT1CAT2CAT3CAT4
0102095374
0102
010254
87
55
0102
0102047475
0102042229
01020454
0102040441
0102040452
From the example above, I want to list the data from each row when quot;04quot;
exists in any of the rows columns. The complete range is 207 columns and 1395
rows. There are a total of 25 columns that could contain the value I filter
by.

Add a new column and use a formula like:

=countif(a2:Z2,quot;04quot;)
and drag down

Then filter to show greater than 0.
Usul wrote:
gt;
gt; I want to extract each row from a range when one specifice value exists in
gt; that row.
gt; CATS CAT1 CAT2 CAT3 CAT4
gt; 01 02 09 53 74
gt; 01 02
gt; 01 02 54
gt; 87
gt; 55
gt; 01 02
gt; 01 02 04 74 75
gt; 01 02 04 22 29
gt; 01 02 04 54
gt; 01 02 04 04 41
gt; 01 02 04 04 52
gt; From the example above, I want to list the data from each row when quot;04quot;
gt; exists in any of the rows columns. The complete range is 207 columns and 1395
gt; rows. There are a total of 25 columns that could contain the value I filter
gt; by.

--

Dave Peterson