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