| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding first occurence of a number
In col F cell 2, I have a number that is ten characters long, and this number
could remain the same for up to 20 or 30 rows with additional information on either side of this number, but then this number will change to a different number (number will always be ten characters long) for up to the same 20 or 30 rows, this format will continue for about another 200 rows or so. So what I am needing is a formula that will locate the first occurence of this number, so that I can then access the remaining portion of this information. Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract single occurence of order number from list | Excel Worksheet Functions | |||
| Assign a number each letter on list compounding occurence @ each e | Excel Worksheet Functions | |||
| Finding how many events since last occurence in a database list | Excel Worksheet Functions | |||
| Finding most common occurence of values in cells containing letters and numbers | Excel Worksheet Functions | |||
| finding a number and the number of times it occurs | Excel Discussion (Misc queries) | |||
Threaded Mode
