 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / July 2007VLOOKUP worksheet
Worksheet1, column A job and person name, i.e. "Big Job - Dave" I need Worksheet 2 to bring in all instances of "- Dave" I have used VLOOKUP but I am not sure how to do this one. Help! On 18-07-2007 13:15, in article 1184757352.527745.102840@g12g2000prg.googlegroups.com, "dzelnio" > Worksheet1, column A job and person name, i.e. "Big Job - Dave" > I need Worksheet 2 to bring in all instances of "- Dave" > > I have used VLOOKUP but I am not sure how to do this one. > > Help! You might want to look at the 'Advanced Filter' tool. It can filter a list and report it to another worksheet. Regards Jan Why are you posting the same issue more than once? You now have responses in two different places - both involving the use of Filter features the program has to offer.  SignatureRegards |:>) Bob Jones [MVP] Office:Mac > Worksheet1, column A job and person name, i.e. "Big Job - Dave" > I need Worksheet 2 to bring in all instances of "- Dave" > > I have used VLOOKUP but I am not sure how to do this one. > > Help! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.