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