formula to know Repeated number

**dr.mahmoud.kh86** · 07-30-2019, 08:45 AM

good evening ,
i work to collect data for hospital analysis , and they want to know readmission data from excel sheet by using patient medical number
if i have list of patient medical number in column
like
201064
201741
201967
203146
204050
204533
205356
206522
207745
207984
208260
210314
210494
210734
211896
211896
212105
212218
213081
213081
how can i know the medical number who repeated ?

**Pepe Le Mokko** · 07-30-2019, 08:46 AM

Hi and welcome
perhaps try Conditional Formatting?

**Sam Capricci** · 07-30-2019, 09:46 AM

assuming your data starts in cell A2 this formula will show duplicates... =IF(COUNTIF($A$2:A2,A2)>1,"duplicate","")
or shortened to =COUNTIF($A$2:A2,A2) and any that are above 1 are duplicates.
Though I think the conditional formatting recommended by Pepe is the better option.