I need to know how to find out the 'coordinates' of calculated values in a 'custom' coordinate system. I found an equation to find the 1st highest number in a set of data and I would like a formula/macro/etc to also give the corresponding coordinates of the 'axes' of the table. (Numbers 1 through 80 as shown in the picture)
Any thoughts?
http://img16.imageshack.us/my.php?im...lculateoz9.jpg
Bookmarks