Can you unsubscribe me from this group, please?
Tks.
2013/9/23 Debasish Sahu
> Can somebody help me calculating euclidean distance for the attached
> sample file.
>
> Column 2, 3 & 4 contains X, Y &Z information of samples for which the
> euclidean distance is required to be calculated.
>
>
Thanks Mr. ravinder,
But I dont think it is that simple.You have provided the correct formula.
ButI have to calculate the euclidean distance for each sample against all
samples(e.g sample 1 with all other samples, sample 2 with all other
samples, etc)
So there will be huge no. of calculation
I don’t know more about this. U can use like below;
=SQRT((x2 – x1)^2 + (y2 – y1)^2 + (z2 – z1)^2)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Debasish Sahu
Sent: Monday, September 23, 2013 6:36 PM
To: excel-macros@googlegroups.com
Subject: $$
