| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Duplicate items
If I have the following:
Column A Mike Soren Jim McGree Paul Jackson James Banton Mike Soren How can I have a formula that notices I just entered in "Mike Soren" a second time in column A? and maybe it will change the color of the text? or sound a warning beep? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Duplicate items
Hi,
Conditional formatting should do what you want. Select your column of data including empty cells where you may enter additional names and then Format|Conditional format Select 'Formula is' enter the formula =COUNTIF($A$1:$A$100,A1)1 Pick a colour and click OK Duplicated names will now be highlighted and if you add a new name that is a duplicate both will be highlighted. Change Column A to your column Mike " wrote: If I have the following: Column A Mike Soren Jim McGree Paul Jackson James Banton Mike Soren How can I have a formula that notices I just entered in "Mike Soren" a second time in column A? and maybe it will change the color of the text? or sound a warning beep? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Duplicate items
Assuming that your data are in A1:A100 you could use following conditional
formatting formula for A1 (Menu Format|Conditional Formatting): =COUNTIF($A$1:$A$100,A1)1 apply the desired format for this condition, push 'OK' and copy the format down to A100 (easiest way is to use the format painter). JM wrote in message ... If I have the following: Column A Mike Soren Jim McGree Paul Jackson James Banton Mike Soren How can I have a formula that notices I just entered in "Mike Soren" a second time in column A? and maybe it will change the color of the text? or sound a warning beep? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Duplicate items
I shouild have added change the 100 to the row number appropriate for you range
"Mike H" wrote: Hi, Conditional formatting should do what you want. Select your column of data including empty cells where you may enter additional names and then Format|Conditional format Select 'Formula is' enter the formula =COUNTIF($A$1:$A$100,A1)1 Pick a colour and click OK Duplicated names will now be highlighted and if you add a new name that is a duplicate both will be highlighted. Change Column A to your column Mike " wrote: If I have the following: Column A Mike Soren Jim McGree Paul Jackson James Banton Mike Soren How can I have a formula that notices I just entered in "Mike Soren" a second time in column A? and maybe it will change the color of the text? or sound a warning beep? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Duplicate items
On Aug 19, 12:44*am, Mike H wrote:
Hi, Conditional formatting should do what you want. Select your column of data including empty cells where you may enter additional names and then Format|Conditional format Select 'Formula is' enter the formula =COUNTIF($A$1:$A$100,A1)1 Pick a colour and click OK Duplicated names will now be highlighted and if you add a new name that is a duplicate both will be highlighted. Change Column A to your column Mike " wrote: If I have the following: Column A Mike Soren Jim McGree Paul Jackson James Banton Mike Soren How can I have a formula that notices I just entered in "Mike Soren" a second time in column A? and maybe it will change the color of the text? or sound a warning beep?- Hide quoted text - - Show quoted text - Mike thank you so much! that helped me big time!! I really appreciate it! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting Duplicate items when adding to toolbar | Excel Discussion (Misc queries) | |||
| Duplicate and unique items in 2 lists | Excel Discussion (Misc queries) | |||
| subtracting (extracting non-duplicate items)HELP!! | Excel Worksheet Functions | |||
| Checking for duplicate items in list | Excel Worksheet Functions | |||
| How to get rid off duplicate items? | Excel Discussion (Misc queries) | |||
Linear Mode
