With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Friday, November 23, 2012
yogi_Pull Data From Spreadsheet Standings For Position Sales And ReOrder Pulled Data By Rank In Ascending Order
Google Spreadsheet Post #884 Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MIwww.energyefficientbuild.com. Nov 23, 2012 user batt1eship1 said: (http://productforums.google.com/forum/#!mydiscussions/docs/OxS_6fF5Flk) Hello,
I have created two spreadsheets, one that has a ranking of names, so:
Sheet 1 (Rankings Page)
A B C
1 John AZ
2 Bill CO
3 Joe NY
Sheet 2 (Joe's page)
i want "Rank" on Sheet 2 to pull Joe's rank of '3' from sheet one and
import it into 'B' of sheet 2... so that if sheet 1 was resorted, and
let's say i moved Joe to No. 2, Sheet 2 would reflect the new rank of 2
and import "2" into column "B" of sheet 2.
Hope that makes sense.
Ok, I made the question a little more simple,
direct and I have provided the "spreadsheet" links below, which are
shared. I have also described what i want on each spreadsheet, but go to
the first link and then the second.