Two questions:
1. i am using match and index in a forumla. I am looking up the max value in one row and returning the persons name with the highest average in the selected cell. It works however for someone where no imput has been given to compute the average in the average column it results divided by 0. When it looks up the max for the column it finds this over the greatest value. How do I exclude forumlas from the result and find the highest value?

2. If there are two values or more equal to each other (Ex: 3 people have a 90 average) it returns the name of the first one it finds is there a way to return all names seperated by a : just wondering?

Thanks in advance for any help.