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
<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
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