+ Reply to Thread
Results 1 to 4 of 4

Filtering Based on Frequency

  1. #1
    Forum Contributor
    Join Date
    10-09-2015
    Location
    Canada
    MS-Off Ver
    Office Home and Student 2021 for Mac
    Posts
    170

    Filtering Based on Frequency

    Hi all,

    I'm currently working with a fairly large data set which I have transposed into a table that looks the attached file.

    What I'm trying to do is keep only instances where the same names appears 3 times (as I would like to take the average of the highest 3 grades over 3 courses, but some students have only taken two of those courses, or none at all). Essentially, I would like to keep instances of names that appear across all 3 courses and remove ones that appear in 2 or fewer.

    Any suggestions would be greatly appreciated.

    Thank you!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Filtering Based on Frequency

    Try
    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    03-14-2017
    Location
    Japan
    MS-Off Ver
    2010
    Posts
    11

    Re: Filtering Based on Frequency

    Hi Darko,
    Would also like to know the answer to your inquiry. Bookmarking this with a trial formula.
    G2(drag till G19) =IF(COUNTIF(B$2:B$19,B2)<3,"",MAX(C2:E2))
    H2(drag till H19) =IFERROR(AVERAGEIFS(G$2:G$19,B$2:B$19,B2),"")

    Regards,Manang

  4. #4
    Forum Contributor
    Join Date
    10-09-2015
    Location
    Canada
    MS-Off Ver
    Office Home and Student 2021 for Mac
    Posts
    170

    Re: Filtering Based on Frequency

    Thanks manangmercy2017 and jindon, both worked like a charm!

+ 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. [SOLVED] Filtering FREQUENCY on >1 criteria
    By the3rdParty in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-16-2015, 06:17 PM
  2. How to Calculate frequency based on other columns
    By antexity in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-03-2015, 12:57 PM
  3. Auto populate based on frequency
    By FredJoe699 in forum Excel General
    Replies: 2
    Last Post: 06-16-2014, 12:20 AM
  4. [SOLVED] sum frequency based on certain dates
    By L_Espina in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-11-2014, 10:08 AM
  5. [SOLVED] Need help filtering data by filtering based on the last digit of a column/true statement
    By Stephen R in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-11-2014, 07:43 AM
  6. How can I use Countif based on the frequency of a certain column?
    By dcolceriu in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-22-2012, 05:44 PM
  7. Ranking based on frequency
    By mac_see in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-01-2006, 12:55 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1