ARE YOU UP TO THE CHALLENGE?
OKAY GUYS I HAVE A FEW QUESTIONS HERE TO ASK YOU EXCEL EXPERTS. THESE
ARE QUESTIONS I COULD NOT FIGURE OUT ON MY EXCEL TEST.
1. First is getting my INDIRECT function to work
What I'm trying to do is refer to the row number in a specific column
in a seperate worksheet using the value in a cell.
So I want to
basicaly display the value(a text string) in column C in
the Menu Data worksheet, using the value in cell B85 as the ROW value.
2. I'm trying to use the rank function to
rank the values in a column
in ascending order AND DESCENDING order. I got the Ascending to work as
=RANK(B51,B51:B59,0)...According to the excel help, to rank the values
in DESCENDING order I simply replace the 0 in the third argument with a
1. I tried this but it still ranks it in ASCENDING order.
3. The third and most challenging question is regarding
what I would
imagine to be a wrather complex array formula.
Here is the text the question gives:
formulas, populate the following table for each keyword.
For the word APPLE, for example, you'll have to determine: (1) the
number of times it appears in the DESCRIPTION column on the MENU DATA
tab, (2) the average price of items that have the word ""apple"" in
their description, and (3) the MEDIAN price of items that have the word
""apple"" in their description.
HINT: you'll need to use array formulas for to fill out the AVERAGE and
I think I need to use the Find function...populate an array with the
price values of all descriptions that have the word apple in them. The
problem is, description is in column D and price is in colum E. So say
we find all the rows that contain the word apple, how do we then
populate an array with their corresponding E and ROW#?
In the end I will be populating a table that looks
# of Incidences Avg. Price Median Price
I'm at a complete loss on this one. The name of the worksheet that the
menu data is on is "Menu Data".
Thank you all in advance, any help will be greatly appreciated. If I
can figure this stuff out I may just be able to land a job doing these
fun things all day!
Mlowry's Profile: http://www.excelforum.com/member.php...o&userid=25757
View this thread: http://www.excelforum.com/showthread...hreadid=391709