Quote Originally Posted by DonkeyOte View Post
Not very clear... you're populating a matrix of 750x750 using formulae ?

A1: =COLUMNS($A1:A1)-1&","&ROWS(A$1:A1)-1
applied to A1:ABV750

might take a little while to calculate the 500k+ cells

It might be better to store row values (0-749) in say A2:A751 and Column Values (0-749) in B1:ABW1 then:

B2: =B$1&","&$A2
applied to matrix B2:ABW751 - avoids repetitive calcs.
Well really all I want to do is make up this matrix with those titles in each cell. No calculating is going to take place. I will be entering data individually in each cell. If you like it will be like a map.with each cell holding an address . in the form xxx,xxx
Thanks you Donkeyote for your remarks.