+ Reply to Thread
Results 1 to 20 of 20

help nedeed for a filtering formula

  1. #1
    Forum Contributor
    Join Date
    10-25-2013
    Location
    türkiye
    MS-Off Ver
    Excel 2021
    Posts
    130

    help nedeed for a filtering formula

    I have a list which has NAMES (of students), MARKS (for each course), PREFERENCES ( of students - names of the courses) and QUOTA( for each course).
    I need an array formula to choose a course for each student by considering the following rules.

    1. the student with a lower mark for a course comes first
    2. if two or more students have the same marks the smaller preference number (for the same course) has the priority (for the same course)
    3. number of studenths for any course can not exceed quota given for each course.

    there is an attached sample file.

    IF YOU HELP, I WILL APPRECIATE YOU.
    THANK YOU EVERYBODY.
    Attached Files Attached Files

  2. #2
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: help nedeed for a filtering formula

    Hi.

    Is this in essence much different to this post:

    http://www.excelforum.com/excel-gene...ml#post3882840

    ?

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  3. #3
    Forum Contributor
    Join Date
    10-25-2013
    Location
    türkiye
    MS-Off Ver
    Excel 2021
    Posts
    130

    Re: help nedeed for a filtering formula

    thank you for your interest.
    they are similar but in that post there is only one mark for each student, in this post students have five marks for ecah of their preferences.
    So we have to consider each of these marks for each course to determine which student can take which course.

  4. #4
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: help nedeed for a filtering formula

    Why have you allocated course a to name3 and name5? Why not name5 and name6, who both scored 29 for this course (name3 scored 34)?

    Regards

  5. #5
    Forum Contributor
    Join Date
    10-25-2013
    Location
    türkiye
    MS-Off Ver
    Excel 2021
    Posts
    130

    Re: help nedeed for a filtering formula

    yes you are right.
    course a should be given to name5 and name 6.

  6. #6
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: help nedeed for a filtering formula

    Can you double-check all of your results? It's very difficult when you have to first check someone else's data for errors.

    And what course should name3 now be allocated?

    Can you also add an example to your workbook which demonstrates your second criterion:

    Quote Originally Posted by mehmetics View Post
    2. if two or more students have the same marks the smaller preference number (for the same course) has the priority (for the same course)
    so that it's clear?

    Regards
    Last edited by XOR LX; 11-27-2014 at 12:21 PM.

  7. #7
    Forum Contributor
    Join Date
    10-25-2013
    Location
    türkiye
    MS-Off Ver
    Excel 2021
    Posts
    130

    Re: help nedeed for a filtering formula

    (I hope) this time sample distribution is true.

    name course
    name1 c
    name2 d
    name3 g
    name4 d
    name5 a
    name6 a

  8. #8
    Forum Contributor
    Join Date
    10-25-2013
    Location
    türkiye
    MS-Off Ver
    Excel 2021
    Posts
    130

    Re: help nedeed for a filtering formula

    sorry how can I attach a new file ?
    a.jpg

  9. #9
    Forum Contributor
    Join Date
    10-25-2013
    Location
    türkiye
    MS-Off Ver
    Excel 2021
    Posts
    130

    Re: help nedeed for a filtering formula

    sorry I could not attach a new file
    a.jpg

  10. #10
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: help nedeed for a filtering formula

    Why can't you attach a new file?

    Regards

  11. #11
    Forum Contributor
    Join Date
    10-25-2013
    Location
    türkiye
    MS-Off Ver
    Excel 2021
    Posts
    130

    Re: help nedeed for a filtering formula

    I can not find the attachment button on the toolbar
    Last edited by mehmetics; 11-27-2014 at 01:26 PM.

  12. #12
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: help nedeed for a filtering formula

    And how did you manage to attach a file to your original post?

    Regards

  13. #13
    Forum Contributor
    Join Date
    10-25-2013
    Location
    türkiye
    MS-Off Ver
    Excel 2021
    Posts
    130

    Re: help nedeed for a filtering formula

    while startin a new post screen there was a such a button but now in this reply screen i can not see it

  14. #14
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: help nedeed for a filtering formula

    Try clicking on Go Advanced.

    Regards

  15. #15
    Forum Contributor
    Join Date
    10-25-2013
    Location
    türkiye
    MS-Off Ver
    Excel 2021
    Posts
    130

    Re: help nedeed for a filtering formula

    editing toolbar is this
    b.jpg

  16. #16
    Forum Contributor
    Join Date
    10-25-2013
    Location
    türkiye
    MS-Off Ver
    Excel 2021
    Posts
    130

    Re: help nedeed for a filtering formula

    ok thank you.
    I found it.
    Attached Files Attached Files

  17. #17
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: help nedeed for a filtering formula

    Thanks, but I still don't understand your data.

    Why are pref1 and pref2 for name1 both "c"? Can you choose the same course multiple times?

    Regards

  18. #18
    Forum Contributor
    Join Date
    10-25-2013
    Location
    türkiye
    MS-Off Ver
    Excel 2021
    Posts
    130

    Re: help nedeed for a filtering formula

    sorry you are right again.
    it is not allowed to choose the same course multiple times.
    so change pref2 for name1 to "h"?

    I hope it does not change the result.

  19. #19
    Valued Forum Contributor
    Join Date
    11-22-2014
    Location
    Arizona, USA
    MS-Off Ver
    Office 365
    Posts
    973

    Re: help nedeed for a filtering formula

    Disregard you found it...lol
    -If you think you are done, Start over - ELeGault

  20. #20
    Forum Contributor
    Join Date
    10-25-2013
    Location
    türkiye
    MS-Off Ver
    Excel 2021
    Posts
    130

    Re: help nedeed for a filtering formula

    although you say " I don't understand your data"
    this shows that you understand my data better than me.

    I think the attached file is more illustrative.
    Attached Files Attached Files
    Last edited by mehmetics; 11-27-2014 at 03:50 PM.

+ 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] 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
  2. [SOLVED] Easy filtering method via vba/formula/advanced filtering?
    By jedemeyer1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-10-2014, 12:35 AM
  3. Filtering on a formula
    By Timmy Mac1 in forum Excel General
    Replies: 1
    Last Post: 11-09-2005, 03:30 PM
  4. [SOLVED] Filtering dates using a formula
    By Sue in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  5. [SOLVED] trouble filtering a list. Why isn't column filtering?-number of criteria
    By Pat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-18-2005, 11:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1