Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I get excel search through a range of numbers e.g. 1.99 - . | Excel Worksheet Functions | |||
How do I set up Excel to search nearest resource by address | Excel Worksheet Functions | |||
How do I search for an asterisk in an Excel file--it thinks the a. | Excel Discussion (Misc queries) | |||
Excel - Formula Query: Search for and Return Value | Excel Worksheet Functions |