center of area

  • Thread starter Thread starter Gerhard
  • Start date Start date
G

Gerhard

Hello together,
I'd like to calculate the centre of area of an (non-math-functional)
excel-data-row.

Is there a simple possibility?

Thanks and greetings
Gerhard
 
If row 16 has six entries: a,b,c,d,e,f
Then =INDEX(16:16,COUNTA(16:16)/2) returns "c"
best wsihes
 
Hello Bernard,

For example the Data looks like
"B8" = 171
"B9" = "178"
"B10" = 150"
....
"B108" = "90"

The x-axis is in column A from
A8 = "380"
to
A108 = "850"
and is equdistant

If its an advantage the data could start in column A, and the x-axis is in
B...

Thanks for your answer and greetings...

Gerhard



If its an advantage the data could start in column A!
 
The mid-point of the B data is =(B8-B108)/2
Alternatively, try =(MAX(B:B)-MIN(B:B))/2
best wishes
 
Hello again,
sorry, I think I described the problem improberly!
(My english is quite out of practice...)
I'd like to calculate the "center of gravity" of the area.

Sorry for the missunderstanding

Gerhard
 
Please give us a real example of the data and the expected result
best wishes
 
Hello Bernard,

an example for an easy triangle is:

x-Coord y-Coord
A1 = "550" B1 = "10"
A2 = "580" B1 = "60"
A3 = "610" B1 = "10"

The result should be x="580", y = "26,666".

An other triangle:

x-Coord y-Coord
A1 = "550" B1 = "10"
A2 = "570" B1 = "40"
A3 = "600" B1 = "20"

The result should be x="573,333", y = "23,333".

I hope this examples are helpful,

regards
Gerhard
 
Back
Top