Hi,
I am working on a roster sheet that I am having trouble working out a formula for. It should be so simple, but yet I can't seem to get it to work.
For Example: If I enter an employee number into cell A1 an in cell B1 is the allowance for uniform, I need a formula that will lookup all of column A, and if this is the first instance of this employee number cell B1 should =$2.05. But the formula needs to be able to recognise that if the employee number occurs more than once, I only want it to pay the $2.05 once and not on every occurance of the employee number
Any help would be appreciated.
Cheers
Bookmarks