Distinct Count Formula

[Pranesh]

Hi All,

Is there a formula to find distinct count in a column without using COUNIF function. Currently I'm using the below formula, but it takes more time to complete 9000 rows of data i have. Can someone assist me on this pls.

IFERROR(1/COUNTIFS(A:A,A2),"")

 

[AlanY]

try replace A:A with A1:A9000 to see if that speed thing up

 

[Pranesh]

try replace A:A with A1:A9000 to see if that speed thing up

Hi AlanY,

I tried it but no improvement. Actually I'm trying to get count of unique number from a column using SUMIFS function. But SUMIFS wont give unique count, so how to modify it

 

[AlanY]

try option 5 of the follow to see if that improve

https://www.exceltrick.com/how_to/count-unique-values-excel/

 

[Pranesh]

try option 5 of the follow to see if that improve

https://www.exceltrick.com/how_to/count-unique-values-excel/

Thank AlanY. I looked into it. It will give the unique count but i want this to be in a SUMIFS formula because i need to drive this Unique count with some criteria.