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.


--
MIKE0W
------------------------------------------------------------------------
MIKE0W's Profile: http://www.excelforum.com/member.php...o&userid=21465
View this thread: http://www.excelforum.com/showthread...hreadid=396726