Get instant live Excel expert help to learn how to find max and min in Excel?

In cell H11, add a MAX function that will show the maximum call length minutes using the Call_Length named range and in cell H12, add an INDEX function that will use the Dept named range as the array associated with a MATCH function to determine the lookup array for the longest call referenced in H11 from the Call_Length named range with an exact match.

I'm working on a time sheet for hours to be work. Then I'm displaying the hours in a schedule which is for the employees to read. If employee is scheduled for a 15 min break, I want the schedule to present the code "B" for break; if employee is scheduled for 30 min or longer, I want the text to "L" for lunch. The formula works for AM but any shifts in the PM, I get a value of "FALSE." This formula works for AM only: =IF('Master Hours'!BA16>TIMEVALUE("00:15"),"L", IF('Master Hours'!BA16<TIMEVALUE("00:14"),"", IF('Master Hours'!BA16=TIMEVALUE("00:15"),"B")))

Hi, I have two files (will upload second in a min). this file is the 'Price list', and the second is a CSV export out of our website ('CSV'). On this file the product code (column C) and the description (column D) are seperate. on the CSV, the description is a concatenation of the code then the description (i.e. SB1 - Strongbank...). 1) I want the product 'ID' which is in the column A on the CSV to show in a NEW column on the price list sheet (Between column B and C) alongside the correct product. Do you have to break the concatenation on the CSV or something??? 2) I want the updated price that is displayed in the second tab on the price list (Column K - NLS Customer Printed List worksheet) to show against the correct product on the CSV file so we can import the new prices onto the website. Should go into column Y on the CSV file. Hope this makes sense.

hi are you ready? i will explain in a min

I was just on a session for 40 MNUTES! and the "expert" did nothing, and then just left at 33 min in. So.... I need the "Totals" from row 30 for each of the tools in column one on "Taken 9-4" sheet... to automatically update on the "September" sheet under the column "Week of: 9/4" based on "Tool Name" in both sheets.

My Formula Is In Need of 15 Min Increments.

Refresh all formulas/cells/ functions in google spreadsheet periodically? I hav eot refesh sheet every 1 or 2 min.

Refresh all formulas/cells/ functions in google spreadsheet periodically? I hav eot refesh sheet every 1 or 2 min. How to do it?

Looking to be able to highlight a range of cells based off 4 drop down lists. The drop down lists are: days of the week, a list of tasks, and then a start time and an end time. I want to be able to pick the day of the week from the drop down, pick the task and pick a start time and an end time and have it highlight all the cells between the two times the color associated with each task. Thanks :) Can you just guide me in the direction I need to go? Or explain how I would go about it and I can go play around with it? I don't mind if it takes longer than 20 min

I know this will take more than 20 min. Can someone help me for 20 min with it and then I can come back later or keep working on it on my own? I'm looking to be able to highlight a range of cells based off 4 drop down lists. The drop down lists are: days of the week, a list of tasks, and then a start time and an end time. I want to be able to pick the day of the week from the drop down, pick the task and pick a start time and an end time and have it highlight all the cells between the two times the color associated with each task when I click a button. I know how to do the drop down lists and make the button, I just need the macro that would do the rest. Is there already a general one out there that I could look at and tweak to fit my needs? Thanks :)