I don't know why but for some reason my brain isn't wanting to work anymore and I'm having an extremely hard time trying to get this assignment done. For the life of me I can't remember how to do nested functions like Match withine08m2june_CaloviDoveAnn.xlsx Index or 3-D formulas. Any help with this would be very much appreciated. The parts I've spent over 5 hours on trying to figure out are listed below..
-------- Use the nested MATCH function within the INDEX function in cell B40 to identify the date for the highest temperature. the data set may contain several identical highest temperatures, but the nested function will identify the first date containing the match.
------- Use a nested MATCH function within the INDEX function in cell C40 to identify the date for the lowest temperature.
-------- Use a Web browser to go to www.wunderground.com, a weather Web site. Locate and click the HISTORY DATA LINK below the local weather menu, and then do a search for OKC. Copy the URL, and then create a hyperlink to this web page for cell A3 in the OKC worksheet. Add a Screen-tip stating Click to see weather history for Oklahoma City.
------- Enter the following 3-D formulas in the appropriate cell in the Summary worksheet:
-------- Calculate the highest temperature from the three cities for 6/1.
------- Calculate the lowest temperature from the three cities for 6/1.
-------- Enter a nested IF function in cell C6 to determine which city had the highest temperature. Remember to enclose city names in double quotation marks.
-------- Enter a nested IF function in cell E6 to determine which city had the lowest temperature.
------- Enter formulas in the shaded Monthly Records section (below the daily data) to identify the highest and lowest temperatures. Enter nested INDEX and MATCH functions to identify the dates and cities for the respective highest and lowest temperatures.
Bookmarks