Parapunter
20th Nov 2007, 11:37
Hi all, can't find this on a search, sooo,
I have a spreadsheet that I use for business. Within it, each job is allocated a unique job reference & this is calculated sequentially by using MAXA (range)+1 so that the formula finds the highest value in the range & adds 1 to give the next order number.
Thing is, this morning I came up order no. 10,000 & I would like to reset it to one. Obviously MAXA won't do that, so is there a way, bearing in mind that if I reset the range, the high 999x job numbers are mixed on the sheet with the desired 1, 2 range etc. because the sheet is necessarily ordered by date rather than job number.:confused:
I have a spreadsheet that I use for business. Within it, each job is allocated a unique job reference & this is calculated sequentially by using MAXA (range)+1 so that the formula finds the highest value in the range & adds 1 to give the next order number.
Thing is, this morning I came up order no. 10,000 & I would like to reset it to one. Obviously MAXA won't do that, so is there a way, bearing in mind that if I reset the range, the high 999x job numbers are mixed on the sheet with the desired 1, 2 range etc. because the sheet is necessarily ordered by date rather than job number.:confused: