Jump to content

Cinebrate-web-banner-728x90


  • Start New Topic
Welcome to the BoxOffice® Forums
Register 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. Please note that forum accounts are separate from BoxOffice.com subscriber accounts.
Login to Account Create an Account
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

  • Member
  • PipPipPip
  • 1,611 posts
  • Joined November 29, 2011
  • 36 topics
  • LocationFrom where I can see you... ...
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

  • Charter Member
  • PipPipPipPipPip
  • 11,970 posts
  • Joined November 08, 2011
  • 123 topics
  • LocationDenmark
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

  • Charter Member
  • PipPipPipPipPip
  • 11,970 posts
  • Joined November 08, 2011
  • 123 topics
  • LocationDenmark
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

  • Charter Member
  • PipPipPipPipPip
  • 11,970 posts
  • Joined November 08, 2011
  • 123 topics
  • LocationDenmark
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

  • Member
  • PipPipPip
  • 1,611 posts
  • Joined November 29, 2011
  • 36 topics
  • LocationFrom where I can see you... ...

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

  • Member
  • PipPipPip
  • 1,611 posts
  • Joined November 29, 2011
  • 36 topics
  • LocationFrom where I can see you... ...

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

  • Member
  • PipPipPip
  • 1,611 posts
  • Joined November 29, 2011
  • 36 topics
  • LocationFrom where I can see you... ...
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