| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add colour to first duplicate and select
Hi Xls Community.
I have 1826 cells with duplicates. I used the formula =COUNTIF($A$2:$A$1826,A2)=1 to identify the all duplicates. I would like xls to add colour only to the first duplicated and select all coloured cells to copy and given the choice to paste in another column. Your help is welcome. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SELECT DUPLICATE IN SELECTION | Excel Worksheet Functions | |||
| I do not see the selection colour when I select some cells | Excel Discussion (Misc queries) | |||
| change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
| How do you select the colours on Microsoft excel colour pallets? | Excel Discussion (Misc queries) | |||
| Select a range but only sum the cells in a certain colour? | Excel Worksheet Functions | |||
Threaded Mode
