jelo wrote: If that is the case, what will sorting of all four advisers will change?

Instead of using max() in a series of if statements (if rec1==first, max(rec2,rec3),rec2==first,max(rec1,rec3)...), I'm thinking it's easier to say - here's a list of everyone ranked in order. In the case of ties, it basically gives them the option to look at each faculty member and choose for themselves.

Well,
my first idea is:
find the highest score (first=max(Q1)) and with the "join" or "list" function display all members with this score,
find the second highest score (equation above) and with the "join" or "list" function display all members with this score.

But, coming back to your first question: I there are only four advisers, why isn't it sufficient just to display all 4 with their respective scores?
Students should be able to find the "best", or don't they?

Joffm

Hi,
here is a small example that displays the adviser(s) with the highest score
and the adviser(s) with the next score.





Joffm

Thanks, Joffm! This looks promising - I'll give it a try on Monday.

And to answer your question, for the 4 advisers, I think it is ok to list them all, but in the (very likely) event that we add faculty, it won't scale very well.