Search results

  1. Lutfor Rahman Shimanto

    [Solved] Lookup Table Formula to Insert Subject Names Instead of Numbers

    Thank you for your kind words! It means a lot to us. You're very welcome, Jululian! We are glad to hear the VBA solution worked well for you. Regards ExcelDemy
  2. Lutfor Rahman Shimanto

    [Solved] Lookup Table Formula to Insert Subject Names Instead of Numbers

    Dear Jululian Thanks for sharing your requirements. I reviewed your problem and found that developing such formulas using only Excel's built-in function is extremely difficult and time-consuming. So, I have created an Excel VBA User-defined function to fulfil your goal. Later, use the TRANSPOSE...
  3. Lutfor Rahman Shimanto

    [Solved] Formula to Order Product Automatically Once Every Three Months

    Dear Gary Thornton Thanks for sharing your problem with a dataset. It helped me understand the date data structure you are using. I am delighted to inform you that I have reviewed your problem and developed a complex formula using IF, OR, MONTH, DATEVALUE, LEFT, MID, and FIND functions...
  4. Lutfor Rahman Shimanto

    [Solved] Auto populate Task to calendar

    Dear, No problem! We are always here to assist. Thanks for your kind words. Your appreciation means a lot to us. Regards Lutfor Rahman Shimanto ExcelDemy
  5. Lutfor Rahman Shimanto

    [Solved] Auto populate Task to calendar

    Dear, Thanks for your query! I have reviewed your dataset and found that merged cells exist. So, if you use an array formula to populate the intended values, you might get a #SPILL! Error. Moreover, developing such formulas would be very time-consuming. So, I recommend you use the previously...
  6. Lutfor Rahman Shimanto

    [Solved] Lookup Table Formula to Insert Subject Names Instead of Numbers

    Dear Jululian It is good to see you again. Thanks for your nice words. I have reviewed your requirements, which are described in the attached Excel file. Though it seems like a day-killer problem, I am able to solve it somehow with the help of a helper column (within this range, the text font...
  7. Lutfor Rahman Shimanto

    [Solved] Auto populate Task to calendar

    Dear, Thanks for your patience! I have reviewed the problem you mentioned. You are right! The reason behind this is that you may have missed making proper cell references for JESSICA HUDSON. When you apply the formulas for a new instructor, you must adjust the formulas. Please check the...
  8. Lutfor Rahman Shimanto

    INDEX+MATCH

    Dear Roktobondhu Welcome to ExcelDemy Forum! Thanks for reaching out and sharing your problem. You are facing difficulties with an INDEX-MATCH formula. You mentioned that it works on your mobile device but not your PC, which uses Excel 2016. I have reviewed your formula and found that it is...
  9. Lutfor Rahman Shimanto

    [Solved] Highlighting Non-Unique Number Patterns in Multiple Columns

    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...
  10. Lutfor Rahman Shimanto

    [Solved] summarize the salary column

    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
  11. Lutfor Rahman Shimanto

    [Solved] summarize the salary column

    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...
  12. Lutfor Rahman Shimanto

    [Solved] summarize the salary column

    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...
  13. Lutfor Rahman Shimanto

    [Solved] Pricing a bond

    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...
  14. Lutfor Rahman Shimanto

    [Solved] Auto populate Task to calendar

    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...
  15. Lutfor Rahman Shimanto

    [Solved] Auto populate Task to calendar

    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...
  16. Lutfor Rahman Shimanto

    [Solved] Auto populate based off skill.

    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...
  17. Lutfor Rahman Shimanto

    [Solved] Auto populate based off skill.

    It is excellent you have figured it out. You are most welcome. Regards ExcelDemy
  18. Lutfor Rahman Shimanto

    [Solved] Auto populate based off skill.

    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
  19. Lutfor Rahman Shimanto

    [Solved] Extracting a Number from Strings

    You are most welcome. We are glad the solution works perfectly. Regards ExcelDemy
  20. Lutfor Rahman Shimanto

    [Solved] Pricing a bond

    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

Online statistics

Members online
1
Guests online
12
Total visitors
13

Forum statistics

Threads
311
Messages
1,378
Members
568
Latest member
WilliamHon
Top