Wednesday, April 30, 2014

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.
----------------------------------------------------------------------------------------------------------------------------------------------------