So, being familiar with RANK, MATCH and INDEX. And having a table using such commands, I have a question that is somewhat difficult to describe.
Let's say I'm ranking the best NHLers.
A = my rank (1, 2...10)
B = data (players)
C = RANK(A1,$A$1:$A$10,1)
E = MATCH(G1,$C$1:$C$10,0)
G = Final rank (1, 2...10)
H = INDEX($B$1:$B$10,E1)
So let's say I'm making my list of the 50 best players in the league (I only used 10 spots up there, but shut up) and I'm at 47 and I go, "crap, forgot Patrick Kane" and he belongs at 16...I would have to type in Kane as 16 and then every other players number would have to change. Which, using the series command wouldn't be bad if I only make one big error. But if I make a few and start moving things around and etc. I need the list to shape-shift with me so to speak.
You know in a fantasy football or hockey thing on Yahoo. You can kind of drag and drop your players? So, you think this will be a huge year for Derrick Pouliot and you drag him all the way up to #6, well, that slides Ryan Getzlaf to 7, Shea Weber to 8, Anze Kopitar to 9, etc.
In my formula above, if I put Pouliot at 6, I have to manually move Getzlaf to 7, Weber to 8, Kopitar to 9...is there any way to create that mechanism? Or am I stepping into the uncharted (for me) waters of macros?