Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i get a warning for repeated numbers
I am working with a spreedsheet incorporating invoice numbers. How do I
create a warning when i repeat an invoice number |
#2
|
|||
|
|||
I like to use conditional formatting when it's convenient:
If you have invoice numbers starting in Cell A3, try conditional formatting from A3 through as far down column A as necessary with this: Formula is: =COUNTIF(A$3:A3,A3)1 Format: Pattern: Bright Red Using that, the first entry of an invoice number is ignored, but all subsequent duplicates are flagged. Does that help? Regards, Ron "Kenya" wrote: I am working with a spreedsheet incorporating invoice numbers. How do I create a warning when i repeat an invoice number |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match Last Occurrence of two numbers and Return Date | Excel Worksheet Functions | |||
HOW DO I GET A WARNING FOR REPEATED NUMBERS | Excel Discussion (Misc queries) | |||
Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) |