Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 19th 11, 03:54 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2008
Posts: 18
Default 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   Report Post  
Old September 19th 11, 04:00 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2008
Posts: 18
Default 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   Report Post  
Old October 6th 11, 02:04 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2011
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Unique Values, not Unique Records steph44haf Excel Discussion (Misc queries) 1 May 12th 10 07:52 PM
Using (SUM(IF(FREQUENCY....to determine unique values Ivor Davies[_2_] Excel Worksheet Functions 2 November 6th 09 03:44 AM
Use SUM and FREQUENCY functions to count unique items Connie Excel Discussion (Misc queries) 3 October 19th 06 09:02 PM
Use SUM and FREQUENCY functions to count unique items Connie Excel Discussion (Misc queries) 0 October 19th 06 08:11 PM
Counting unique values + frequency Mike Ferguson Excel Worksheet Functions 3 November 24th 04 08:31 AM


All times are GMT +1. The time now is 02:18 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017