Quote Originally Posted by John Bates View Post
How would I dynamically find all the values in a given column and then correlate those with the same rows in column I?
Don't quite understand this part of it. What exactly are you looking to do? As for the formula to get dynamic ranges, for column C, it would be =C11:INDEX(C:C,MATCH(9.99999999999999E+307,C:C)), for example. You should be able to either used this as a named range or plug it in anywhere you already have a range for C11:C1000 or C11:C375.