Thread: Duplicate Function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Duplicate Function
=IF(COUNTIF(A$1:A$7,A1)1,"Duplicate","Notduplicat e")
--
David Biddulph

"Manni" wrote in message
...
Hi,

I have a data below and I want to creat a function to tell me if the
number
I am working on is a duplicate or not. How do I do this?

1
2
3
4
1
4
3




Reply With QuoteReply With Quote