Forum Discussion
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
- You may not have the option to upload a workbook because your account is new. You could host it on OneDrive or another sharing host site.
Please use the below link to download the workbook, so that you will get the clarity
https://we.tl/t-moOYzA3ngg
Thank you for sharing the workbook. Essentially, you need a conditional SUBTOTAL. I have a method for obtaining this with MAP.
Here are your formulas for those 3 columns Left to Right:
Product:
=LET(c,A4:A1178,m,MAP(c,LAMBDA(e,IF(SUBTOTAL(3,e)=1,e,""))),COUNTA(UNIQUE(m))-1)Material No:
=LET(c,B4:B1178,m,MAP(c,LAMBDA(e,IF(SUBTOTAL(3,e)=1,e,""))),COUNTA(UNIQUE(m))-1)Material Group:
=LET(c,C4:C1178,m,MAP(c,LAMBDA(e,IF(SUBTOTAL(3,e)=1,e,""))),COUNTA(UNIQUE(m))-1)Including PeterBartholomew1 because the original request was missing some details and I'd like to see what he comes up with for this one!
