Search results

Dear Artkitthana Welcome to ExcelDemy Forum! Thanks for sharing your problem with such clarity. I have reviewed your requirements and improved the existing sub-procedure to fulfil your goal. Please check the following: Improved Excel VBA Sub-procedure: Sub Test0() Dim rall As Range, r...

Dear Jululian, Thank you for your kind words! You are very welcome. We are glad the solution works for you and has a significant impact. Regards ExcelDemy

Dear Jululian Thanks for your kind words! Your appreciation means a lot to us. If you want the interval, for example, 501 to 1000, 1001 to 1500, and so on, you need to make some changes. Within the ISTEXT function, first, you must modify ROW(1:21) so that it iterates through rows 1 to 21 (it...

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...

Dear Dawson Chuang Thanks for your patience! I was able to get the data from your shared link. I have reviewed your requirements and found that you were right. So, I improved the existing algorithm and developed a new sub-procedure to fulfil your goal. SOLUTION Overview: Excel VBA...

Dear, Please share the Excel file through OneDrive, as I cannot open it. Regards Lutfor Rahman Shimanto ExcelDemy