Formula to group simple Skus based on main grouped Sku?

[wonderd]

Hello everyone I have attached an example of what I am trying to do. example.xlsx

I am looking for a way to get the results of column C starting at row 27 by using a formula. I am not sure how this would be done with a formula but I am hoping someone can help me.

My thinking would be I need a formula that grabs the grouped sku starting at A27 then searches column B. Then if it find the grouped sku in column B it will grab all the simple skus next to it in column A and put them in Column C separated by commas.

If anyone is wondering this is for products spreadsheet that will be imported into magento.

[wonderd]

I think a macro might be needed for this, maybe I put it in the wrong sub forum...?

[FDibbins]

Hi and welcome to the forum

Not sure if this is what you want, but take a look.
In C2, copied down use this...
=IF(B2=B3,"",D2)

Then in D2, copied down, use this...
=IF(B2=B1,C1&","&A2,A2)
You can then hide column D

[wonderd]

Hmm no I don't think that's what I am looking for, I am trying to get the result in red using a formula http://screencast.com/t/xvPKT7W5

it is looking at the sku in A27, then searching column B for that sku, then it is grabbing the simple sku from column A and putting all the simple skus together seperated by commas

[wonderd]

So is this a macro or do you think it could be achieved by a formula? I have been trying for over a day to figure this out but I am not very good with formulas.

[:) Sixthsense :)]

Check Post # 4 of the below link
http://www.excelforum.com/excel-form...e-returns.html

[wonderd]

Hey this looks like it may work but I cant get it to work. Take a look at my fileCLookup_Solution_test.xlsb

[:) Sixthsense :)]

You have just restricted the Lookup and Result Range from 1 to 9 rows

Please Login or Register  to view this content.

change the reference to cover the entire range like this...

Please Login or Register  to view this content.

[wonderd]

Thanks Guys