+ Reply to Thread
Results 1 to 3 of 3

3-dimensional grid search

  1. #1
    Registered User
    Join Date
    06-04-2014
    Posts
    2

    3-dimensional grid search

    Hi
    I have no idea how to get started, I've not even been able to create a 3-dimensional grid after hours of googling. Please help me?!
    Last edited by Vickevire; 02-27-2016 at 12:04 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: 3-dimensional grid search

    Is this for your job, or is this a homework assignment? We don't do your homework for you, but we can certainly help. I will say that "hours of googling" is too much--if you can't find what you need after 15-20 minutes, time to get help.

    First there is no need to create a 3D grid. It is not hard to create a 3D array in VBA but I don't think you need that here.

    "between 0,0 and 1,0" Inclusive or exclusive? If you think there are 11*11*11 combinations then I assume inclusive but I want to make sure you have thought about it.

    "search for a specific combination of three values" Where are you searching for these values? What does the data look like that you are searching? Where are you getting the three values that you are searching for? Does the order matter, or can the three values be in any order when you find them? How will you indicate to the user what you find when the values are found?

    I am thinking that the overall strategy is to use three nested For loops, which will iterate through all 1331 possible combinations and search for each one.

    "should minimize two cells with functions" I have no idea what this means. I think you should attach your file, and then tie your explanation back to what is in the file.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: 3-dimensional grid search

    One other thing that I forgot to mention is that you can get unexpected results trying to compare two floating-point numbers for equality. Two numbers may fail to match even if they look in Excel like they should be equal. This is related to how numbers are stored in computers.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 01-02-2015, 04:24 PM
  2. need help using index/match to search grid
    By tsiguy96 in forum Excel General
    Replies: 2
    Last Post: 12-11-2013, 08:33 AM
  3. Search a multiple dimensional array
    By darknation144 in forum Excel General
    Replies: 2
    Last Post: 02-21-2012, 06:05 AM
  4. Replies: 2
    Last Post: 12-15-2011, 04:14 AM
  5. Two dimensional search
    By SIFT-MS88 in forum Excel General
    Replies: 7
    Last Post: 06-16-2010, 07:04 PM
  6. Creating a 2-dimensional array from a 1-dimensional list
    By guywithcamera in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-27-2008, 06:34 PM
  7. Formula Question:search the entire grid
    By livifivil in forum Excel General
    Replies: 1
    Last Post: 04-17-2007, 02:32 PM

Tags for this Thread

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