this is a situation where I think Excel can explain that IF Xn has Yn that has size values show up twice or more, it will show me a list of just those items.

I am working with data on clothing, it has item, style, description, attribute (color), size.

I wrote it out in terms... perhaps it makes sense.

Xn- refers to all possible style numbers, there are probably more than 100 in a given sheet. xn+1, xn+2, and so on.

Yn- refers to all possible colors within an Xn group of items. (there are many items within a style due to size and color)

I wrote it out like this:

Within Xn, and within Yn, find text values= XS, S, M, L, XL

If condition exists where 2 or more of these situations occur, count them and show them.

If I were to create such a function, I would call it my '2 or more' function.