Hi,

I'm looking to be able to enter a formula that will equal 1 if an employee number is entered, then if it is entered again in another cell it will equal 2, then again will equal 3, so on and so on.

eg...
Employee #......................Code
75555................................1
75555................................2
75555................................3
75555................................4
etc...

The reason being is that I need to pay casual employees a laundry allowance of $2.05 per day, however they may work more than one shift per day so I want the first shift to pay the $2.05 ie: if cell B2 = 1 pay $2.05, if cell B2 is greater than 1 then pay nothing.

Thanks for your help.