How to use the ABS function

Converts negative numbers to positive numbers, in other words, the ABS function removes the sign. Excel Function Syntax ABS(number) Arguments […]

Find numbers closest to sum

Excelxor is such a great website for inspiration, I am really impressed by this post Which numbers add up to […]

Highlight closest number

This post decribes how to highlight records with closest value to a criterion. You can also choose to highlight the […]

Lookup the nearest date

Array formula in E3: =INDEX(A1:A10, MATCH(MIN(ABS(A1:A10-$E$1)), ABS(A1:A10-$E$1), 0)) Recommended articles: How to enter an array formula Select cell E3 Type […]

Find closest value

Table of Contents Find closest value Find closest values Find closest values and return adjacent values Find closest value with […]