Conditional Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brurobiney - 10 Nov 2006 17:10 GMT

I have column A with over 500 account numbers. What is the formula that will
allow me to see which of those accounts are listed more than once.

Reply to this Message

Dave F - 10 Nov 2006 17:14 GMT

One way:

1) Sort the column in ascending order
2) In B2 enter a formula: =IF(A2=A1,1,"") and fill down to the bottom of
your column of numbers in column A
3) Anywhere where a 1 appears, there are duplicates.

Dave

Signature

Brevity is the soul of wit.

> I have column A with over 500 account numbers. What is the formula that will
> allow me to see which of those accounts are listed more than once.

Reply to this Message

Teethless mama - 10 Nov 2006 17:54 GMT

Highlight your range
Conditional Formatting
Formula Is =COUNTIF($A$1:$A1,$A1)>1
Click Format button and select Pattern then click OK and OK

> I have column A with over 500 account numbers. What is the formula that will
> allow me to see which of those accounts are listed more than once.

Reply to this Message