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 How do I go about accomplishing this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help needed with cell reference | Excel Discussion (Misc queries) | |||
Lookup or reference function needed | Excel Worksheet Functions | |||
Address List Sort Help Needed - 1 attachment | Excel Discussion (Misc queries) | |||
Maintain Formula Reference (sort of) | Excel Worksheet Functions | |||
Look Up and Cell Reference - Formula Help Needed | Excel Worksheet Functions |