Solved

# Count duplicate but ignore first occurrence

Posted on 2014-10-30
85 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
Question by:Flora
6 Comments

LVL 5

Expert Comment

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

Expert Comment

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

LVL 48

Expert Comment

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

LVL 5

Author Comment

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.

Book1.xlsx
0

LVL 48

Accepted Solution

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 5

Author Comment

ID: 40413123
Rgonzo1971

A BIG THANK YOU TO YOU. IT WORKED.
0

## Join & Write a Comment Already a member? Login.

### Suggested Solutions

Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
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…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

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

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

#### Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!