Finding the smallest difference between a range of cells? Array formula?

Hey guys,

I have been trying to mess around with the array formula on this site
http://www.get-digital-help.com/2007...losest-values/
to be able to find the smallest difference of a range of cells, but I can't make it work
This is the first time I'm using array formulas and having a Swedish version of Excel isn't really helping

The thing is that I would like to find the smallest differences between a range of cells and - in best case - use conditional formatting to color the cells where the difference <8 red.
I attach an example file of how the input file could look.
numbers.xlsx

Hi,

I edited the workbook a bit so the result would be more realistic. Also I added some explaining text, but will write it here too

The purpose is to collect all data in a given range of cells (range can contain empty cells which needs to be excluded).
These values is to be sorted in ascending order and then compared for the smallest difference by making one list containing all values except the lowest value MINUS one list containing all values except the highest one.
As far as I understood the formula on the page I linked to in my first post, that's what it does - but with a single column (A1:A10) and the output in a single cell (the smallest difference).

numbers.xlsx

Ah, thanks! Then I'm a bit closer than I were just a couple of minutes ago

Try this in AC1 , then drag down

Please Login or Register  to view this content.

Wow, thanks. This is awesome!

If only minimum difference is required,

Please Login or Register  to view this content.