Recent content by Lutfor Rahman Shimanto

Dear Jululian It's good to see you again. Thanks for sharing your problem with such clarity. I have reviewed your problem and devised a solution by enhancing your formula to reach your goal. Follow these steps: Select cell H2. Insert the following formula: Hit Enter. Hopefully, you have...

Dear Narg Thanks for your patience! The following Excel file provides a concise overview of the steps needed to use the bond pricing template. To use the bond pricing template effectively, follow the steps below: Input bond details: face value, coupon rate, and maturity date. Enter SOFR...

Dear, Thanks for your patience! I have reviewed the problem you mentioned. You are right! The reason behind this is that your data is not consistent. To overcome this situation, it is recommended that you insert the full name of an instructor in the Master sheet. Don't worry! I have improved...

Dear, Thanks for explaining your requirements further! I have reviewed your problem and created two complex formulas: one for populating training and course codes and another for shift times. To develop formulas that would fulfil your goal, I used the IFERROR, TEXTJOIN, TRANSPOSE, FILTER, FIND...

Dear, Thanks for your patience! We have reviewed your dataset and found many data inconsistencies, so we are having difficulties coming up with an idea. Again, as the problem seems like a new one, it would be better if you create a new thread, explain the requirements in more detail, and provide...

It is excellent you have figured it out. You are most welcome. Regards ExcelDemy

Dear Of course. You can easily do it by modifying the formula. All you need to do is to replace the <> sign with the = sign. Excel Formula: Regards Lutfor Rahman Shimanto ExcelDemy

You are most welcome. We are glad the solution works perfectly. Regards ExcelDemy

Dear Narg Thanks for reaching out and sharing your problem. We have reviewed your requirements. Hopefully, we will develop some helpful formulas; if possible, we will try to provide you with templates. When we are done, we will let you know. Good luck. Regards Lutfor Rahman Shimanto ExcelDemy

Dear Dawson Chuang, you are always welcome. Regards ExcelDemy

Dear Acway Thanks for reaching out and sharing your problem with such clarity. You want a formula to populate instructors in the Master List sheet based on the skills to perform the task from Sheet2. I have reviewed your attached dataset and found many inconsistencies. However, I have to...

Dear Dawson Chuang, you are most welcome. We are glad that the solution worked perfectly. Regards ExcelDemy

Dear Dawson Chuang Thanks for your patience and for clarifying your requirements further. I understand your requirements and have modified the previously given sub-procedure accordingly. SOLUTION Overview: Excel VBA Sub-procedure: Private Sub Worksheet_SelectionChange(ByVal Target As...

Dear MartyMcFly Welcome to ExcelDemy Forum! Thanks for reaching out and sharing your problem with such clarity. Assuming you have a cell containing values like "Money Out (£) 8.46," you want the numerical value only. You need to extract numbers from cells and insert them into new cells (this...

Dear Dawson Chuang Thanks for informing us that the previously given sub-procedure for the Baseball MLB game score results problem worked perfectly. Your appreciation means a lot to us. I have reviewed your new requirements. Now, you want a sub-procedure that will perform on the game schedules...