Matching names in different excel sheets
Closed
NTP
-
Aug 6, 2009 at 11:35 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Aug 10, 2009 at 06:17 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Aug 10, 2009 at 06:17 AM
Related:
- Matching names in different excel sheets
- My contacts list names - Guide
- Number to words in excel - Guide
- Mark sheet in excel - Guide
- How to take screenshot in excel - Guide
- Dd-mm-yyyy format in excel - Guide
1 response
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Aug 10, 2009 at 06:17 AM
Aug 10, 2009 at 06:17 AM
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
Rangetocheck should be locked. example sheet2!$a$1:$A$100
