# Formula to state this is the first, second, third... time this employee number used

1. ## Formula to state this is the first, second, third... time this employee number used

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.

2. ## Re: Formula to state this is the first, second, third... time this employee number used

hi Dan007, welcome to the forum. assuming data starts in A2, try this in B2:
=COUNTIF(A\$2:A2,A2)

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1