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 =) |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 =) |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
counting number of values
Thanks Bernie. Sorry I should have asked if there is a way of displaying this
data "without" the use of a pivot table. Thanks anyway. Mark. "Bernie Deitrick" wrote: 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 =) |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
counting number of values
Hi Mark,
Try this, Go to DataFilterAdvanced filter Check copy to another location Set your list range ($A$1:$A$100 e.g.) Set your copy to location ( just a single cell, $B$1 e.g.) Check unique records only and OK out put this formula in C1 and drag down as far as is needed (or just double click on the fill handle) =COUNTIF(A:A,B1) HTH Martin "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 =) |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
counting number of values
Mark,
<Sigh "I would really like to drive this nail into that board _without_ using my hammer." Learn to use your tools effectively - Excel is your tool, and Pivot Tables are one of the most powerful features of it. Even if you are a new user, there is no time like the present to start using Pivot Tables. Bernie "Mark" wrote in message ... Thanks Bernie. Sorry I should have asked if there is a way of displaying this data "without" the use of a pivot table. Thanks anyway. Mark. "Bernie Deitrick" wrote: 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 =) |
Reply |
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) |