That seems like that will work, lets say I have 2 colums of numbers:
X and Y
2 6
3 8
3 5
5 4
reference 9 and 4
and I want excel to use a fixed user input for the B7 and C7 and hav
the program step through the displayed X and Y numbers
example:
=SQRT((2-9)^2+(6-4)^2)
=SQRT((3-9)^2+(8-4)^2)
and so on.
I need excell to step through each number.
Thanks in advanc
--
Message posted from
http://www.ExcelForum.com