Range Matrix
Hi all,
I am looking to display the following data into a matrix. Does anyone know how I can achieve this by formula or an Excel function.
DATA
A....50
B....150
C....60
D....200
MATRIX (count of data)
.........0......100......200
0.......X.........2........4
100....X.........0........2
200....X.........X........1
Cheers in advance
GarToms
|