Edited by XenoZodiac, 12 March 2012 - 01:39 AM.
Welcome to The Box Office Theory — ForumsRegister now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. This message will be removed once you have signed in.
Login to Account Create an Account
MS Excel INDEX-MATCH-MIN/MAX function problems (SOLVED)
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.