Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort/Reference formula help needed. | Excel Discussion (Misc queries) | |||
Help needed with cell reference | Excel Discussion (Misc queries) | |||
Lookup or reference function needed | Excel Worksheet Functions | |||
Maintain Formula Reference (sort of) | Excel Worksheet Functions | |||
Look Up and Cell Reference - Formula Help Needed | Excel Worksheet Functions |