I have an table I am constantly putting new information in and the items are ranked. When I put new data in that out ranks the old data I am currently assigning the appropriate rank but then have to go through all the other data and change the rank on them manually. Is there a way that when I change the rank it automatically adjusts and renumbers the rest?
Thank you