i have one big table, need help, how do to these things funcions

1. Need to count B5 to B35 names, how meny thimes names recur.
example:
sony
philips
samusng
thomson
sony
nokia
sony
philips

and need result like this
sony 3
philips 2
samsung 1
thomson 1
etc

2. Need from all table nubers and txt find some words
example:
plaaplaa Sony pla plap lpla Sony
111sdas pla pla Sony.

And will find all Sony from this txt and cont me like this
Sony 3

Sry bad english ;) i hope u understand what i need.