get count of row without duplicate entries

A

Aananth

Hi,

Need help in getting the following functions in excel, i need to get a count
of values in a row, if there are duplicate values they should not be
considered, how can this be done.

Need response ASAP.

Thanks,
 
A

Aladin Akyurek

If you're looking for a distinct count...

=SUM(IF(A2:F2<>"",1/COUNTIF(A2:F2,A2:F2)))

which you need to confirm with control+shift+enter instead of just wit
enter.

If you're looking for a count of items with single-occurrence...

=SUMPRODUCT(--(COUNTIF(A2:F2,A2:F2)=1))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicate entry in a column/row 14
Word VBA - Automatic change content of a cell in table using dropdown list 5
Dcount -Date Criteria - Won´t find it - 0
complex sort search and replace macro 2
Function in Excel to count and list number of entries of text valuesin a row. 2
How to count the numbers in a Word document? 0
Merging from an Excel file with graphics 1
Adding a big matrix in Word 2013 5

Top