I have a data range called "Recordings" with the following data source:
=Cover!$BL$76:$BL$80,Cover!$BN$76:$BN$80,Cover!$BP$76:$BP$80,Cover!$BR$76:$BR$80,Cover!$BT$76:$BT$80
I am able to display the maximum value in Recordings by using the formula =MAX(Noise) However, I would also like to display the corresponding value in Column A of the max value. What formula do I use please?
Also, how will this formula deal with 2 identical max value? Will it display Column A value of the the first max value it finds?
Bookmarks