counting number of values
Mark,
Select your column of numbers - make sure that there is a header - and then
choose Data / Pivot table and click OK. This will create a new sheet with
a blank pivot table. Drag the button with the header word onto both the row
area and the data area, and you will get a table of the count of every
unique item in your column.
HTH,
Bernie
MS Excel MVP
"Mark" wrote in message
...
Hi, I am glad I have discovered this post, because I am new to excel and
on a
steep learning curve due to the requirements of my work.
I have a large one-column list of values which includes duplicate values.
i
would like to calculate and display the number of times each value
occurrs.
for example.
1
2
4
4
6
The result should display something like 1=1, 2=1, 4=2, 6=1.
Any help would be appreciated.
Thanks. Mark =)
|