yogi_Pull The Names And Percentage Of Those Who Were InvitedAndAttended From Lists Of WhoWereInvited And WhoAttended

                                         Google Spreadsheet   Post  #1621
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-30-2014
post by Ravel Fagundes: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/1dKa8DkQ0_A)
How can I compare two lists and get a percentage of results in common

Hi, 

I Would like to know how can I compare two columns and get a result of names in common and percentage of presence. 

Column A (Guest list names) 

John 

Paul 

George 

Ringo 

Column B (List of names that were present) 

John 

Paul 

George 

Column C (List of names in common between the lists) 

John 

Paul 

George 

Column D (Percentage of presence) 

75% 

- 

Sorry for my english.

----------------------------------------------------------------------------------------------------------------------------------------------------