Question : excel count unique dates
Answered by : vastemonde
=COUNT(UNIQUE(B5:B14))Source : | Last Update : Thu, 25 Mar 21
Question : count unique values excel
Answered by : santosh-pal
=SUMPRODUCT(1/COUNTIF(data,data))Source : | Last Update : Tue, 09 Mar 21
Question : count unique values in excel based on a column condition
Answered by : ugliest-unicorn-v13cwrs5xdav
=SUM(--(LEN(UNIQUE(FILTER(B6:B15,(C6:C15=H6)*(D6:D15="june"),"")))>0))Source : https://exceljet.net/formula/count-unique-values-with-criteria | Last Update : Thu, 20 Jan 22