i have a range of data (points on a 10 X 10 grid) that i need to read
into a cell...

i posted a thread a bit ago but was unclear as to what it is I actually
need help with

my range of data consists of 2 cloumns by 10 rows (10 data points)

example

_x__y_
2 3
1 2
3 5
4 5
.. .
.. .
.. .
.. .
7 7

the target cell will be a basic count program that counts how many of
the 10 data points are within a certain distance from the target cell

my thoughts are

(target cell - origin of 10 X 10 grid)

i = 1 (1st out of 10 data points)
count = 0
if distance from target cell to data point (i=1) <= radius then, count
= count +1, else count = count
next i (until 10 data points are all read)

my programming is very rusty but i am trying to get a count of how many
of the ten data points (i= 1 thru 10) are within the specified distance
from the target cell (target cells are grid points)

for example if 4 of the 10 data points are within a certain distance,
the target cell should display "4"

any help would be greatly appreciated


--
brya6347
------------------------------------------------------------------------
brya6347's Profile: http://www.excelforum.com/member.php...o&userid=20024
View this thread: http://www.excelforum.com/showthread...hreadid=346120