ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   vlookup or some other function that counts rows (https://www.excelbanter.com/excel-worksheet-functions/449387-vlookup-some-other-function-counts-rows.html)

rhhince[_2_]

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.


All times are GMT +1. The time now is 08:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com