| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I obtain position of specific value in a row of numbers
I have a row of 10 binary values in a row (column a to J for example). an
example follows: 0010011000 I need a formula that will return the position (numerically) of the first "1" and another that will give the position of the last "1". for the above, the formulas would return 3 and 7 respectively. Can anyone advise? anand |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding numbers from a list over a specific value | Excel Discussion (Misc queries) | |||
| Replacing specific numbers | Excel Discussion (Misc queries) | |||
| Select specific numbers from a list based on position | Excel Discussion (Misc queries) | |||
| Replacing a specific position in a cell with something else | Excel Discussion (Misc queries) | |||
| How do I format a cell so that only specific numbers can be enter. | Excel Discussion (Misc queries) | |||
Threaded Mode
