Can anyone help please

Anonymous
2024-07-22T10:42:04+00:00

quite new to excel, so wondered if anyone can help

i had added a search text box and coded as below

=FILTER(H6:J18,ISNUMBER(SEARCH(C2,H6:H18)),"None")

But i ideally want to be able to search under any column to bring back the results, can anyone help and see what im ding wrong

tia

Microsoft 365 and Office | Excel | For education | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2024-07-22T10:53:46+00:00

Try

=FILTER(H6:J18, BYROW(H6:J18, LAMBDA(rw, COUNTIF(rw, "*"&C2&"*"))), "")

Was this answer helpful?

1 person found this answer helpful.
0 comments

7 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-07-22T14:48:42+00:00

    hi hans

    its stopped working on searching the other colums and im getting a message spill when i do.

    still searched on main column but nothing else

    using the below. any odeas please

    =FILTER(H6:I30, BYROW(H6:I30, LAMBDA(rw, COUNTIF(rw, "*"&C2&"*"))), "")

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-07-22T13:26:54+00:00

    hi Hans, dont worry thankyou what you have done is great.

    just one question i have the text"spill" any ideas what thats for please

    Was this answer helpful?

    0 comments
  3. Anonymous
    2024-07-22T11:22:16+00:00

    What do you mean by "any partial text"?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2024-07-22T11:08:16+00:00

    thanks Hans works perfect.

    just pushing it once more is there a way to serach by any partial text in any colun?

    Was this answer helpful?

    0 comments