Thread: Number Matrix

Originally Posted by toughTerry

I have a matrix table

---------------------------------------------
      A       B      C        D

A     1

B    0.1      1

C    0.2      0.6    1 

D    0.8      0.3    0.9      1

I would like to output a table for the cell value > 0.5 and < 1 and the result will be like this

Col    Row    Value
B       C       0.6
A       D       0.8
C       D       0.9

A formula for this would be a bear. It's also unclear how/where this matrix lies on your sheet or the resulting output table.

Please upload a sample workbook demonstrating exactly where this data is found and where your results would appears and look. I imagine VBA would be simplest way to handle this.