Need Help with Filters for Multiple Columns with Missing Values

[annalecta]

I have a spreadsheet where the far left column is a list of names and the columns to the right have information about the person listed in each row on the left. Column B has phone numbers and column C has email addresses. I only want to include the value in Column C (email) for people who do not have a phone number listed in Column B. I am unsuccessfully trying to write a formula to filter out the rest of the information in Column C. Any advice, pointers, tips, or solutions would be much appreciated!!! I can also use SPSS if you have a solution for that instead. Thank you for any insight!

 

[Capt.Ragnar]

Ok. In column D put a formula like...

=IF(B2="",C2,B2)

Copy the formula all the way down if its not already in a table format.