Formula to calculate the Unusal number in a range

[sergiom920]

Guys, I have a range of Numbers and i would like to get a formula to look at the range and give me the "ODD" or "Unusual" number in the range. In this case it would reference the cell for 90.

Jan Feb Mar Apr May Jun Jul
10 20 15 22 90 29 16

Please advise

 

[mortgageman]

You need to define unusual or odd here. If 90 is unusual because it is too large, then the max function would work. But is "largeness" the only type of "oddness" you can get?

Gene, "The Mortgage Man", Klein

 

[sergiom920]

Yes unusual would be a number that is probably greater than the average of the whole set..

So if i have a trend 10 15 20 14 25 100, then 100 would be the Unusual number. Also i would like to be able to get more than one number if possible..

so if i had 10, 15, 20, 30, 100, 20, 200, i would be able to retrieve both 100, and 200 because they fall outside the pattern

 

[mortgageman]

I can see some difficulties with excludling any number greater than the average. If all you want to do is exclude those that are really bigger than the rest of list, then use the function large. =large(range,1) will return the biggest number in the range (IOW it will return the same number as =max(range)). =large(range,2) will return the 2nd largest number in the range, etc.

Gene, "The Mortgage Man", Klein