yogi_Update Ranking Of Movies for Movies In Table A2:B6 As A New Movie With Its Rank Is Added In A7:B7

                                          Google Spreadsheet   Post  #1234
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun 09, 2013
user Ditmar Visser (http://productforums.google.com/forum/?zx=bedk0wbux5gu#!mydiscussions/docs/paRBsJYyMH4)

I am making a spreadsheet with all the movies I have watched (link), and i want to rank them. 

Now is there an easy way to do this? Let's say I've already ranked 10 movies, and a movie comes inbetween movie #3 and #4, how can I make movies #4 and up move 1 number up?

I hope this makes sense, and thanks i advance!

- Ditmar Visser

---

I linked to the Spreadsheet in my original question, but i made an alternate, simplified version to better explain it. https://docs.google.com/spreadsheet/ccc?key=0Aolv0Cjc4JSbdHJadU9RR2M3ak9rZmxaT0ItTmpfM1E&usp=sharing

In Sheet 1 I have the current situation. There are 6 movies, and i have already ranked 5 of them in the second collumn.

I want to rank 'Movie 6' at 2, but there's the problem. If i do that i have 2 number 2's. To fix this I manually changed every cell under 1 to have a number 1 higher than the original.

This is do-able when there are just 5 cells i want to change, but when there are more, it becomes a chore. 

I want to have a way to easily add 1 to every cell i have selected (in this case, cell B3 B4 B5 B6).

Thanks!

- Ditmar Visser

-----------------------------------------------------------------------------------------------------