| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
figuring out the next number in a series
i want to search a column for the largest number...but the numbers have an E
before them.... E05001 E05002 E05003 .. .. .. E05xxx is it possible to find the largest one, then add one to it and give me back that number? when the new year comes, the series will look like this: E06001 E06002 .. .. .. E06xxx Thanks for any input on this |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User Selectable Series and Number of Series for Line Chart | Charts and Charting in Excel | |||
| Figuring number of Mon. Tues. Wed between dates | Excel Worksheet Functions | |||
| Having trouble with number series | Excel Discussion (Misc queries) | |||
| How do I change a social security number to a number series? | Excel Discussion (Misc queries) | |||
| how to get number series in excel 1 2 3 4 etc | Excel Worksheet Functions | |||
Threaded Mode
