Results 1 to 6 of 6

Calculating the interval difference between occurrences

Threaded View

  1. #1
    Registered User
    Join Date
    06-12-2012
    Location
    Goa, India
    MS-Off Ver
    Excel 2003
    Posts
    6

    Calculating the interval difference between occurrences

    Hi, I wonder if someone can help me with my issue.

    I have a column randomly filled with single digit numbers. I wanted to know if, taking the bottom empty cell as the end of range for this said column, can a formula be written to calculate the difference of occurrence of a particular number.

    Please check the attached file and check the comment in B20, for more details.

    Thanks,

    -JB.
    Attached Files Attached Files

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