Make the Most of Google Sheets
Formulas used:
Find duplicates =COUNTIF(A2:A48,A2)>1
Extract first name =left(A2,find(" ",A2) -1)
Previous
Going out on your own
Next
Formulas used:
Find duplicates =COUNTIF(A2:A48,A2)>1
Extract first name =left(A2,find(" ",A2) -1)
