How to calculate a Column average excluding some cells???

[SebastianColombia]

First of all, good morning/afternoon/evening:

Im having a difficult time with this, basically I will show you with an example what I am trying to do: Let´s say I have to columns: Column "A" with numeric data and column "B" where Im going to calculate the column average, excluding the matching row.

ColumnA ColumnB
2 6 (6 would the the column "A"´s average excluding 2, because it is in the same row)
4 5,3 (5,3 would the the column "A"´s average excluding 4, because it is in the same row)
6 4,6 (4,6 would the the column "A"´s average excluding 6, because it is in the same row)
8 4 (4 would the the column "A"´s average excluding 8, because it is in the same row)

Is it clear what Im trying to achieve. I have hundreds of thousands of data, so I would be exhausting to do it manually. I would really appreciate if you could help me!!!!.

Thank you very much!!

 

[mrmmickle1]

Why don't you just insert a few helper columns. You can use a formula similar to this

=MID(A1,2, 99)

in order to string out the all numbers but the first one....then use another formula to string out other numbers....continue the same process for x amount of numbers etc.... Then you can calculate the average from the new columns

 

[SebastianColombia]

Why don't you just insert a few helper columns. You can use a formula similar to this

=MID(A1,2, 99)

in order to string out the all numbers but the first one....then use another formula to string out other numbers....continue the same process for x amount of numbers etc.... Then you can calculate the average from the new columns

mrmmickle1 thanks for answering!!! I can tell that something happened with the spaces in my example!! What Im trying to do is getting the entire column average, without taking the cell in front, so that I can drag down the formula and calculate the total column average excluding the matching rows.....I dont know if it´s clear what Im trying to do

Thanks for answering!

 

[Marcelo Branco]

Maybe

B1
=(SUM(A:A)-A1)/(COUNT(A:A)-1)

copy down

M.

 

[SebastianColombia]

It worked perfectly!!!!!!!

Sir thank you very much!!! You just saved my life!!!!!!!!

I'm very grateful.

 

[Marcelo Branco]

It worked perfectly!!!!!!!

Sir thank you very much!!! You just saved my life!!!!!!!!

I'm very grateful.

You are welcome and thanks for the feedback.

M.