Hi, I'm having a problem with returning a list of names with one reference and returning them to one cell reference.
To explain, I have a reference code, with a number of names listed under that code, and on another sheet I have the code and need the names to CONCATENATE into one cell only.
I have attached an example to help clear this up. Any help would be most appreciated as there are a number thousands of lines.
Hi Andrew,
Welcome to the forum.
Do you want to repeat codes as well like you have shown in F18:F20?
Do you want the names to appear in one cell like G18 or it would be fine if that names are there on different cells like G18, H18, I18.. but offcourse in on line. ?
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks