Maximum values in 3 by 3 window

[PIDIT]

Dear all,

I have to calculate slope for a central cell from 8 neighboring cells. As a result I want to know in which direction central cell has maximum slope.

For example: 1 2 3
4 X 5
6 7 8

Slope calculation for X cell: 2,4,5,7 (A)= (X-A)/0.5
1,3,6,8 (B)= (X-B)/(0.5*sqrt(2))

I don't want the maximum slope value rather I need need maximum slope direction.

Thank you

 

[jasonb75]

Answered in duplicate thread http://www.mrexcel.com/forum/showthread.php?t=571295