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
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
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
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
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks