S
S
My data:
Col 1
Apples
Oranges
Oranges
Bananas
Apples
I'm trying have excel show the text "Apples" in one col & the count "2" in
another col; same with oranges and bananas. I don't know if it is the blank
cell that is causing errors but I have tried LARGE, VLOOKUP, MATCH and am not
having any luck.
Thank you in advance
Col 1
Apples
Oranges
Oranges
Bananas
Apples
I'm trying have excel show the text "Apples" in one col & the count "2" in
another col; same with oranges and bananas. I don't know if it is the blank
cell that is causing errors but I have tried LARGE, VLOOKUP, MATCH and am not
having any luck.
Thank you in advance