Thread: Excel: # in a cell if a # is repeated in a row
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Excel: # in a cell if a # is repeated in a row
=IF(COUNTIF($A$1:A1,A1)1,"duplicated","")


"dilettante" wrote:

I need toi get a value or message in a cell if a row of the sheet has a the
same number more than one time.
Is ther any function I may use?
Than you for helping.
--
dilettante
Reply With QuoteReply With Quote