•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
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]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#AI formula generation techniques
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#row zero
#real-time data collaboration
#intelligent data visualization
#rows.com
#Excel compatibility
#maximum value
#data set
#formula
#exact cell
#ADDRESS
#ROW
#MATCH
#C6:Z6
#find
#data