hi guys do you know how to average a column but dont include the datas duplicate in averaging,, sample below
<tbody>
</tbody>
i want to averagethe column above but only the 1,2,3,4,5,6 not the 1,2,2,3,3,4,4,5,5,6..can you give me the formula thanks
1 |
2 |
2 |
3 |
3 |
4 |
4 |
5 |
5 |
6 |
<tbody>
</tbody>
i want to averagethe column above but only the 1,2,3,4,5,6 not the 1,2,2,3,3,4,4,5,5,6..can you give me the formula thanks