First off Hello You!!!!

[Iexel]

Hi.

I am new here and I thank you in advance for your support. Maybe this is simple for you and you can help me. Many blessings to you if you help me.



Select the value more approximated to the mean:

How do I write the code in VBA to calculate from a list of numerical values (which I already set) which one it is more approximated to the mean?

Is there a signal to put on after If value ... mean or Is there other way to do this?


​

Thank you.

 

[northwolves]

Suppose your raw data list in A1:A7.the following formula works for you:

=MATCH(MIN(ABS(A1:A7-AVERAGE(A1:A7))),ABS(A1:A7-AVERAGE(A1:A7)),0)

Hope it helps.