Matching names in different excel sheets [Closed]

Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hello,
I have two excel sheets with names which I would like to match (some have more names than others). Can you give me a formula to do this?

1 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Hello NTP use countif(rangetocheck, "=" & A1) to check for a name in A1 in Rangetocheck.Rangetocheck

Rangetocheck should be locked. example sheet2!$a$1:$A$100

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!