I am trying to find a function that will help me do the following (without using VBA). So suppose i have the following data:
http://i.imgur.com/Ql2Z7yR.jpg
I need it to be the following format:
http://i.imgur.com/OkRsbKE.jpg
Basically, I need to get all the associated sku's (column F) from the parent_sku (column E) into column G comma delimited.
Any help would be GREATLY appreciated!
This is a excel forum
Post a xls file and not a jpg.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
It looks like you just want to CONCATENATE - check it out!
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Here it is
=CONCATENATE(F2,F3,F4,F5,F6)
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
@xladept & @AlKey
Thanks for the quick response. Unfortunately, a simple concatenate wouldn't work as the # of cells above each parent sku vary. I've tried a VLOOKUP but that only returns the first value from the parent_sku. See attached, the green column is how it's supposed the look, the yellow cells are where there needs to be those values.
Then there is another option with VB UDF where you can select a range and not pick individual cells. Are you open for VBA solution?
While I'm very comfortable with excel, I'm very limited with regard to VBA. I feel as though there is function out there utilizing the INDEX/MATCH and VLOOKUP - or even something like a SMALL and then +1 until it goes through all the values associated with the parent sku and adds them to that cell...
@AlKey were you referring to this site?
http://www.get-digital-help.com/2010...into-one-cell/
Works perfectly!!!
Yes, but there is no function will put all values in one cell.
The vba solution is very easy just follow these simple instructions
1.Press Alt+F11 on your keaboard. This will open VB Editor.
2. At the top, click on Insert and click on Moduel
3. Copy code below and paste it into Module
4.Close Module and close VB Editor.
Make sure to save your workbook as Micro-Enabled
That's all.
Code
use formula =UnionCell(A1:A10)
Please Login or Register to view this content.
Take a look at the attached file, it puts everything in one cell separated by a " " (which can be easily edited in the VBA script).
D7 is where the function is.
Glad that your issue has been resolved
Don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
Hi amazinz2006,
ALKey's function works where the formula doesn't (namely in D14)???
The Merge Assistant, http://www.add-ins.com/merge_assistant.htm, has a feature that will do what you want
Thank you for your feedback!
Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks