Finding a "range"

[Macro-wave]

Can anyone help me find a range? Not a range of cells, but a range as in a plus or minus 2 or +/-3 given a group of numbers.

[ChemistB]

Not sure what you are asking. I'll just throw some stuff out there....
Let's say your numbers are in A1:A100.

The largest and smallest numbers

Please Login or Register  to view this content.

Average and median;

Please Login or Register  to view this content.

You can take any of those functions and add or subtract to it;

Please Login or Register  to view this content.

Did any of this help?

ChemistB

[Macro-wave]

Not really. To be more specific, I am trying to find if a range of numbers matches the criteria "16 +/-3". I want to do this using a single formula

Not sure what you are asking. I'll just throw some stuff out there....
Let's say your numbers are in A1:A100.

The largest and smallest numbers

Please Login or Register  to view this content.

Average and median;

Please Login or Register  to view this content.

You can take any of those functions and add or subtract to it;

Please Login or Register  to view this content.

Did any of this help?

ChemistB

[ChemistB]

Okay, next we need to define what you want to do when you "find" this range.

We could have Excel change the color of the cell of font.

We could hide all rows that do not have a value in that range.

We could do calculations on those numbers (e.g average or Sum).

Other?

ChemistB

[Macro-wave]

I figured it out. What i was doing was calculating tolerances.

This is the formula I used:

{=MAX(MAX(IF(ThicknessRollandPly=CONCATENATE(D$3,"-",$C14),Thickness,""))-16,16-MIN(IF(ThicknessRollandPly=CONCATENATE(D$3,"-",$C14),Thickness,"")))}

The names are ranges I named in the worksheet.

Thanks for the help though.