tru504187211
asked on
Excel - Choose Unique Rows (based on multiple columns)
Hi everyone!
I've got an Excel problem...in one worksheet, I have a listing of all possible products (each with a model and a width -- these are for an inventory of shoes). One column is for the model and the next column is for width (there is also a column for the SKU, but this is irrelevant).
I have a second worksheet with a final tabulation of the inventory of each size, etc., but would like each combination (model with width) to be on the second worksheet once.
Example...
SKU STYLE SIZE WIDTH
873370009283 XPX761 11.0 W
873370009177 XPX761 11.0 M
873370009290 XPX761 11.5 W
873370009306 XPX761 12.0 W
873370009191 XPX761 12.0 M
873370009313 XPX761 13.0 W
The second worksheet should have... (because out of this list, these are the only two unique rows when only considering style and width).
STYLE WIDTH
XPX761 W
XPX761 M
Any ideas on how this can be done using a formula (for when there are additional rows added to the 1st worksheet)??
Thanks!!!!
I've got an Excel problem...in one worksheet, I have a listing of all possible products (each with a model and a width -- these are for an inventory of shoes). One column is for the model and the next column is for width (there is also a column for the SKU, but this is irrelevant).
I have a second worksheet with a final tabulation of the inventory of each size, etc., but would like each combination (model with width) to be on the second worksheet once.
Example...
SKU STYLE SIZE WIDTH
873370009283 XPX761 11.0 W
873370009177 XPX761 11.0 M
873370009290 XPX761 11.5 W
873370009306 XPX761 12.0 W
873370009191 XPX761 12.0 M
873370009313 XPX761 13.0 W
The second worksheet should have... (because out of this list, these are the only two unique rows when only considering style and width).
STYLE WIDTH
XPX761 W
XPX761 M
Any ideas on how this can be done using a formula (for when there are additional rows added to the 1st worksheet)??
Thanks!!!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Is it possible for you to provide a worksheet with the above sample data? Thanks!
Attached is a sample workbook with formula, if you have questions, please ask.
Book2.xlsx
Book2.xlsx
ASKER
* SKU Info Worksheet would have...
873370009177 XPX761 11.0 M
873370009290 XPX761 11.5 W
873370009306 XPX761 12.0 W
873370009191 XPX761 12.0 M
873370009313 XPX761 13.0 W
* Working Data Worksheet would have...
A list of SKU's taken from the scanning gun...
* Report Worksheet would have...
Style Width 4.0 4.5 5.0 5.5 6.0 6.5 7.0 7.5 8.0 8.5 9.0 9.5 10.0 10.5 11.0 11.5 12.0 13.0 14.0 15.0 16.0
...is the header.
For each size, their would be a count based on the SKU Info worksheet (what SKU is what size).