Formatting order numbers
I need help with the ROW function: I am trying to set up a document to keep track of orders where each row represents one item in the order. some orders are for only one item, some are for several, so I need the “Order Number” column to format the order number as “24-[order number]” but only in cells where a new order is entered (the first row in a multi-item order). I can’t figure out a formula that lets me both enter a sequence (automatically format as “24-0001” “24-0002″ etc) and skip rows while keeping track of skipped rows. What I have now is =IF(ISBLANK(J2),” “,TEXT(ROW(A1),”24-0000”)) – this keeps multi-item rows except the first blank but resumes the count as though the blank rows count.
I need help with the ROW function: I am trying to set up a document to keep track of orders where each row represents one item in the order. some orders are for only one item, some are for several, so I need the “Order Number” column to format the order number as “24-[order number]” but only in cells where a new order is entered (the first row in a multi-item order). I can’t figure out a formula that lets me both enter a sequence (automatically format as “24-0001” “24-0002″ etc) and skip rows while keeping track of skipped rows. What I have now is =IF(ISBLANK(J2),” “,TEXT(ROW(A1),”24-0000”)) – this keeps multi-item rows except the first blank but resumes the count as though the blank rows count. Read More