Data analysis question

[bkwheat2]

I have a column of numbers. Need to determine, for each value, how many times does it appear in the column.

Any ideas??

 

[dangre]

Assuming your numbers are in column A

=COUNTIF(A:A,"*N*")

Where N=the criteria you're searching for.

 

[bkwheat2]

Actually, I'm trying to create a second column that would list each unique value in column A and how many times that value appears in column A

 

[dangre]

Let me know if this works for you.

Starting in column B1, formula can be inserted and copied down the entire column:

=COUNTIF(A:A,A1)

 

[tusharm]

See Chip Pearson's http://www.cpearson.com/excel/duplicat.htm

 

[mrchonginhk]

Use pivot table and set the value to "count"