dickpierce
Board Regular
- Joined
- Nov 26, 2004
- Messages
- 148
- Office Version
- 2007
- Platform
- Windows
I have four columns of data. Each column has about 660 names in them.
a: Last Name
b: First Name
c: Last Name
d: First Name
I'm using the following formula in column e:=IF(COUNTIF(c:c,A2)>0,"",A2)
It works great unless there are matching first names in b and d. What is the formula I could use that would work that would weed out same first names?
a: Last Name
b: First Name
c: Last Name
d: First Name
I'm using the following formula in column e:=IF(COUNTIF(c:c,A2)>0,"",A2)
It works great unless there are matching first names in b and d. What is the formula I could use that would work that would weed out same first names?