Sunday, April 14, 2013

yogi_Pull Names From A Table Of Names And PhoneNumbers With PhoneNumbers Entered as Numbers Or Text


                                          Google Spreadsheet   Post  #1122
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr 14, 2013
user Al Drah :(http://productforums.google.com/forum/?zx=yg5pzs6aeocd#!mydiscussions/docs/IwBJ-QnJGvg)
How to match phone numbers with names ?
I've just downloaded data from my mobile phone. I have one sheet with 3817 inbox messages which includes columns for phone number, date & time of message, and the message itself, but no data on the name.  The other sheet is my contacts list which has columns for 255 names with associated phone numbers.
I'd like to be able to identify the inbox messages with the names.  Can this be done?
(Using Windows XP SP3, either Firefox or Chrome).
Thank you.

---
Thank you Mr. Anand.  Here is the link for the spreadsheet. 
https://docs.google.com/spreadsheet/ccc?key=0Ah9ZdqjLcEX-dFhZY1Jfc2VEUEVwdlN6QVVSS1VCc3c&usp=sharing
I've combined the 2 sheets into one.  All the data to the left of the grey column (D) is from the contacts data.  All the data to right of column D is from the INBOX messages data. (I have manipulated the numbers slightly to provide a bit of privacy, and (as is obvious) anonymized the names and changed the messages).
What I want to do with the INBOX messages data is to match up the phone numbers to a name which is found in the contact data information.
Let me know if you need any further information.
Thanks again for your help.

---------------------------------------------------------------------------------------------------------------------------
following is a solution to the problem

No comments:

Post a Comment