// Which Column Contains Number Closest To Average?
=INDEX(A$2:D$2,MATCH(MIN(ABS(A3:D3-AVERAGE(A3:D3))),ABS(A3:D3-AVERAGE(A3:D3)),0))
// This is an array formula.
// An array formula is bounded by curly braces "{ }" which can't be simply entered manually. Instead, commit an array formula thus:
// CTRL+Shift+Enter (PC)
// CMND+Shift+Enter (Mac)
What this formula does:
1. Evaluates a row of numbers.
2. Identifies the number closest to row average.
3. Returns that number's column header.
View Excel table and formula here: http://1drv.ms/1OkNlgk
- Click on the "closest-to-average" sheet.
1. Evaluates a row of numbers.
2. Identifies the number closest to row average.
3. Returns that number's column header.
View Excel table and formula here: http://1drv.ms/1OkNlgk
- Click on the "closest-to-average" sheet.
Be the first to comment
You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.