General discussion

Locked

Excel 2000 - COUNTA function

By kevin.crossmock ·
I am looking for a variation of the Excel COUNTA function that will count NON-DUPLICATE entries in a range of cells. For instance, if the range contained entries of 1,4,x,y, the value would be 4. If, however, the range contained 1,4,4,x, the valuewould be 3 as it only counts the first entry for the number 4.

Data valadation or drop down lists are not a viable choice with this application as I do not know what all the possible entries could be. Any ideas? Thanks - Kevin.

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

mine is ok

by escuetaac In reply to Excel 2000 - COUNTA funct ...

kevin,

mine is ok when i tried using count function..it could be how you defined the range...i also tried expanding the range with positive result.

andy

Collapse -

mine is ok (revised)

by escuetaac In reply to Excel 2000 - COUNTA funct ...

i do counting of non duplicate items on another application, from excel to lotus approach with with much ease...

andy

Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums