Doing a grouped search in Excel.

M

mikkellund

Hello,

I need to do a grouped column search. I want to search by 'x OR x OR
x...etc.' How is this possible?

Pardon me if the answer is easy, but I have looked at the ctrl-f
function in excel and it does not look like it can do the job.

Thank you,
Mikkel Lund Jensen
 
D

Dave Peterson

I'd use a helper column with a formula.

=or(a1="hi",b1="there",c1="Mikkellund")

Then drag this down and apply data|filter|autofilter.

Filter by what you want to see (true/false).

(I'm not sure what a grouped column is, though. So I could be way off base.)

===
Another option is to use Data|Filter|Advanced filter.
See Debra Dalgleish's site for some nice instructions:
http://www.contextures.com/xladvfilter02.html
 
Top