Google Spreadsheet Post #884
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Nov 23, 2012
user batt1eship1 said: (http://productforums.google.com/forum/#!mydiscussions/docs/OxS_6fF5Flk)
Hello,
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.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)
A B
Joe Rank
So,
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.
Thanks!
---
Yogia:
following is a solution to the problem
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.
Thanks!
Go to this spreadsheet FIRST: https://docs.google.
Then go to this one after: https://docs.google.
-------------------------------------------------------------------------
Great, thanks. However, I inserted that formula into cell A1, and it doesn't appear to be working. Probably my fault, but any chance you could take a look at both spreadsheets and see why "Sales" individuals are not importing into the "Sales" spreadsheet? I've added 99 names to the "Standings" spreadsheet and filled it out much like i would in real time.
ReplyDeleteThanks.
Hi draft calc:
ReplyDeleteI have fixed the formula to display 'Rank' in cell A1 while still having values with a 0 in column C values such as 10, 20, 30, etc. -- so check it out to see how this works for you now.
Cheers!
Yogi
Cloud Computing -- Google Docs Way
yogi--anand-consulting.blogspot.com
I still dont think it's working. I inserted that formula into A1 of the "Sales" spreadsheet. Nothing.
ReplyDeleteThanks.
Hi draft calc:
ReplyDeleteIt is working for me -- see the illustration in my blog post.
If you need help from me on your project reach out to me via vCita.com/yogi.anand -- I work with my clients on their projects via vCita.com
Cheers!
Yogi
Cloud Computing -- Google Docs Way
yogi--anand-consulting.blogspot.com
Last question, sorry. Can you look at the sheets now and see what is wrong? I feel I've entered it correctly, and it is populating, just with "#Value!"... it's close, just feels like one small piece might be off? Probably my doing...
ReplyDeletehttps://docs.google.com/spreadsheet/ccc?key=0AkaQB7eehUW0dHRqUzBFUlJMNjE4YWo0bnVUamtVdEE#gid=0
https://docs.google.com/spreadsheet/ccc?key=0AkaQB7eehUW0dGI0anVQZWR6RWNuZ05YYjBIUmFPTkE#gid=0