• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Count cells between first and last data input in a row

raiyanimv

New Member
Hi everyone,

I am trying to count the number of cells between 1st data point to last data point. There are few blank months in between which also needs to be counted. I have attached dummy file for reference. Help please....

Thanks
 

Attachments

  • Cell Counts.xlsx
    9.4 KB · Views: 3
Hi:

Use the following formula

=IFERROR(AGGREGATE(14,6,($E4:$XFD4/$E4:$XFD4)*COLUMN($E$5:$XFD$100),1)-AGGREGATE(15,6,($E4:$XFD4/$E4:$XFD4)*COLUMN($E$5:$XFD$100),1)+1,0)

Thanks
 

Attachments

  • Cell Counts.xlsx
    10.5 KB · Views: 6
Back
Top