+ Reply to Thread
Results 1 to 7 of 7

Formula for calculation of occurrence a value in continuation and for interval as well a

  1. 04-13-2018, 01:52 AM #1
    jd16
    jd16 is offline
    Registered User
    Join Date
    10-06-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    87

    Post Formula for calculation of occurrence a value in continuation and for interval as well a

    Hi Everyone,

    Guys Please help me to finding a formula for calculation of occurrence of a value in a column and also for it's intervals of occurrence,
    all details are given on spreadsheet which is attached with this post.

    Thanks & Regards
    Attached Images Attached Images
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-13-2018, 02:36 AM #2
    shukla.ankur281190
    shukla.ankur281190 is offline
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,937

    Re: Formula for calculation of occurrence a value in continuation and for interval as well

    Try

    D2
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    E2
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

    Copy down..!
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Reply With QuoteRegister To Reply
  3. 04-13-2018, 11:39 PM #3
    jd16
    jd16 is offline
    Registered User
    Join Date
    10-06-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    87

    Re: Formula for calculation of occurrence a value in continuation and for interval as well

    Thanks a lot for a very prompt response and valuable help Sir, In my original datasheet i've some different data, let me try with it and will revert to you soon. Added
    Last edited by AliGW; 04-14-2018 at 12:52 AM. Reason: Unnecessary quotation removed.
    Reply With QuoteRegister To Reply
  4. 04-14-2018, 12:52 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,916

    Re: Formula for calculation of occurrence a value in continuation and for interval as well

    Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

    For normal conversational replies, try using the QUICK REPLY box below.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  5. 04-14-2018, 10:44 PM #5
    jd16
    jd16 is offline
    Registered User
    Join Date
    10-06-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    87

    Re: Formula for calculation of occurrence a value in continuation and for interval as well

    sure mam
    Reply With QuoteRegister To Reply
  6. 04-14-2018, 11:54 PM #6
    jd16
    jd16 is offline
    Registered User
    Join Date
    10-06-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    87

    Re: Formula for calculation of occurrence a value in continuation and for interval as well

    thanks a lot sir, it's working fine with my original data with some changes according to data
    And if it is possible I need some more help from you, Earlier we have done with vertical datas,
    Now we need it to do with Horizontal data with two different case.
    Please throw some light on it too.

    Heartily Thanks,
    Warm Regards
    JD16
    Attached Images Attached Images
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 04-15-2018, 04:39 PM #7
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,916

    Re: Formula for calculation of occurrence a value in continuation and for interval as well

    This thread is solved. The OP has started a new thread for the follow-on query.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Cumulative Bonus calculation which stops at an interval for previous month
    By Deenah in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-06-2018, 03:49 AM
  2. How to use a number to change interval range in calculation
    By oogoldenchildoo in forum Excel General
    Replies: 4
    Last Post: 03-08-2016, 11:12 PM
  3. Time interval - Electrical demand calculation
    By pcmystery in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-18-2015, 02:46 PM
  4. How to make data calculation through a specified date interval within a table
    By nooredein in forum Excel General
    Replies: 5
    Last Post: 01-29-2015, 05:52 PM
  5. Continuation of formula doesn't work
    By mitjakleczka in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-29-2014, 01:17 PM
  6. Filter column data by time interval and count the number of records for each interval
    By erictamlam in forum Excel General
    Replies: 1
    Last Post: 04-29-2014, 04:42 AM
  7. [SOLVED] How to make an interval and search for values within that interval?
    By gamoerma in forum Excel General
    Replies: 12
    Last Post: 10-13-2013, 10:33 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1