Need Excel help

Reply #3

ScoobyDue — Tue, 31 Jan 2023 21:45:58 GMT

Interesting solutions guys!

Never even knew about the small() function before

Thanks

Reply #2

cottoneyedjoe — Mon, 30 Jan 2023 15:44:09 GMT

Here is one way of doing it, there are many others. I like this trick because the only functions you only need to apply are min, max, and median.

To get the second term, first add 2 copies of the min to the set. Now your new set is 1, 1, 1, 9, 14, 17, 34. Take the median of this set, which is 9.

To get the fourth term, first add 2 copies of the max to the set. Now your new set is 1, 9, 14, 17, 34, 34, 34. Take the median of this set, which is 17.

Reply #1

Raven62 — Sun, 29 Jan 2023 20:16:56 GMT

=small

Need Excel help

ScoobyDue — Sun, 29 Jan 2023 17:36:28 GMT

If I put a bunch of numbers in a wheel and it it spits out a ticket such as

9-34-14-17-1

I can use Min(), Median() and Max() to get the 1st, 3rd and last digit sorted (1-x-14-x-34)

but does anyone know of a way to get the 2nd 4th digit in place using a different function