Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying Data in Matrix
I have an excel sheet showing individual names with 2 ratings each for different elements of performance - example below Name What How Fred Bloggs 1 1 Jane Smith 2 3 Danny DeVito 2 2 Harrison Ford 2 1 Jon Davies 4 2 David Fleet 2 3 Terence Baker 1 2 Jo Fraser 3 4 Tina Maquire 1 3 Gloria Gaynor 2 1 David Oliver 1 1 Diane Martin 3 2 Michelle Page 3 1 Mark Randall 2 3 Katherine Heppburn 3 1 Andrew Bartley 3 3 Harry Mulford 1 1 Janice Greer 2 2 Henry Evans 1 2 Liz Taylor 2 1 Nicky Clark 2 1 I want to display this in a 16 Box Matrix, where each of the 16 cells may have more than one person. As the performance rating combinations are not unique I have not found a worksheet function that could do this. Can anybody help on the VB side? I have a little VB experience but wouldn't know where to start with this one! Many thanks . -- Sue |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying Data in Matrix
Hi
This is what you say you want "I want to display this in a 16 Box Matrix, where each of the 16 cells may have more than one person. As the performance rating combinations are not unique I have not found a worksheet function that could do this. " Nobody but yourself can have much idea what this might mean unfortunately. You have described what you have in a table. Can you show the table you WANT to see, and describe the process of getting it from your original table. regards Paul On May 20, 3:33*pm, Sue wrote: I have an excel sheet showing individual names with 2 ratings each for different elements of performance - example below Name * * * * * * * What * * * * How Fred Bloggs * * 1 * * * 1 Jane Smith * * *2 * * * 3 Danny DeVito * *2 * * * 2 Harrison Ford * 2 * * * 1 Jon Davies * * *4 * * * 2 David Fleet * * 2 * * * 3 Terence Baker * 1 * * * 2 Jo Fraser * * * 3 * * * 4 Tina Maquire * *1 * * * 3 Gloria Gaynor * 2 * * * 1 David Oliver * *1 * * * 1 Diane Martin * *3 * * * 2 Michelle Page * 3 * * * 1 Mark Randall * *2 * * * 3 Katherine Heppburn * * *3 * * * 1 Andrew Bartley *3 * * * 3 Harry Mulford * 1 * * * 1 Janice Greer * *2 * * * 2 Henry Evans * * 1 * * * 2 Liz Taylor * * * * * * * * * * *2 * * * 1 Nicky Clark * * 2 * * * 1 I want to display this in a 16 Box Matrix, where each of the 16 cells may have more than one person. *As the performance rating combinations are not unique I have not found a worksheet function that could do this. Can anybody help on the VB side? *I have a little VB experience but wouldn't know where to start with this one! Many thanks . -- Sue |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting Matrix Data | Excel Discussion (Misc queries) | |||
Manipulating a matrix of data | Excel Discussion (Misc queries) | |||
Any tools to manage data for 3D-matrix | Excel Discussion (Misc queries) | |||
Matrix structure of data | Excel Programming | |||
data from a sheet to a matrix | Excel Programming |