Edited by XenoZodiac, 12 March 2012 - 01:39 AM.
MS Excel INDEX-MATCH-MIN/MAX function problems (SOLVED)
6 replies to this topic
Posted 10 March 2012 - 09:48 AM
I am having this weird problem with excel. I am trying to use index-match function to input the highest scoring and lowest scoring players but for some reason excel is making mistakes. I am sure I have the formula correct.Its here:=INDEX(A2:A21, MATCH(MAX(C2:C21), A2:A21))In some cells instead of showing the correct names, its showing other names and in a few cases it shows #N/A which means MATCH found more than 1 highest/lowest scores when infact that's not the case. Also, when I sort the table in a different way (keeping the data unaltered) it shows different results.I think its having problems with the MATCH function. Excel says so when I go to "show calculation steps".Got any clue?Thanks in advance.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users