Excel - Choose Unique Rows (based on multiple columns)

tru504187211
tru504187211 used Ask the Experts™
on
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!!!!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Best bet is pivot table.

Make a pivot table on sheet 2. Choose source as sheet 1 (which will be adjusted). Make sure the source extends below the current data limit to accomodate future data additions.

Then every time the data is added, simply refresh the pivot on sheet 2. It will always pick up unique values.

Post a sample set if you want to see example

Author

Commented:
OK...

* 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).
Is it possible for you to provide a worksheet with the above sample data? Thanks!
SANTABABYSoftware Professional

Commented:
Attached is a sample workbook with formula, if you have questions, please ask.
Book2.xlsx

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial