For the homework, I had to make a list of ny times best seller list,
with the prices, number of weeks on the list etc. Then, I was asked to
do list these:


In the same row in Column D that "Sum of All Prices" appears in Column
A, write "Title of Highest Priced Book". Below that cell, write,
"Title of Lowest Priced Book." Below that cell, write, "Title of
Longest Best Selling Book." In the corresponding cells in Column E,
write functions that will get the correct titles to appear.

I'm not even sure what formulas to use for this, can someone help me
out?


--
motionman04
------------------------------------------------------------------------
motionman04's Profile: http://www.excelforum.com/member.php...o&userid=36243
View this thread: http://www.excelforum.com/showthread...hreadid=560194