gmcgough600
New Member
- Joined
- Nov 21, 2017
- Messages
- 32
In the table below the first column is my data, the second and third are what I want. Any ideas how to do this would be really appreciated. Basically I want to find consecutive blocks of 4 or more numbers within the #N/As and copy these. I then want to use TRIMMEAN on each block to trim 50% (calculate mean excluding 50% of the points) and put the result somewhere e.g. in the first cell of each block.
<tbody>
</tbody>
What I have | What I want a formula to do (step 1) | What I want a formula to do (step 2) |
#N/A | #N/A | #N/A |
#N/A | #N/A | #N/A |
#N/A | #N/A | #N/A |
#N/A | #N/A | #N/A |
1 | 1 | 2.5 |
2 | 2 | #N/A |
3 | 3 | #N/A |
4 | 4 | #N/A |
#N/A | #N/A | #N/A |
#N/A | #N/A | #N/A |
1 | #N/A | #N/A |
1 | #N/A | #N/A |
#N/A | #N/A | #N/A |
6 | 6 | 6 |
6 | 6 | #N/A |
6 | 6 | #N/A |
5 | 5 | #N/A |
#N/A | #N/A | #N/A |
<tbody>
</tbody>