How to create an array of outliers from a data set?

Hi InnovationTT. Welcome to the forum.

Please try testing this. You may have to array enter depending upon what you intend to do with it. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Formula:

Please Login or Register  to view this content.

Originally Posted by InnovationTT

But that's a boolean expression right? so it will always return true or false right? I need the actual numbers that are outliers. For example if the data set is {-2999, 3, 6, 10, 23999} then I want to create a formula that will create an array with {-2999, 23999}.

Not quite. Using that dataset with the appropriate 'fences', FlameRetired's solution would return the array

{-2999;FALSE;FALSE;FALSE;23999}

That can of course be reduced to an array comprising the two non-Booleans only, though whether this is necessary largely depends upon what you intend to do with the array next.

Regards

Please note that this and in fact most forums require you to disclose where else you have asked the same question. I am providing a link for you this time - please ensure that you comply with our very simple rules yourself in future. Thanks!

https://www.mrexcel.com/forum/excel-...-data-set.html