I have a massive excel sheet with a few thousand rows and columns. I need to identify those rows that have a certain code. The code can be in any column.
Here is an example table to make this more clear:
# code code code code
1 999 999 313 999
2 999 999 999 999
3 999 313 999 999
4 999 999 999 313
5 999 999 999 999
Which function should I use to identify those with the code 313 and document it a new column, like this:
# code code code code new column
1 999 999 313 999 1
2 999 999 999 999
3 999 313 999 999 1
4 999 999 999 313 1
5 999 999 999 999
ISNUMBER function works for one column, but didn't manage to expand it to a table (multiple columns).
Many thanks for your help!