I'm using a simple Euclidian distance formula
sqrt((a-b)^2 + (c-d)^2) and I have more than 60,000 data in my each excel sheet. Instead of dragging mouse (which is very inconvenient for this large number of data) how can I define the range of records? For example my formula looks like -
And also, to popolate the result in 60000 rows, where should I write the formula?