leal72
01-08-2010, 09:29 AM
I'm trying to find a function to use rather than using a loop, or a function that maybe work like a loop.
What I need to do is go through column B and find the first instance that is equal to ro greater than the number in cell H2.
I was able to do this using a loop but the end user would like it to be more flexible. I may just have set it so the user could just run the loop again if and when the value of H2 gets changed but I'm looking for a possible alternative.
What I need to do is go through column B and find the first instance that is equal to ro greater than the number in cell H2.
I was able to do this using a loop but the end user would like it to be more flexible. I may just have set it so the user could just run the loop again if and when the value of H2 gets changed but I'm looking for a possible alternative.