Compare Figures in a Column
I need to take a column over 5000 rows long and find out which control numbers are duplicated. I have tried =COUNTIF($C$2:$C$5000,C2)1 as an array in conditional formatting, but it didn't work. If it had worked this would have been perfect to highlight all duplicated numbers. Can someone tell me what I did wrong here? -- Cheryl |
Compare Figures in a Column
For highlighting duplicates. Select the range C2:C5000 and try
=COUNTIF(C$2:C$5000,C2)1 If this post helps click Yes --------------- Jacob Skaria "Cheryl" wrote: I need to take a column over 5000 rows long and find out which control numbers are duplicated. I have tried =COUNTIF($C$2:$C$5000,C2)1 as an array in conditional formatting, but it didn't work. If it had worked this would have been perfect to highlight all duplicated numbers. Can someone tell me what I did wrong here? -- Cheryl |
Compare Figures in a Column
I have tried =COUNTIF($C$2:$C$5000,C2)1
as an array in conditional formatting That should have worked. Are you sure you applied it properly? Select the *entire* range of cells starting from cell C2. C2 will be the active cell. The active cell is the one cell in the selected range that *is not* shaded. The formula is relative to the active cell. In Excel versions 2003 and earlier: Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the box on the right: =COUNTIF($C$2:$C$5000,C2)1 Click the Format button Select the desired style(s) OK out In Excel 2007: Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format Enter this formula in the box below: =COUNTIF($C$2:$C$5000,C2)1 Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "Cheryl" wrote in message ... I need to take a column over 5000 rows long and find out which control numbers are duplicated. I have tried =COUNTIF($C$2:$C$5000,C2)1 as an array in conditional formatting, but it didn't work. If it had worked this would have been perfect to highlight all duplicated numbers. Can someone tell me what I did wrong here? -- Cheryl |
All times are GMT +1. The time now is 07:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com