| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find text Sequentially Number
On Sep 19, 12:31*pm, jjones wrote:
There may be other ways of doing this, but I think you could accomplish it using a couple of helper columns. *I am making 2 assumptions--1) that the other rows in between what you have provided do not contain the word "Item" in column A and 2) columns AC and AD are available for use. *If so... On the row with your first item, (row 24?) put a 1 in cell AB24, AC24, and AD24. *In cell AB24 enter the formula: *=FIND("Item",A25). *In cell AC25 enter the formula: *=IF(ISERROR(AB25),AC24,AC24+1). *Finally, in cell AD 25 enter the formula =IF(ISERROR(AB25)," ",AC25). *Pull those formulas all the way down the column and see if column AD gives you what you're looking for. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Excel sequentially number each new document? | Excel Discussion (Misc queries) | |||
| How do I sequentially number indvidual worksheets? | Excel Worksheet Functions | |||
| How do you number different items sequentially within a cell | Excel Discussion (Misc queries) | |||
| How do you number different items sequentially within a cell | Excel Discussion (Misc queries) | |||
| How do I sequentially number every third page of my workbook? | Excel Worksheet Functions | |||
Hybrid Mode
