Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Multiple References
In Column A is list of Names, and Column B is a different set of names, however several of those names occur multiple times. There are several other columns that have other information. I would like, in a seperate area, to input which Column B name to search for, then all the records involving that person will appear. For example: Bill Todd Grade4 Red Jeff Cory Grade9 Yellow Eric Sean Grade2 Blue Dave Todd Grade1 Green Rita Todd Grade7 Yellow Sean: Eric Blue Grade2 Todd: Bill Red Grade4 Dave Green Grade9 Rita Yellow Grade7 Thanks in advance, Jonathan -- pjonathan ------------------------------------------------------------------------ pjonathan's Profile: http://www.excelforum.com/member.php...o&userid=19495 View this thread: http://www.excelforum.com/showthread...hreadid=345734 |
#2
|
|||
|
|||
Hi, pjonathan;
You could filter column B for a particular name, or, you could select a cell in column B and sort the whole list, so: Jeff Cory Grade9 Yellow Eric Sean Grade2 Blue Bill Todd Grade4 Red Dave Todd Grade1 Green Rita Todd Grade7 Yellow Regards, Ian. "pjonathan" wrote: In Column A is list of Names, and Column B is a different set of names, however several of those names occur multiple times. There are several other columns that have other information. I would like, in a seperate area, to input which Column B name to search for, then all the records involving that person will appear. For example: Bill Todd Grade4 Red Jeff Cory Grade9 Yellow Eric Sean Grade2 Blue Dave Todd Grade1 Green Rita Todd Grade7 Yellow Sean: Eric Blue Grade2 Todd: Bill Red Grade4 Dave Green Grade9 Rita Yellow Grade7 Thanks in advance, Jonathan -- pjonathan ------------------------------------------------------------------------ pjonathan's Profile: http://www.excelforum.com/member.php...o&userid=19495 View this thread: http://www.excelforum.com/showthread...hreadid=345734 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
summing multiple rows with like references | Excel Worksheet Functions | |||
Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
Return Multiple Results with Lookup | Excel Worksheet Functions | |||
XML / parent with multiple children and with multiple children | Excel Discussion (Misc queries) | |||
Why do multiple circular references affect each other in a worksh. | Excel Discussion (Misc queries) |