formula needed

[coachdp3]

Looking to create a simle form that I can collect simple data, Name address, phone number, etc on each row. as I add rows, I want a formula or conditional format that will tell me if I enter the same name, address, phone, number, etc to avoid repeat info. Can you help?

 

[Trouttrap2]

First that comes to mind is using Data Validation.
-Highlight the range you want to apply the Data Validation
-Click on Data Validation
-Select Custom
-Enter this formula =COUNTIF($A$1:$A$100,A1)=1

Change the range as necessary, but use the $ to lock the range. Basically this will alert you if you have >1 duplicate, and ask you to re enter. You can change Alert prompt to anything you want by customizing the Input Message found on the same window as Data Validation.

 

[GTO]

Excel Workbook
	A	B	C
1	Name	Address	Phone
2	Carl Smith	123 W. Sunny Lane	877.900.5555
3	Becky Smith	123 W. Sunny Lane	600.232.5555
4	Bob Smythe	555 N. Happy Way	877.900.5555
5	Bob Smythe	123 N. Stellar Dr	877.555.5555
Sheet1

For like the above, in cell A3, Conditional Formatting (CF), with 'Formula is' chosen, formula: =COUNTIF($A$2:$A3,$A3)>1

Choose what formatting, I chose pattern of course. Similar formulas for other columns.

Do this BEFORE entering data or formatting and such. Then just drag the cells downward and the CF will auto-adjust teh formula.

I would note that CF with formulas can get expensive.

Hope that helps,

Mark

 

[coachdp3]

Thank you. Works great.