Excel 2000

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

Thanks for the help.
As an example:

Row 4 in a worksheet- Column A has the number 1
designating the first product in the worksheet with
columns b through g and rows 4 through 10 containing
information about that product. Row 11, column A would
then have a number 2 showing the second product with
columns b through g and rows 12 through 15 containing
information about that product. I trying to re-number the
column A numbers after a product (one or many rows) have
been removed.
 
One way:

A4: 1
A11: =MAX(A$4:A10)+1

copy A11 to the first row of your products - the cell references
will adjust to look only at the rows above.

If you had some sort of marker in columns B:G for a new product, you
could create a formula to put in every cell in column A. For
instance, if a new product row always starts with "PRODUCT:xxxxx" in
column B, then you could use something like:

A5: =IF(LEFT(B5,8)="PRODUCT:", MAX(A$4:A4)+1,"")

and copy A5 down as far as your data goes - it will only display a
value in new product rows.
 
Back
Top