Forum Discussion
counting the number of items provided that counting duplicated items one time only
I have a range of items names and I want to count the number of items provided that counting duplicated items one time only. The range or number of items is variable dynamically. How can do this? see...
but the data could exceed C12 and I do not know where it ends every time
=COUNT(UNIQUE(C6:INDEX(C6:C100000,COUNTA(C6:C100000))))
- HansVogelaar
I applied this function but it returns zero value, (formula refers to empty cells). I have values in these cells resulting from the filtering process.If you're looking to omit blanks at the end of the range, this might work:
=LET(c,C6:C10000,blankfree,FILTER(c,c<>""),COUNTA(UNIQUE(blankfree)))
