Counting in Excel column

[ANONYMOUS123456]

Hello Everyone,
I have an excel column containing some entries. I want to check how many times each entry of the column appears in that whole column.

E.g if the A1 CELL contains "Elephant" and A2 CELL contains "Elephant Rabbit" then the count of "Elephant" in A1 should be 1 considering range A1:A2. But E.g if the A1 CELL contains "Elephant" and A2 CELL also contains "Elephant" then the count of "Elephant" in A1 should be 2 considering range A1:A2 while dragging the formula in B column.

In other words, the contents of cells should be compared wholly not partially. E.g if the A1 CELL contains "Elephant" and A2 CELL contains "Elephant Rabbit" then the count of "Elephant" in A1 should not be 2 considering range A1:A2 just because "Elephant" is existing in A2 as well. The point is cell A2 contains "Elephant" partially and "Rabbit" is also present there in A2.

Regards,

 

[mikerickson]

Try the formula = COUNTIF(A1:A2, "Elephant")

 

[MARK858]

Duplicate post of
https://www.mrexcel.com/forum/excel-questions/988279-counting-excel-column.html#post4741787

 

[ANONYMOUS123456]

Try the formula = COUNTIF(A1:A2, "Elephant")

But this formula is not working in the following scenario. Please see the following image.

 

[FDibbins]

cannot view images, please explain what is happening

 

[Tetra201]

Duplicate post here.
Solution offered.

 

[Joe4]

Please do not post the same question multiple times. All clarifications, directly-related follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #12 here: http://www.mrexcel.com/forum/showthread.php?t=99490).