Sort/Reference formula help needed.
 

Currently I have a data sheet that looks like this:

_____A_______B___
1____A_____Data 1
2____B_____Data 2
3____A_____Data 3
4____C_____Data 4
5____B_____Data 5

I want to create a column that will sort and display and list all of the
"A's" in Column A, all of the "B's" in another column, all of the "C's" in
another column, and so on.

Basically I want it to read like this:
___A______B______C__
Data 1___Data 2__Data 4
Data 3___Data 5__

What I want to do is to sort and display names in separate columns based
upon a ranking format of A,B,C,D. I want all of the A's in one column, all
of the B's in another, all of the C's in a third, and all of the D's in the
fourth.

Currently, in my data sheet, the A-D ranking is in columns L7:L150, with the
names in columns M7:M150.

Any insight on how to accomplish this? Thanks for everyone's help.

Sort/Reference formula help needed.
 

There at least three ways:

1. Use AutoFilter to display only the "A"-coded rows and then copy/p[aste
the data items. Then manually repeat this for the "B"-coded items. This is
a manual process

2. Use the technique described in:
http://office.microsoft.com/en-us/ex...260381033.aspx
This technique is similar to VLOOKUP(), but will get all the matching items,
not just the first.

3. Write a custom Macro.
--
Gary''s Student - gsnu200850


"Scott" wrote:

Currently I have a data sheet that looks like this:

_____A_______B___
1____A_____Data 1
2____B_____Data 2
3____A_____Data 3
4____C_____Data 4
5____B_____Data 5

I want to create a column that will sort and display and list all of the
"A's" in Column A, all of the "B's" in another column, all of the "C's" in
another column, and so on.

Basically I want it to read like this:
___A______B______C__
Data 1___Data 2__Data 4
Data 3___Data 5__

What I want to do is to sort and display names in separate columns based
upon a ranking format of A,B,C,D. I want all of the A's in one column, all
of the B's in another, all of the C's in a third, and all of the D's in the
fourth.

Currently, in my data sheet, the A-D ranking is in columns L7:L150, with the
names in columns M7:M150.

Any insight on how to accomplish this? Thanks for everyone's help.