I need help with a count if or something that is probable easy for ya'll

[stewie1234]

I am working with a huge data set and was wondering would a dcountif work if I need a column which has random loan numbers in it give me back the count of how many times it is in the column. Their might be four or two or 1. I have another formula counting if there is a 1 to give me one answer and anything else another, I just don't know if a dcountif would be best or not. Thanks in advance for all your help!!!!!!!!!!!!!!

 

[BatmanExcel1029]

Sumproduct tends to be easier to deal with large data sets. Typically it is:
=Sumproduct(dataset)*(dataset)

 

[stewie1234]

Sumproduct tends to be easier to deal with large data sets. Typically it is:
=Sumproduct(dataset)*(dataset)

Thanks but will this give me a count of how many times a unique number is in the column? I have a column that looks like this

456789
456789
123456
021454
0134785
012121
012121

And I need the formula to count how many times the number shows up in the column. Thanks for your help!

 

[CyrusTheVirus]

And I need the formula to count how many times the number shows up in the column. Thanks for your help!

To count how many times 'WHAT' number shows up?

What is your expected answer in post No. 3?

 

[stewie1234]

To count how many times 'WHAT' number shows up?

What is your expected answer in post No. 3?

How many times there are duplicates in the column. I'm assuming just a countif but I didn't know if there was a better way

 

[BatmanExcel1029]

For the unique count, go to YouTube for excellsfun channel, ctrl+shift+enter array formulas video 18. You will need an array formula to set the data set in an array and the formula differentiate the unique values.

 

[CyrusTheVirus]

Will this work?

=COUNT(A1:A8)-SUMPRODUCT(--(FREQUENCY(A1:A8,A1:A8)>0))

 

[Aladin Akyurek]

How many times there are duplicates in the column. I'm assuming just a countif but I didn't know if there was a better way

25
25
60
80
90
80

Note that this set consists of true numbers (not text numbers). What is the result you want to see for this set?