Results 1 to 5 of 5

Finding location of largest value in a list using Match.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2016
    Posts
    2,712

    Finding location of largest value in a list using Match.

    Hi, consider the enclosed file.

    I am using the match function to find the largest number in a list (column). However, its not working correctly. Well, i should say i am doing something wrong.

    Please, note: I am sure there is another way to do this........but i am trying to understand why this is not working as i thought it should. From what i know about this function the value returned should be 26 but instead its 28.......any ideas?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1