This formula is used by a former coworker of mine to perform cluster analysis:

`{=SQRT(SUM((\$C3:\$F3-\$C\$11:\$F\$11)^2))} . `

He has no idea why it functions. Its purpose is to determine the separation between a few points. I only get one result when I run the equation without the. I get another when I run it with it.

Normal distance formula: A2 + B2 = C2. I'm assuming this applies to several points in a row. Is this essentially performing each point in each row?

Oct 9, 2022 in Others 1,294 views

## 1 answer to this question.

Euclidean Norm of a vector of size 'n' = SQRT(SUMSQ(A1:An))

The SUMSQ function is useful to calculate the Euclidean norm in Excel.
• 63,700 points

## Formula for inserting a thumbnail picture into excel cell, based on another cell's value

Here is a really excellent tutorial on ...READ MORE

## In MS Excel what formula can be used to calculate growth when CAGR for the period is already given?

If those are true CAGR's, then just ...READ MORE

## Excel: Formula for compound interest for monthly deposits where deposits increase every year

It's possible that I don't understand how ...READ MORE

## Hiding the formula bar in Excel for a specific file

No, you cannot. Unfortunately, altering the CustomUI file ...READ MORE

## Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

Forget the PsychoPy complications for the time ...READ MORE

## In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

## Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE