Unique values with alphabetically with multiple criteria

[rajeshn_in]

Hi friends,

Please find attachment, I want seller, buyer companies unique list with alphabetically.

thank you verymuch.

[MarvinP]

Hi rajeshn,

How about a pivot table answer where you don't even need a formula?

SELLER, BUYER Pivot No formulas needed.xlsx

[rajeshn_in]

But my colleagues don't know about pivot table, Please send formula if possible.

Thank you MarvinP,

[kvsrinivasamurthy]

ARRAY formula in I2 then dragged across up to J9. Pl see note below.

Please Login or Register  to view this content.

[FlameRetired]

Another way. This uses a helper column to identify the unique Division/Company combinations and the Alpha order of the Companies.

In C2 and filled down.

Please Login or Register  to view this content.

Then next to your sample in E2 filled across and down until you get blanks.

Please Login or Register  to view this content.

[rajeshn_in]

Thank you kvsrinivasamurthy.

[rajeshn_in]

Thank you FlameRetired

[FlameRetired]

You are welcome. Glad to help.