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

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
42,669
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
42,669
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,102,350
Messages
5,486,349
Members
407,541
Latest member
Emilybuhman

This Week's Hot Topics

Top