formula to combine cells using if/then

G

Guest

Primary First Primay Last Secondary First Secondary Last First Last
John Smith Debbie John & Debbie
Carl Overstreet June Overstreet Carl & June
Robert Johnson Susan Devers

I have the formula that combines the primary first and primary last name if
the Primary Last Name is either the same as the Secondary Last Name or the
Secondary Last Name is blank. =IF(OR(B1=D1,D1=""),A1&" & "& C1,"") I need to
add to this a formula that will combine the Primary First, Primary Last, &
the Secondary First Name into the First Name Column when the Primary Last
Name and the Secondary Last Name are not the same.
 
G

Guest

Thank You Roland, now I have one more question.

I have a formula that will put the Primary Last Name into Cell F2 and would
like to (OR(B2=D2,D2="") I need to add the variable that if B2 Does not equal
D2 and D2 is not blank that it will bring over D2 into cell F2.

Thank YOU
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

concatenate a text string if two different cells contain the sam. 5
Reverse Text then combine rows 4
Changing alphabetizing entries 3
Combine firstt & last name 5
Combine First and Last Name colums to create thrid column of full 3
Combine two cells 3
Windows 10 I would like to know in a batch file how to indentify computer name by using the first 5 of the name and the last 2 of the name then call runcmd 0
If not an exact match to left of comma, then ALERT 5

Top