Thread: Range Matrix
View Single Post
  #1   Report Post  
GarToms GarToms is offline
Member
 
Posts: 33
Default 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