| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Frequency of Unique Values in a cloumn
I have over 200 values in a column, some of them are repeats. Need to
find out how many times each value is present. Thanks in advance! |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Frequency of Unique Values in a cloumn
On Sep 18, 10:54*pm, BetaDocuments wrote:
I have over 200 values in a column, some of them are repeats. *Need to find out how many times each value is present. *Thanks in advance! just thought about using Pivot Table. Got my answer! Thanks everyone! |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Frequency of Unique Values in a cloumn
On 19/09/2011 03:54, BetaDocuments wrote:
I have over 200 values in a column, some of them are repeats. Need to find out how many times each value is present. Thanks in advance! in another column, apply the formula (where a:a is the column containing the 200 values, and a1 is the cell containing the first value. copy formala down to a cell in the same row as the last value.) =countif(a:a,a1) -- Rich http://www.richdavies.com/ancestry-g...amily-tree.htm http://www.rhodes-kalithea.co.uk/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unique Values, not Unique Records | Excel Discussion (Misc queries) | |||
| Using (SUM(IF(FREQUENCY....to determine unique values | Excel Worksheet Functions | |||
| Use SUM and FREQUENCY functions to count unique items | Excel Discussion (Misc queries) | |||
| Use SUM and FREQUENCY functions to count unique items | Excel Discussion (Misc queries) | |||
| Counting unique values + frequency | Excel Worksheet Functions | |||
Linear Mode
