Ladkisson

asked on

# Match formula for duplicate values

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.

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Great! Short to the point! Thank you!

=SUM(IF(FREQUENCY(IF(LEN(A