Checking a number of measurements against constantly changing high and low tolerences.

Ishcor

New Member
Joined
Feb 24, 2019
Messages
1
In my work I take around 100 different measurements. Each measurement has it's own spec for high and low tolerance. For example measurement #1 can be between 0 and 1. Measurement #4 could be between 0 and 1.5 and so on. I use conditional formatting to highlight the measurements that are out of spec, but then I have to manually count each highlighted cell to give an overall report. I'm wondering it I could automate the process to give me a total count of each out of spec measurement. I'm wondering if anyone has suggestions on how I can do that. I have an example below on how the spreadsheet is organized. Keep in mind that I can't reorganize any of the measurements and this is only a small example of the 100 measurements that are done.


Measurement number

#1
#2
#3
#4
#5
#6
#7
#8
High tolerance1111.53.5121
Low tolerance0.10.10.100000
Reading0.50.21.1
0.13.11
1.50.5Count out of spec1

<colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:3108;width:64pt" width="85"> <col style="width:48pt" width="64" span="14"> </colgroup><tbody>
</tbody>
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

JoeMo

MrExcel MVP
Joined
May 26, 2009
Messages
17,193
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Excel Workbook
ABCDEFGHIJ
1Measurement number#1#2#3#4#5#6#7#8Out of Spec
2High tolerance1111.53.5121
3Low tolerance0.10.10.100000
4
5Reading10.50.21.10.13.111.50.51
6Reading20.30.050.803.71.21.91.34
Sheet1
 

Watch MrExcel Video

Forum statistics

Threads
1,108,630
Messages
5,523,991
Members
409,554
Latest member
denistrevisan

This Week's Hot Topics

Top