didnt work for me... let me try to explain better what I have since it
wont let me post my excel file..

I have a column with Names... some columns after with quarterly
numbers, a column which adds all those sales(total column), a goal
column, and then a column which calculates the percent of the goal the
person has reached. I need a column which will display the name of the
person with the highest perecentage goal, and then have that number
show up.


--
spezialize
------------------------------------------------------------------------
spezialize's Profile: http://www.excelforum.com/member.php...o&userid=28628
View this thread: http://www.excelforum.com/showthread...hreadid=482924