Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Compare Results in an Array

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Winnipeg, Manitoba, CANADA
    Posts
    144
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have to compare the values of an array with a another value. How do you add items to an array using VBA Code? For example:

    Col A = Start #
    Col B = End #

    Cell A1 = 100, B1 = 200
    Nothing in Row 2
    Cell A3 = 300, B3 = 400
    Cell A4 = 500, B4 = 600
    etc....

    Now I want to compare each Start # and End # with my Start # and End #. Any Help would be fabulous!
    Thanx.

  2. #2
    MrExcel MVP Damon Ostrander's Avatar
    Join Date
    Feb 2002
    Location
    Denver, Colorado USA
    Posts
    4,239
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Robert,

    I don't understand your question, so maybe others are confused as well. Can you provide some clarification?

    In particular, your question subject line refers to adding values to an array, but your problem never refers to either "adding" or to an "array". In your example you show a set of start/end times, but these appear to be in cells and not the result of an Excel Array formula, so are you just using the term "array" in a very general sense?

    Damon

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Winnipeg, Manitoba, CANADA
    Posts
    144
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    It's OK, I got around the task. Thanks anyways.

    All I wanted to do was put a range in an array so that I could loop through each individual number to compare against my number.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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