Hi Frans Thanks for your compliment I will try to help out if I am able to. Answer 1: It is a bit difficult for me to explain ARRAY formulas as ...
Hi Frans Sorry I attached the wrong file in the previous post. Please refer this one. I have added a 3rd method for you. Cheers Sunny
Hi Hans See if this is what you are looking for. There are two suggestions. Suggestion (1) I made use of the row numbers that you already extrac...
Try this =IF(A1<TIME(6,0,0),"Need","W/H") Sunny
Hi abellon See if this is what you need. Basically I am using a formula to find which column (header) you selected and then using array formula...
Hi Hooi Thin As a workaround, you can try moving the SR Asset Serial Number field in your PivotTable row labels to the top. Click the Filter & ...
Hi See if this is what you want. Sunny
Try this =IF(OR(M2="",M2="void"),"",IF(M2-J2<=30,1,0)) Sunny
Hi RyujinLegacy See if this is what you wanted. Sunny
Very likely your data table name is not MosaiqManager but something else. Try renaming your data table to MosaiqManager
Hi melissa I assume you wanted a text box that can display more than one line. From the text box property, set Multiline to True To close the Us...
Hi Jacqueline Attached is the revised print to PDF file. It uses Data Validation to select the ID and then print. The second file is a utility t...
Hi Learning2 You did ask that the macro to look into cell A1 so that's what I did. For example the cell A1 could be inputted with 1234*, B2 wou...
Hi Jacqueline See if this helps. I have added a macro that will print the required sheets for each student to individual PDF. It will read th...
Hi mey Refer attachment. I basically need to extract the total hours from your time and convert the minutes portion to decimal. Since the hou...