Count cells from Company to Company.

Company  402 has 5 lines before Company 421. Want to enter the line count either in formula or Macro. Any help would be appreciated.     Count 1 Company Number:   402 5   ABC MANUFACTU...