+ Reply to Thread
Results 1 to 4 of 4

Frequency

  1. #1
    Registered User
    Join Date
    11-22-2018
    Location
    hyderabad
    MS-Off Ver
    2010
    Posts
    55

    Frequency

    Hi excel experts i like to know how to find frequency without disturbing data and no helper coloum please let me know below i am attaching file

    Thanks in Advance
    Attached Files Attached Files

  2. #2
    Forum Expert Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    4,242

    Re: Frequency

    Countifs method
    M3
    =COUNTIFS($C$3:$H$10,">="&LEFT(K3,FIND("-",K3)-1),$C$3:$H$10,"<="&-MID(K3,FIND("-",K3),4))

    Array Frequency method
    select L3:L6
    =FREQUENCY(C3:H10,-MID(K3:K5,FIND("-",K3:K5),4))

    Press Ctrl+Shift+Enter
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-22-2018
    Location
    hyderabad
    MS-Off Ver
    2010
    Posts
    55

    Re: Frequency

    Thank you so much Mr.Bo_Ry

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,488

    Re: Frequency

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 01-21-2016, 02:23 PM
  2. Replies: 3
    Last Post: 02-11-2014, 05:36 PM
  3. [SOLVED] Productsum: Highest Frequency Category, Specific Main Category, Frequency of Category
    By T86157 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-24-2012, 12:43 PM
  4. Help with frequency
    By putnum in forum Excel General
    Replies: 1
    Last Post: 12-19-2009, 04:25 AM
  5. [SOLVED] Frequency
    By Fred Roven in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-30-2006, 10:10 PM
  6. histograms - frequency and relative frequency?
    By confusedstudent in forum Excel General
    Replies: 2
    Last Post: 02-08-2006, 04:25 AM
  7. [SOLVED] Frequency Array and Bin Array-how to set up a frequency report on my project.
    By LabLost in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-31-2005, 02:05 PM

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