What function do I use in order to compare data ?

  • Thread starter Thread starter ofra
  • Start date Start date
O

ofra

What function do I use in order to:
1. Compare between rows (for example: I have a column of e-
mail
addresses that some of them appearing 2 times and I want
to find and
eliminate the extra e-mails.)
2. compare between columns in the same worksheet and in
different
worksheet (for example: I have on worksheet 1 2 columns
columns A name
columns B e-mail and on worksheet 2 I have only one column
a name
column and I want to get match the name with the e-mail)
 
Back
Top