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