Solved

Match formula for duplicate values

Posted on 2012-12-28
3
174 Views
Last Modified: 2012-12-28
Hi! Column A1:A25000 has data. This data has duplicates. How do I count total values excluding the repeating numbers? Thanks! P.S. I have Excel 2010.
0
Comment
Question by:Ladkisson
3 Comments
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 38727375
Try this array formula

=SUM(IF(FREQUENCY(IF(LEN(A2:A100)>0,MATCH(A2:A100,A2:A100,0),""), IF(LEN(A2:A100)>0,MATCH(A2:A100,A2:A100,0),""))>0,1))
0
 
LVL 7

Accepted Solution

by:
leptonka earned 200 total points
ID: 38727377
Hi!

So you have numbers in column A? And you need how many different numbers you have?
Then you can use this formula:

=SUM(--(FREQUENCY(A1:A25000,A1:A25000)>0))
confirm with Ctrl+Shift+Enter.

Cheers,
Kris
0
 

Author Closing Comment

by:Ladkisson
ID: 38727398
Great! Short to the point! Thank you!
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

813 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now