View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rhhince[_2_] rhhince[_2_] is offline
external usenet poster
 
Posts: 48
Default vlookup or some other function that counts rows

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 it took 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.