Hi lea See if this helps. Sunny
In cell D3 enter =INDEX(A:A,MATCH(E3,B:B,0)) Sunny
Hi Ryan I am re-attaching the file again. Please try. Sunny
Hi Ryan Give this a try. Sunny
Depending on the graph, you can use either =IFERROR(AverageIf(B2:B13,"<>0"),0) or =IFERROR(AverageIf(B2:B13,"<>0"),NA()) Hope...
Hi Chris Thanks for your feedback. Glad to know it is working for you. Cheers Sunny
Hi Chris Give this a try. The formula is in column F. It will extract the part number based on the Molder (column A) and yesterday's date (cell D1)...
Hi Gavin Can you show us your expected results? Show us the formulas you are expecting in the respective cells. It will be easier to understa...
Hi Chris What is it that is not working? Can you give an example of which cell is not correct and what is the expected value? I noted that you a...
Hi Gavin There is no attachment.
Hi Kenneth Most likely you place the codes in the wrong module. In your case (auto format when cell change) the codes should be place in the wor...
Hi Andy Without knowing your cut-off date for the 6 months, you can try any of the formulas below. Change the date if necessary. =SUMIFS(tbl_4[C...
Hi Andy Maybe I am not too clear what you wanted. You want to sum all contracted hours of all employees that have left. Try this on sheet1 =SUMI...
Hi Andy Hope I understood you correctly. This is what I am doing. If there is a date left, checking to see how many months within the year did t...
Hi Andy Can you give an example on how to calculate the contracted hours for one employee? What is the expected result? The notional 36 hrs is f...