Nest function into array of LARGEST function

[alex2011]

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.

[Colin Legg]

Welcome to the forum, Alex.

When you type the formula into the formula bar, you need to finish the entry with CTRL+SHIFT+ENTER, not just the usual ENTER. If done correctly, Excel will automatically surround the formula with curly braces { }.

[alex2011]

Thanks.

That worked. Fantastic!!!