Software

Ask something
Discussion Locked

Excel 2000 - COUNTA function

0 helpful
2 replies

by kevin.crossmock

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

2 replies

by escuetaac

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

by escuetaac

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

andy

This discussion is closed to new replies.