| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to find the last number in a series
Hello,
I have the following list of number and need to find the last number that starts with 1006? How do I do that? Also if I search for numbers beginning with 1008 I need to know that there is none present. 1005001 1005002 1006001 1006002 1006003 1007001 1007002 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find a number within data by formula | Excel Worksheet Functions | |||
| find a number within data by formula | Excel Worksheet Functions | |||
| countif formula to find the occurances of a number that is greater than one number but less than another | Excel Discussion (Misc queries) | |||
| how can we find out any missed number in a series? | Excel Discussion (Misc queries) | |||
| how we can find out any missed number in a series? | Excel Discussion (Misc queries) | |||
Threaded Mode
