Application of array or fetch functions based on number ranking

[a703]

Please have a look at the data flow. Need to use excel functions like match and index (not sure) to get the data in the FINAL VALUES row but dont know how to. Need coding in cells A10:C10. This is a derivation of my earlier thread along the same lines. Excel sheet attached for reference.

600	-100		800	-500		original
600	100		800	500		absolute values
4	2		5	3		rankings
						"0" not ranked i.e. ranked as 0.
						lowest rank is 2.
						highest rank is the count of numbers - here 5th
600			700	-500		FINAL VALUES
						"0" values to be ignored.
						value of 2nd rank (-100) = 0
						value of 5th rank (800) = net value of 2nd and 5th rank
						Rest of values to be kept the same
						Conditions :
						value of highest and lowest rank to be different.
						If > 1 case of same rank, the first value to be considered.