I am using a spreadsheet that was developed by a prior worker and I'm having
trouble sorting the product using one of the fields without it changing the
values in the other fields. I.E column 3 has been assigned a ranking number
based on its importance to our workforce. Column 6 has a seperate ranking
field with a priority status that ranks from 1-5. When I try to sort the
products by their priority status, their ranking number in column 3 realign
in sequential order. Help me to sort by column 6 with keeping column 3's
ranking assigned to their product.

Thank you,
TSgt M. Gibson