rhino4eva
Active Member
- Joined
- Apr 1, 2009
- Messages
- 262
- Office Version
- 2010
- Platform
- Windows
So once again i turn to you guys to join the dots
I know what i need to do but don't know how to get there
In my lab we use 7 digit number for the specimens The number of which can vary for 3 to 96
i need to able to calculate the avg ,standard dev and CV (result)
for just the lab numbers, I'm not bothered about the controls at the bottom
i know i need a dynamic range but how do i just include the results of 7 digit lab number and ignore anything alpha
I know what i need to do but don't know how to get there
In my lab we use 7 digit number for the specimens The number of which can vary for 3 to 96
i need to able to calculate the avg ,standard dev and CV (result)
for just the lab numbers, I'm not bothered about the controls at the bottom
i know i need a dynamic range but how do i just include the results of 7 digit lab number and ignore anything alpha
| labnumber | result |
| 12345467 | 1.2 |
| 2345678 | 1.5 |
| 3456789 | 1.1 |
| pos | 4.5 |
| neg | 1 |
