• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need help to capture data

A

asowdi

New Member
Friends

I have two columns A and B. "A" carries Task Name, "B" with the Engineer name.

Engineers name repeat in "B" column assuming same engineers handle different tasks.


I am trying to capture task handled by each engineer in one cell separated by commas. Can anyone help me to get the right functions?

I tried with Indexing and other functions, I am not successful. Please help

I have copied Sample file in below path, the cells in green color will show the requirement.


https://skydrive.live.com/redir.aspx?cid=86654bd6a8af53d1&resid=86654BD6A8AF53D1!107&parid=86654BD6A8AF53D1!106
 
Hi Ashwin,


I think this is a re-post! BTW it will be easier for you if you follow the alternate approach that i already mentioned to you. That is more practical to me, However I believe that the thing you are asking for might be possible very easily with some vba code. Here is the file with formula i already told you:


http://dl.dropbox.com/u/60644346/Sample%20-2(2).xlsx


This contains a formula (by me) and a set of code for UDF i found from here:

http://www.ozgrid.com/forum/showthread.php?t=80589&p=403189#post403189


Regards,

Faseeh
 
Thanks Faseeh,

u r right, this was the repost....i could not able to fetch the detail last time so reposted.

Many thanks for your time.
 
You must log in or register to reply here.
Back
Top