3-dimensional grid search

[Vickevire]

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?!

[6StringJazzer]

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.

[6StringJazzer]

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.