Check for double entries in a row
 

Hi,

I want a function to return a yes/no value based on if there is 2 or more
identical values in a row.

I am doing a schedule and I want to make sure that a particular person does
not have two duties the same day.

Thank you.

Take a look he

http://cpearson.com/excel/duplicat.htm

In article ,
"Pierrot Robert" wrote:

Hi,

I want a function to return a yes/no value based on if there is 2 or more
identical values in a row.

I am doing a schedule and I want to make sure that a particular person does
not have two duties the same day.

Thank you.