If values repeat in consecutive rows of a column and in the corresponding rows of the other column the values do not repeat then return zero(0) otherwise return one(1)
<tbody>
</tbody>
Now I kindly request you to help an excel formula which will return 1 in the first two rows of the Results column and zeros(0) in the third up to fifth row of the Results column, despite Unique ID in the fourth and fifth row being the same. I am not able to do coding so help me with formula which are in the excel formula list.I use Microsoft excel 2007
Unique ID | Disease Name | Results |
12005 | CVD | |
12005 | CVD | |
13964 | RD | |
12345 | DIABETES | |
12345 | RD |
<tbody>
</tbody>
Now I kindly request you to help an excel formula which will return 1 in the first two rows of the Results column and zeros(0) in the third up to fifth row of the Results column, despite Unique ID in the fourth and fifth row being the same. I am not able to do coding so help me with formula which are in the excel formula list.I use Microsoft excel 2007