Jill
07-13-2017, 10:11 PM
Hi All,
I'm fairly new to excel and have been trying to solve this for a few days. I've tried formulas and macros. Essentially I want to take a list of data (two columns). If the data in row 1 (2 columns) matches another row exactly (2 columns) then count and copy the data. Here is an example.
Turn this data
1.63 x 1.63 x 1
Diamond_Round
1.87 x 1.87 x 1.15
Diamond_Round
1.87 x 1.87 x 1.15
Diamond_Round
2.32 x 2.32 x 1.43
Diamond_Round
1.63 x 1.63 x 1
Diamond_Round
1.63 x 1.63 x 1
Diamond_Round
1.87 x 1.87 x 1.15
Diamond_Round
2.32 x 2.32 x 1.43
Diamond_Round
1.87 x 1.87 x 1.15
Diamond_Round
1.63 x 1.63 x 1
Diamond_Round
Into this data
4
1.63 x 1.63 x 1
Diamond_Round
4
1.87 x 1.87 x 1.15
Diamond_Round
2
2.32 x 2.32 x 1.43
Diamond_Round
As background info, I have a script that runs in another program and populates an excel with this bill of material info for each product sku. So the data ported to the excel is never the same. I had luck with a pivot table, but as soon as the data changes, the table no longer works.
I'm attaching a spreadsheet with some sample data.
I've read countless posts and feel I'm at a dead end. Any help is appreciated.
Thanks in advance,
Jill
I'm fairly new to excel and have been trying to solve this for a few days. I've tried formulas and macros. Essentially I want to take a list of data (two columns). If the data in row 1 (2 columns) matches another row exactly (2 columns) then count and copy the data. Here is an example.
Turn this data
1.63 x 1.63 x 1
Diamond_Round
1.87 x 1.87 x 1.15
Diamond_Round
1.87 x 1.87 x 1.15
Diamond_Round
2.32 x 2.32 x 1.43
Diamond_Round
1.63 x 1.63 x 1
Diamond_Round
1.63 x 1.63 x 1
Diamond_Round
1.87 x 1.87 x 1.15
Diamond_Round
2.32 x 2.32 x 1.43
Diamond_Round
1.87 x 1.87 x 1.15
Diamond_Round
1.63 x 1.63 x 1
Diamond_Round
Into this data
4
1.63 x 1.63 x 1
Diamond_Round
4
1.87 x 1.87 x 1.15
Diamond_Round
2
2.32 x 2.32 x 1.43
Diamond_Round
As background info, I have a script that runs in another program and populates an excel with this bill of material info for each product sku. So the data ported to the excel is never the same. I had luck with a pivot table, but as soon as the data changes, the table no longer works.
I'm attaching a spreadsheet with some sample data.
I've read countless posts and feel I'm at a dead end. Any help is appreciated.
Thanks in advance,
Jill