Forum Discussion
How to find unique value from duplicate value in numbers while in data filter
How to find unique value from duplicate value in numbers while in data filter
I am new for this, can you please guid me how to updalod the working file in this portal.
Actually I used COUNTA(UNIQUE(A4:A1178)) formula to get single value from cells with duplicate value by which whole column count and after filter show same value for some criteria too.
Kindly suggest...
Your formula
= COUNTA(UNIQUE(list))
is perfectly valid, as is
= ROWS(UNIQUE(list))
The latter focusses upon the dimensions of the resulting array whereas the former looks more at the content. If blank fields are present within the list
= ROWS( UNIQUE( FILTER(list, list<>"") ) )
could be useful.
- Thank you
but it not useful in this scenario