IF, COUNTIFS Statement

[bflan0524]

hello
i am trying to write a formula to identify unique enterprise IDs associated with an employee. table below. i don't know where i am messing up, if somebody could advise. Column BH is where the formula is

Column E	Column L	Column BH
Employee Officer Code	Enterprise ID	Unique Enterprise ID
ABC	E222999999

<tbody>
</tbody>

Current formula
=IF(COUNTIFS(E$3:E4,E4,L$3:L4,L4)>1,0,1)

so basically if the next row was ABC for Employee Offiicer Code and the same Enterprise ID that row in column BH would return 0,
if column E was different then ABC, it would return 1

hope this makes sense

ty

 

[Fluff]

You're formula works for me, what is the first row with an employee?

 

[bflan0524]

thank you, i must have fat fingered something when i did it in the actual spreadsheet, works now. thanks again

 

[Fluff]

You're welcome & thanks for the feedback