Difference from Top Rated Value in a Range

[paulfitz320]

Book3
	A	B
1	Rating	Wanted
2	89	-2
3	87	2
4	87	2
5	86	3
6	81	8
7	76	13
8	75	14
9	73	16
10	66	23
11	61	28
Sheet1

Hi,
Would appreciate a formula for the 'Wanted' column please.
It needs to return the difference between the Top Rated and Adjacent Value in the 'Rating' column.
Also the value calculated for the Highest Rated should be the difference between the Highest Rated and Second Highest Rated then converted to a minus value. Here 89 is 2 more than the next highest value in the range 87 so gets a -2
Thanks.

 

[paulfitz320]

Thanks very much, dreid. Your a star!

 

[dreid1011]

Thanks very much, dreid. Your a star!

You're welcome, and happy to help.