Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
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 -- Brevity is the soul of wit. "Brurobiney" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
Highlight your range
Conditional Formatting Formula Is =COUNTIF($A$1:$A1,$A1)1 Click Format button and select Pattern then click OK and OK "Brurobiney" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting a range with conditional formatting | Excel Worksheet Functions | |||
conditional formatting glitches | Excel Discussion (Misc queries) | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions |