I need a for formula to compare data in same row and Put 1

[Infoway123]

Hi

I need a for formula for Birth sequence,

I have a two Childs, they born at same time. If they born at same time, I would indicate in birthseqence as 1
If the Childs born at same time they will give same birth date in birthday column,
The child may have 1 to N...

For example

Example.png


Could you please help me on this.

Thanks
Krishana

[amy_d2]

Hi Infoways,

suppose birth date is in column H, write formula in cell I 12 to see status of Birth date of H12

=IF(COUNTIF(H:H,H12)>1,1,"")