Hi Lea Try this. It is an array formula so press CTRL+SHIFT+ENTER instead of ENTER to complete the formula. In cell T3 enter =MIN(IF($J$2:$R$2="...
Hi Hemanshu You can refer to this article here: Once you find the phrase, you can then do a VLOOKUP from your list to get the Assignee. H...
Hi Lea Assuming your data is in the range A1:A10 and their values are 0 and above (no negative values). =SMALL(A1:A10,COUNTIF(A1:A10,0)+1) I ...
Hi Justin Try =TEXT(A1,"ddmmyy") Sunny
Hi Kasonde If your data starts from A1, then the codes from my post #2 above should work for you. Good luck. Sunny
Hi Kim Glad to know you got it sorted out. Sometimes Excel can behave in an unexpected way. Cheers
Hi Ric Maybe I am not too clear about what you wanted. It would be better if you can attach what is your expected result, preferably an Excel fi...
Hi Kim Try this =LOOKUP(2,1/(I12:P12<>""),I12:P12) Sunny
Hi Ric One way is to copy-paste a linked picture of the range and then move it onto your chart. Hope this helps. Sunny
Hi Dennis You should consider using a Pivot Table in this situation. It is easier than using the SUMIFS function. Please refer attached for both...
Hi Melinda Try this. 1) In cell AW16 enter =IF(COUNTIF($BD16:$BL16,AP16)>0,"Y","") and copy to the other cells. 2) Excel consider blank ce...
Hi Lea in cell B1 enter =SUBSTITUTE(SUBSTITUTE(MID(A1,IFERROR(FIND("(W",A1)+1,FIND("(",A1)+1),50)," ",""),")","") Hope thus helps. Sunny
Hi Alan You can also consider using Data Validation to prevent duplicate entries. Hope this helps. Sunny
You could modify the formula to check if the cell is blank before adding. =AF16+IF(AF21="",0,AF21) But I would prefer your formula in AF21 to sh...
Hi Alex I have no problem creating a Pivot Table from your data or even summing the time. Person 1 is 1:22 (hh:mm) Person 2 is 2:01 Total ...