Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find, sort, and copy data
Hi, everybody,
I am desperately looking for a solution to do the following: I have a list of students with courses they are taking. Unfortunately this list (which is imported from another program) comes with all the courses jumbled. What I need is to automatically sort the courses in each line according to a pre-defined order. Example: student A e1 c5 u7 a7 student B u7 e1 - c5 student C e9 u7 t8 - should be turned into student A a7 c5 e1 u7 student B - c5 e1 u7 student C t8 e9 - u7 The order of courses is not alphabetical, it depends on the timetable. The first column should (for example) only contain courses t8, a7, u2 the second colum c5, e9, k6. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
find, sort, and copy data
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOw do i find and sort out data repeats for specific data set | Excel Discussion (Misc queries) | |||
Pls. reply Sort Data and copy to next coulmn when sort order chang | Excel Programming | |||
Sort Data and copy to next coulmn when sort data changes | Excel Programming | |||
Sort Data and copy to next coulmn when sort data changes | Excel Programming | |||
How can I find and sort specific data within a column? | Excel Discussion (Misc queries) |