I have a spreadsheet with 19,000 records each record has 4 columns. column A is used internally. Column B is a new phone number, column C is an existing home phone number and column D is an existing POE phone number.  I need to compare column B to C&D and if it is different than either one then put in column E.

---

Answer from Richard Rost:

First of all, when you're dealing with 19,000 records, you SHOULD be using Microsoft Access, not Excel.

If I understand you correctly, you want to see if the new phone number (B) is different from both C and D, and if so, put it in E.

How about this for E1:

=IF(AND(C1<>B1,D1<>B1),B1,"")

This will put B1 (the phone number) in cell E1 if it's different from both the other values. Otherwise, it leaves the cell blank.

Give it a try. Here's more help with the IF function if you need it:

You can use the IF function to have Excel place a value in a cell based on one or more conditions or values in other cells.

See this FREE tutorial on my web site for more information on how to use the IF function:

http://www.599cd.com/tips/excel/misc/if-function-sales-tax.asp?key=BlFAlEx