Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 111
  • Last Modified:

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
0
Flora
Asked:
Flora
1 Solution
 
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
 
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
Rgonzo1971Commented:
Hi,

then try in C3 and fill down

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

Regards
0
 
FloraAuthor Commented:
Rgonzo1971

A BIG THANK YOU TO YOU. IT WORKED.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now