Forum Discussion

Deleted's avatar
Deleted
Oct 10, 2018

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...
Excel
Formulas and Functions
Macros and VBA
  • Deleted's avatar
    Deleted
    Oct 10, 2018

    Can I get the count cells to all be the total number of cells counted? instead of 1-5 it puts 5 in all of them, or 6 depending on how many rows are counted?

    • Detlef_Lewin's avatar
      Detlef_Lewin
      Silver Contributor
      Oct 10, 2018

      Matt,

       

      formula for helper column D:

      =IF(A2,SUM(D1,1),D1)

      Formula for column B:

      =COUNTIFS($D$2:$D$41,D2) 

       

      • SergeiBaklan's avatar
        SergeiBaklan
        MVP
        Oct 10, 2018

        or

        =IF(ISBLANK(A2),C1,IFNA(MATCH(FALSE,ISBLANK(OFFSET(A2,1,0,2000)),0),COUNTA(B2:B2000)))

        but it depends on how the list of companies ended. Here I assume there are only blank cells after it.

         

Resources