| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Row position of specified column and value
I would like to know the row position of a specified column and value in a
table. If multiple occurences of the specified value occur in a particular column, I want the bottom most row position returned. For example, in the folowing table, the function would specify column 2 (or B), value of 6, and return 3 since the bottom most 6 in column 2 is row 3. A B C 1 5 8 2 6 9 3 6 10 4 7 11 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find value in column, return value in same position of other colum | Excel Worksheet Functions | |||
| How insert a dash in the third position of a column with data? | Excel Discussion (Misc queries) | |||
| function for Column Position | Excel Discussion (Misc queries) | |||
| Finding Column Position | Excel Discussion (Misc queries) | |||
| Select player from list and get his position in next column | Excel Discussion (Misc queries) | |||
Threaded Mode
