Listing uniques

[scruz9]

Hi Everyone,

I have a sample attached of what I'd like exactly like to do.

In my real data set, I have vendors (vendor list is over 200+) associted with departments. I want to list all of the vendors and listing the departments that report under it (distinct only).

The example is in the "Summary Tab". Vendor "ABC" has Class D listed twice, but in the Summary tba it's only listed once. If possible t do this view and the opposite. So Vendor and associted Classes. and than Class and associated venodrs.

[FlameRetired]

Assuming ABC, DEF already in row 1 array enter this in A2 fill down and across until you get blanks.

Please Login or Register  to view this content.

If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.