ExcelBanter - Excel: # in a cell if a # is repeated in a row

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel: # in a cell if a # is repeated in a row (https://www.excelbanter.com/excel-worksheet-functions/137286-excel-cell-if-repeated-row.html)

dilettante

Excel: # in a cell if a # is repeated in a row

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

Teethless mama

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

dilettante

Excel: # in a cell if a # is repeated in a row

That's timing.
Thank you very much!
Regards
--
dilettante

"Teethless mama" wrote:

=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

All times are GMT +1. The time now is 09:32 AM.