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.
|