Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
counting number of values
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 =) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting number and text values | Excel Discussion (Misc queries) | |||
Counting number of times certain Text Values appear | Excel Discussion (Misc queries) | |||
Counting the number of values in a list between two specified valu | Excel Worksheet Functions | |||
counting rows with same values for multiple values | New Users to Excel | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) |