| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| average daily counts to weekly counts | Excel Discussion (Misc queries) | |||
| Looking for a Function which counts the repeatition of text in a column | Excel Worksheet Functions | |||
| Average Function that Counts | Excel Worksheet Functions | |||
| Macro that counts rows and averages data in row | Excel Programming | |||
| counts rows in data | Excel Programming | |||
![rhhince[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
