R
rhhince
D E F G
111 0.8189
112
113 0.8311 0.8270 0.8306
114 0.8333 0.8248 0.8252
115 0.8276 0.8080 0.8090
Here is the illustration. Cell G112 is suppose to give me number of rows ittook to find the number of cell F111 that fits in between column D and E in the row starting from row 113. The answer would be 3 by manually counting.. Trying to put that in an equation. I am a not well versed in excel but trying. Can anyone help? Thanx.
111 0.8189
112
113 0.8311 0.8270 0.8306
114 0.8333 0.8248 0.8252
115 0.8276 0.8080 0.8090
Here is the illustration. Cell G112 is suppose to give me number of rows ittook to find the number of cell F111 that fits in between column D and E in the row starting from row 113. The answer would be 3 by manually counting.. Trying to put that in an equation. I am a not well versed in excel but trying. Can anyone help? Thanx.