•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Formula to find the exact cell a maximum value resides in
Our take
If you're struggling to pinpoint the exact cell containing the maximum value in a row, you're not alone. Many users find themselves at a standstill with formulas that don’t yield the expected results. Your current formula, while functional, may not be accurately identifying the maximum due to the way it handles blank cells. In this introduction, we’ll explore a refined approach that ensures your formula returns the correct cell reference, enhancing your data analysis and productivity.
Im trying to create a formula that returns the exact cell that the maximum value in a data set resides in, in an entire row.
Im currently using:
=ADDRESS(ROW(C6), MATCH(MAX(C6:Z6), C6:Z6, 0))
The formula is not giving me errors, however it is returning $D$6. The problem is that cell D6 is actually blank and therefore obviously does NOT contain the maximum value from data in the given range of cells.
Please help. Thank you in advance!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience