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