D dchatrie New Member Aug 21, 2012 #1 I would like a formulae that would return the text associated with a maxiumum value in a table.
M mercatog New Member Aug 21, 2012 #3 If you have numbers in B2:B100 and text in A2:A100 Try this formula =INDEX($A$2:$A$100,MATCH(MAX($B$2:$B$100),$B$2:$B$100,0)) It'll return the texte whome has the maximum value in column B
If you have numbers in B2:B100 and text in A2:A100 Try this formula =INDEX($A$2:$A$100,MATCH(MAX($B$2:$B$100),$B$2:$B$100,0)) It'll return the texte whome has the maximum value in column B
