Another Sorting Problem

[BenjieLop]

I need help in sorting some data please.

My input data are as follows:

Column A Column B
Employee Department
Brown Sales
Aikens Operations
Stephens Sales
Christian Accounting
Smith Sales
Watson Operations
Rosen Accounting
Woods Operations
Mendoza Accounting


I would like to "sort" the employee names by Department. My outpu
would look something like this.

Column X Column Y Column Z
Accounting Operations Sales
Christian Aikens Brown
Rosen Watson Stephens
Mendoza Woods Smith

I realize that there is an Excel formula for this and as usual, thank
in advance for your time and help.

Regards

 

[duane]

I'd use autofilter to get the data you want and then paste it somewhere

 

[BenjieLop]

I have tried Data/Filter/Autofilter and I cannot seem to get the outpu
that I like. Can you give me some step-by-step instructions please?

As in my original post, I still prefer an Excel formula if possible
However, if the autofilter is the only way, then I guess, I do not hav
any choice but go this route.

Thanks again.

 

[Domenic]

Enter the following formula in X2, copy across and down:

=INDEX($A$1:$A$10,SMALL(IF($B$2:$B$10=X$1,ROW($A$2:$A$10)),ROW(1:1)))

...to be entered using CTRL+SHIFT+ENTER.

Hope this helps

 

[BenjieLop]

Thank you very much, Domenic ... this is the formula that I need.

Regards and more power to you.