Hi everybody

I have a list of works for several machines
A B
Machine1 Work1
Machine1 Work2
Machine2 Work1
Machine2 Work2
Machine2 Work3

manually, i can assing a priority number for each work (let's say in column C)
to see which should be done first
(work2 in machine1 can be done before work1)

what I want to know
it's if is possible to do it in a semi-automatic or automatic way

I thought in maybe buttons
to increase or decrease the number
BUT at the same time, modify the priority number of the other works on the
same machine

if this could be archieved with a formula, even better


in short
modify the number assigned as priority for a list of works to be done on the
same machine
(also, if new works are added for the machine, a priority number shold be
assigned automatically, and be able to modify as well)

hope i've explained myself