I have a column with text and blank cells. I need a formula that will not
only retrieve the names of the unique text values but also give me a count
how many times they appeared. Example:

Col A
[blank]
Apples
Pears
[blank]
Apples
Oranges

Apples 2
Pears 1
Oranges 1

It could be in 2 different columns...

Thanks in advance!