im using this formula =INDEX($I$5:$I$500,SMALL(IF($K$5:$K$500=MAX($K$5:$K$500),ROW($K$5:$K$500)-1),ROW(K5)-1)) but it wont work i got the formula from a web page i just change "A" to "I" and "B" to "K"
i5:i500 is won lost drew (thats the only 3 words) - K5:k500 is numbers its an array formula
im trying to find the max num and give the corresponding word
it gives me the result #NUM!
instead of either won lost or drew
if need be can i upload a pic of the original formula ?
Bookmarks