Results 1 to 13 of 13

Code to count and then reset to 0 or blank out.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-22-2005
    MS-Off Ver
    Office 365
    Posts
    342

    Code to count and then reset to 0 or blank out.

    Hey,

    Not sure if this is possible.

    I have a simple count function in D3 - every time there is an entry in A5:A150 it counts up by 1.

    =COUNT(A5:A150)

    In A5 thru A150 will be a date, is there a way to have D3 reset to 0 and start counting again once the date is not the same as the cell above?

    Is there then a way to capture the number in D3 prior to it reseting to 0 ?
    Last edited by SVTF; 04-12-2010 at 08:12 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1