+ Reply to Thread
Results 1 to 2 of 2

know the address of the two cell, how to create the array between them

Hybrid View

  1. #1
    Registered User
    Join Date
    05-24-2012
    Location
    china
    MS-Off Ver
    Excel 2003
    Posts
    2

    know the address of the two cell, how to create the array between them

    Hi, I am a newbie here and i am looking for a simple function to do below

    a list a data is in column A1:A999.
    using min() to find the min value. for example A20
    how to define a array from A20:A999, as I want to use Match() to search for another value.
    of cos the address of the min value is not always A20.
    is it something related to dynamic Array?

    thank you for the help.

  2. #2
    Registered User
    Join Date
    05-24-2012
    Location
    china
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: know the address of the two cell, how to create the array between them

    or saying in another way,

    one cell store one address A20
    another cell store one address A999

    how can Match() to look up array for A20:A999. thanks.

+ Reply to Thread

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