Solved

Count duplicate but ignore first occurrence

Posted on 2014-10-30
6
95 Views
Last Modified: 2014-10-30
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
Comment
Question by:Flora
6 Comments
 
LVL 5

Expert Comment

by:ReneD100
ID: 40413003
In cell C3:
=COUNTIF(B3:B22;B3)-1
0
 

Expert Comment

by:SAHIL HANDA
ID: 40413021
NO NEED TO IGNORE THE OCCURENCE . JUST CLICK ON THE SPEED SHEET AND SAVE IT WITHOUT ANY ISSUES'S
0
 
LVL 50

Expert Comment

by:Rgonzo1971
ID: 40413042
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
Technology Partners: 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!

 
LVL 6

Author Comment

by:Flora
ID: 40413084
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
 
LVL 50

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 40413118
Hi,

then try in C3 and fill down

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

Regards
0
 
LVL 6

Author Comment

by:Flora
ID: 40413123
Rgonzo1971

A BIG THANK YOU TO YOU. IT WORKED.
0

Featured Post

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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question