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,

 

[ANONYMOUS123456]

Change D1 to: |software>

where | stands for the less than sign.<software>

If your intent is still not met after this modification, try to post a small sample here in an Excel readable form (but not an image as you did above).</software>

Sir my problem is still not solved. Actually, if I test the formula on small sample data, then it's working fine. But if I check it on a column containing 11000 entries then it has some problems. If you provide me your email address then I can send you the entire file so you can experiment on your own easily.

Regards,

 

[MARK858]

Post the formula as you have it, putting a space after any < sign in the formula and post what version of Excel you are using.
Also describe exactly what

containing 11000 entries then it has some problems

means.

 

[Aladin Akyurek]

Post the formula as you have it, putting a space after any < sign in the formula and post what version of Excel you are using.
Also describe exactly what
means.

Better to replace < with | and report this as a footnote.