All.

I am trying to write the following function

=LARGE(ABS($C$1:$H$1-H4),6)

The "formula builder" window is returning the correct result however the cell is returning #value

can anyone help with what I am trying to do?

Basically i am testing a large amount of data against a set array. In every case I want the difference in each cell of my data tested against each of the six cells in the set array, and the lowest value returned.