Jump to content

  •  
  • Start New Topic

Photo

MS Excel INDEX-MATCH-MIN/MAX function problems (SOLVED)


  • Please log in to reply
6 replies to this topic

#1 XenoZodiac

XenoZodiac

    Box Office Gold

  • Free Account
  • PipPipPip
  • 1,620 posts
  • Joined November 29, 2011
  • 36 topics
  • LocationFrom where I can see you... ...

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.

Edited by XenoZodiac, 12 March 2012 - 01:39 AM.


#2 CrispyLips

CrispyLips

    Victoria Concordia Crescit

  • Gold Account
  • PipPipPipPipPip
  • 12,065 posts
  • Joined November 08, 2011
  • 123 topics
  • LocationDenmark

Posted 11 March 2012 - 11:31 PM

Mine is keep saying the formula I typed is wrong.

tumblr_mkh9bhHlxN1qiu8gyo2_250.gif

"When everything seems gloomy, turn up the brightness. It's F2 on a mac."
- Rose Ellen Dix


#3 CrispyLips

CrispyLips

    Victoria Concordia Crescit

  • Gold Account
  • PipPipPipPipPip
  • 12,065 posts
  • Joined November 08, 2011
  • 123 topics
  • LocationDenmark

Posted 11 March 2012 - 11:36 PM

My excel is on Danish language, so it will be problem figuring this out.

tumblr_mkh9bhHlxN1qiu8gyo2_250.gif

"When everything seems gloomy, turn up the brightness. It's F2 on a mac."
- Rose Ellen Dix


#4 CrispyLips

CrispyLips

    Victoria Concordia Crescit

  • Gold Account
  • PipPipPipPipPip
  • 12,065 posts
  • Joined November 08, 2011
  • 123 topics
  • LocationDenmark

Posted 11 March 2012 - 11:43 PM

INDEX(array; row_num; [column_num])INDEX(reference; row_num; [column_num]; [area_num])is this the same formula?

tumblr_mkh9bhHlxN1qiu8gyo2_250.gif

"When everything seems gloomy, turn up the brightness. It's F2 on a mac."
- Rose Ellen Dix


#5 XenoZodiac

XenoZodiac

    Box Office Gold

  • Free Account
  • PipPipPip
  • 1,620 posts
  • Joined November 29, 2011
  • 36 topics
  • LocationFrom where I can see you... ...

Posted 11 March 2012 - 11:55 PM

INDEX(array; row_num; [column_num])INDEX(reference; row_num; [column_num]; [area_num])is this the same formula?

Don't think so. I'll check.

#6 XenoZodiac

XenoZodiac

    Box Office Gold

  • Free Account
  • PipPipPip
  • 1,620 posts
  • Joined November 29, 2011
  • 36 topics
  • LocationFrom where I can see you... ...

Posted 12 March 2012 - 12:03 AM

INDEX(array; row_num; [column_num])INDEX(reference; row_num; [column_num]; [area_num])is this the same formula?

Reference is a list arrays/areas.

#7 XenoZodiac

XenoZodiac

    Box Office Gold

  • Free Account
  • PipPipPip
  • 1,620 posts
  • Joined November 29, 2011
  • 36 topics
  • LocationFrom where I can see you... ...

Posted 12 March 2012 - 01:30 AM

Got the solution. =MATCH(value, array, match_type )http://office.micros...P005209168.aspxThe match_type must sorted in different orders for different values, only exception is 0.


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users