Question on some homework I have to do

  • Thread starter Thread starter motionman04
  • Start date Start date
M

motionman04

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 t
do list these:


In the same row in Column D that "Sum of All Prices" appears in Colum
A, write "Title of Highest Priced Book". Below that cell, write
"Title of Lowest Priced Book." Below that cell, write, "Title o
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 m
out
 
Seeing as that it's homework I'll just give you a hint to do an excel
help search on VLOOKUP, INDEX, MATCH, HLOOKUP and Max and MIN. That
should be the bulk of the functions you need to get the job done. It
also might not hurt to google Excel Array formulas otherwise known as
CSE formulas.

Let me know if you really get stuck, however, you will learn more if
you do it yourself

Die_Another_Day
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HOW DO I GET A CELL TO RETURN A NEIGHBORING CELL'S VALUE 6
Complex Median Formula 0
Excel Lookup 1
Conditional Formatting using Small 1
Xml and ReadElementString 1
How to retrieve data from a table 1
Looking up a value in a different file 8
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3

Back
Top