N
newmoon
I used a formula to assign a set of numbers to a list of data in order to
identify the data in the row. The formula adds 1 to the value in the cell
above it to creat the number for each row. Now I want the resulting numbers
to stay with the data in its row when I change the position of the that row
relative to the other rows. Can I somehow detach the results numbers from
their formula so that they don't change when I sort the data?
identify the data in the row. The formula adds 1 to the value in the cell
above it to creat the number for each row. Now I want the resulting numbers
to stay with the data in its row when I change the position of the that row
relative to the other rows. Can I somehow detach the results numbers from
their formula so that they don't change when I sort the data?