| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Progression matrix
Hi
I am using a large excel file, in both 2003 and 2007 versions. The data contains exam results based on exams 6 years apart and looks like this. KS2 Grade KS4 Grade 4 6 5 8 3 2 5 5 5 5 I need to produce a matrix which looks like this: KS4 1 2 3 4 5 6 7 8 KS2 5 2 1 4 1 3 1 2 Any help is much appreciated with many thanks in anticipation. Best wishes Nick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need help charting a time progression for investments | Charts and Charting in Excel | |||
| Representing purchasing progression on graph | Charts and Charting in Excel | |||
| formula auto-progression thru rows | Excel Discussion (Misc queries) | |||
| How do i get Excel 2003 to have a progression bar in the adjacent. | Excel Worksheet Functions | |||
Threaded Mode
