I know how to find the maximum value in a table, but I don't know how to figure out how much larger it is than the 2nd biggest number.
1
2
5
7
9
3
4
It's easy enough to find the "9". What's more difficult is to know that it's 2 point higher than the 2nd biggest number in the table. I need to do a series of calculations like this on grouped numbers and in each case know how much larger the max number is than the 2nd highest number in the group.
Any good ideas?
Thanks
Wayne