Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niccalo
 
Posts: n/a
Default Filter unique, and then count


I need to write a formula that filters out unique numbers in one column
lists them in another, and then counts the number of times each of
those numbers appears in the original and lists the values next to
them....I hope that meakes sense.


--
Niccalo
------------------------------------------------------------------------
Niccalo's Profile: http://www.excelforum.com/member.php...fo&userid=4344
View this thread: http://www.excelforum.com/showthread...hreadid=553672

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default Filter unique, and then count

You might wish to consider the feature Tools DataAnalysis Histogram.....

Vaya con Dios,
Chuck, CABGx3



"Niccalo" wrote:


I need to write a formula that filters out unique numbers in one column
lists them in another, and then counts the number of times each of
those numbers appears in the original and lists the values next to
them....I hope that meakes sense.


--
Niccalo
------------------------------------------------------------------------
Niccalo's Profile: http://www.excelforum.com/member.php...fo&userid=4344
View this thread: http://www.excelforum.com/showthread...hreadid=553672


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JMB
 
Posts: n/a
Default Filter unique, and then count

Another possibility is you can use Advanced Filter to get the unique records
(Data/Filter/Advanced Filter). Once you have the unique listing, check help
for the CountIf function to get the number of times each number appeared in
your original data.

I don't follow what you mean by "lists the values next to them."

"Niccalo" wrote:


I need to write a formula that filters out unique numbers in one column
lists them in another, and then counts the number of times each of
those numbers appears in the original and lists the values next to
them....I hope that meakes sense.


--
Niccalo
------------------------------------------------------------------------
Niccalo's Profile: http://www.excelforum.com/member.php...fo&userid=4344
View this thread: http://www.excelforum.com/showthread...hreadid=553672


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



All times are GMT +1. The time now is 05:41 PM.

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

About Us

"It's about Microsoft Excel"