If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Searcing multiple numbers | Ken | General Discussion | 4 | November 6th, 2004 02:53 PM |
Importing telephone numbers from excel | Support | General Discussion | 7 | October 25th, 2004 12:25 PM |
How do I prevent Excel from putting 16 digit numbers into scienti. | Anthony Rizk | General Discussion | 2 | October 19th, 2004 02:23 AM |
Help Needed for Groups Please | Paul Black | General Discussion | 15 | June 21st, 2004 02:54 AM |