Hi every one ,

Does anyone help with the vba code to find the middle number in array ?

attachment is an example , :

- if there are 2 number in the midlle then chose the smaller one ( see sample group B or C)
- If group has only 1 data point then chose that data ( See group D)
- If there is one middle number then take that number ( see group A)

Thanks in advance ,

-m