Good afternoon...

I am looking for a formula that will calculate the difference between consecutive values of random values within a range. I have a range of 10 values
(j2:j11) and they are in random order this order can change randomly. I need to subtract ranked (ordered) value 9 from ranked value 10, 8 from 9, 7
from 8, etc. (and return negative values - see desired outcome)

Range Desired Descending
Value Outcome Rank
3271 -400 9
3735 -85 7
4217 -38 2
3270 -1 10
4255 4255 1
3671 -64 8
4158 -59 3
3859 -115 5
3974 -184 4
3820 -39 6

I have used =max, =count and =rank commands - yet I am not getting my anticipated outcome.

Any help would be appreciated. TIA

Bravejoe

"There's fodder for the cannons and the guilty ones can all sleep safely." Andy Partridge XTC
"That's my opinion. I could be wrong." Dennis Miller
"It Doesn't Matter!" Bravejoe

remove the "t1","us" from my email address to reply privately.