Calculate how many spots within 100 metres in the same column

[adityo_reksopra]

Hi,

i need function like this, for example i have one data of location

when enter the second data, it calculates the distance between first data and second data, if it returns <100 M, it gives remarks "the distance < 100 m" for the second data

and then when enter the third data data, it check between 1st data and third data, is it < 100?

and also, it check between the second data and third data, is it < 100?

if any of them < 100, it return remarks "the distance < 100 m" in the third data,

and so the next data