Find text Sequentially Number
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.
"pwk" wrote:
I have a spread sheet that has: Item: 0308 0730 in cell A24, Item:
0308 0763 in cell A39 and so forth, I would like to put a 1 in cell
AB24, 2 in AB39 and so forth. I could probably base my macro on
Finding the text "Item" and Sequentially Numbering in the allied colum
AB. I've tried using find and search functions to no avail. I know
this is probably easy using a fuction or FindNext but I'm also having
a problem Sequentially Numbering. THANKS in Advance. Paul
|