Is there a formula for a column that will re-sequence your numbers, no matter
what you number you change in the row to that column. I used to do this in
lotus. If I changed priority 7 to 8 all the other numbers would either plus
up one or minus one to keep the priority sequence within the 1 to 100 range
with no duplication or missing numbers.