Results 1 to 3 of 3

Index, Mode & Match Problem?

Threaded View

  1. #1
    Registered User
    Join Date
    06-30-2008
    Location
    Ireland
    Posts
    34

    Exclamation Index, Mode & Match Problem?

    I have a column of text values which the below formula is evaluating and is then returning the most frequent text value.

    =INDEX(A:A,MODE(MATCH(A:A&"",A:A&"",0)))

    It works fine when the specified array includes text values, my problem is i am adding to the text values daily and would prefer not to have to adjust the array of the formula each time!

    When i specify a larger array (ie. A3:A1000) it returns "0".

    Is there any way to combat this?


    Thanks in advance
    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