Count duplicate but ignore first occurrence

can you help me with attached file?

it might be easy but i could not figure it out.

two column count duplicate but ignore first occurrence.  see attached.
Book1.xlsx
LVL 6
FloraAsked:
Who is Participating?
 
Rgonzo1971Commented:
Hi,

then try in C3 and fill down

=IF(COUNTIFS(B$3:B3,B3,A$3:A3,A3)-1=0,"",1)

Regards
0
 
ReneD100Commented:
In cell C3:
=COUNTIF(B3:B22;B3)-1
0
 
SAHIL HANDASELF EMPLOYEDCommented:
NO NEED TO IGNORE THE OCCURENCE . JUST CLICK ON THE SPEED SHEET AND SAVE IT WITHOUT ANY ISSUES'S
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
Rgonzo1971Commented:
Pls try

in C3 and fill down

=IF(COUNTIF(B$3:B3,B3)-1=0,"",COUNTIF(B$3:B3,B3)-1)

Or

=IF(COUNTIF(B$3:B3,B3)-1=0,"",1)


Regards
0
 
FloraAuthor Commented:
perhaps i did not ask the question in more clear way.   i need to check both EE ID and the ID see the column C is what i need to be returned by formula.

Capture.PNGBook1.xlsx
0
 
FloraAuthor Commented:
Rgonzo1971

A BIG THANK YOU TO YOU. IT WORKED.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.