| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
HOW DO I GET A WARNING FOR REPEATED NUMBERS
I am working on a spreasheet in excel I have got invoice numbers but i need
to create a warning for repeated invoice numbers.Any help would be most appreciated. Thanks |
|
#2
|
|||
|
|||
|
Try =COUNTIF(A:A,A1)=1, previously posted by Vishu
"Kenya" wrote: I am working on a spreasheet in excel I have got invoice numbers but i need to create a warning for repeated invoice numbers.Any help would be most appreciated. Thanks |
|
#3
|
|||
|
|||
|
Thank you Kassie,It worked!
"Kassie" wrote: Try =COUNTIF(A:A,A1)=1, previously posted by Vishu "Kenya" wrote: I am working on a spreasheet in excel I have got invoice numbers but i need to create a warning for repeated invoice numbers.Any help would be most appreciated. Thanks |
|
#4
|
|||
|
|||
|
For those who are not as computer literate. Here follows instructions:Click
on A to high light that column. Go to Data. Go to validation.In settings go to Allow and put in Custom.In formula put the formula =COUNTIF(A:A,A1)=1. Follow this procedure with column B or C ect and substitute A for B or C ect in formula box. "Kassie" wrote: Try =COUNTIF(A:A,A1)=1, previously posted by Vishu "Kenya" wrote: I am working on a spreasheet in excel I have got invoice numbers but i need to create a warning for repeated invoice numbers.Any help would be most appreciated. Thanks |
|
#5
|
|||
|
|||
|
Glad I could help. thanks for the response
"Kenya" wrote: Thank you Kassie,It worked! "Kassie" wrote: Try =COUNTIF(A:A,A1)=1, previously posted by Vishu "Kenya" wrote: I am working on a spreasheet in excel I have got invoice numbers but i need to create a warning for repeated invoice numbers.Any help would be most appreciated. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| Match Last Occurrence of two numbers and Return Date | Excel Worksheet Functions | |||
| 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) | |||
Linear Mode
