How to do a search in Excel? Complicated [Closed]

Report
-
Posts
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 2021
-
Hello,

I've got a question, I just want to ask if anyone here know how to do a search in Excel but is a more complicated version. What I have is that I have a list of different names and with each name there is 4 columns and I want to be able to search it up and all those 4 columns will appear.

For example, I have,
Cell A B C D E
1 Apple 5 6 7 8
2 Boy 8 9 10 11
3 Cat 1 3 5 7

And what i want to do is that when i search for apple; not only just apple but 5 , 6, 7, 8 will also appear.

Thank you very much. Please help me ASAP. Thank you.

1 reply

Posts
2758
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 17, 2021
462
Hi HTFB,

Have you heard of excel's autofilter?
First insert a row before your first row (because you don't have a header row).
Goto top menu's > data > filter > autofilter.
Select the dropdown list in cell A1.
Select Apple, see the result and report back if you are happy.

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!