Sunday, June 9, 2013

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   Jun 09, 2013
user Ditmar Visser (!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.

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).

- Ditmar Visser