IF, COUNTIFS Statement

bflan0524

Board Regular
Joined
Oct 7, 2016
Messages
169
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 EColumn L Column BH
Employee Officer CodeEnterprise IDUnique Enterprise ID
ABCE222999999

<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
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
41,095
Office Version
365
Platform
Windows
You're formula works for me, what is the first row with an employee?
 

bflan0524

Board Regular
Joined
Oct 7, 2016
Messages
169
thank you, i must have fat fingered something when i did it in the actual spreadsheet, works now. thanks again
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
41,095
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,099,807
Messages
5,470,894
Members
406,733
Latest member
darzu

This Week's Hot Topics

Top