Excel - Choose Unique Rows (based on multiple columns)
Posted on 2012-12-28
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.
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).
Any ideas on how this can be done using a formula (for when there are additional rows added to the 1st worksheet)??