Hi, i have a list of numbers in excel, i want to find the two that are the closet to each other.

For example if the list was 2, 4, 9, 152, 153, 234, 324, 521

the closet numbers would be 152 and 153 and the difference between them would be 1 (smallest difference of any combinantion of two of the numbers).


Is there a function to do this? if not is there any other way to do this?

Hope this is clear.

Thanks you in advance.