Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|