Finding a Value Based on the Closest Average

An Excel file that teaches how to perform Finding a Value Based on the Closest Average operation.

Excel Professional Finding A Value Based On the Closest Average

The average calculation is performed dynamically. The difference is measured using the absolute value formula. The record with the lowest difference is found. Conditional formatting highlights the difference. The result is printed to the table.

Hope it is useful.