Doing a grouped search in Excel.
 

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


--
mikkellund
------------------------------------------------------------------------
mikkellund's Profile: http://www.excelforum.com/member.php...o&userid=24978
View this thread: http://www.excelforum.com/showthread...hreadid=385433

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


mikkellund wrote:

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

--
mikkellund
------------------------------------------------------------------------
mikkellund's Profile: http://www.excelforum.com/member.php...o&userid=24978
View this thread: http://www.excelforum.com/showthread...hreadid=385433

--

Dave Peterson