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

[TABLE="width: 500"]
<tbody>[TR]
[TD]Column E[/TD]
[TD]Column L [/TD]
[TD]Column BH[/TD]
[/TR]
[TR]
[TD]Employee Officer Code[/TD]
[TD]Enterprise ID[/TD]
[TD]Unique Enterprise ID[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]E222999999[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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