Md. Sourov Hossain Mithun

About author

Md. Sourov Hossain Mithun, an Excel and VBA Content Developer at Softeko's ExcelDemy project, joined in October 2021. Holding a Naval Architecture & Marine Engineering degree from BUET, Mithun showcases expertise during his two-year tenure. With over 200 published articles on Excel topics, he earned a promotion to Team Leader, excelling in leading diverse teams. Mithun's passion extends to Advanced Excel, Excel VBA, Data Analysis, and Python programming, contributing significantly to the innovative and dynamic environment of ExcelDemy at Softeko.

Designation

Excel and VBA Content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.

Education

B.Sc. in Naval Architecture And Marine Engineering, Bangladesh University of Engineering and Technology

Expertise

Data Analysis, Content Writing, Google Sheets, Microsoft Office, Excel VBA, Excel Power Query, AutoCAD, Illustrator, Canva.

Experience

  • Excel and VBA Content Developer, ExcelDemy
  • Published 200+ articles on basic, advanced Excel, and VBA Macro.
  • Team Leader, ExcelDemy
Guided several teams to generate articles on basic, advanced Excel.
  • Team Leader, OfficeWheel
  • Guided a team to publish articles on Google Sheets.

Summary

  • Currently working as an Excel and VBA Content Developer at ExcelDemy project of Softeko.
  • Started technical content writing on Excel & VBA in October 2021 and later promoted to Team Leader for ExcelDemy and OfficeWheel projects.

Latest Posts From Md. Sourov Hossain Mithun

0
How to Insert Greater Than or Equal to Symbol in Excel (5 Quick Methods)

Let's use the following dataset that represents a student’s obtained grade and marks range to demonstrate how to insert the "greater than or equal" sign. The ...

0
How to Add a Stacked Fraction in Excel (5 Simple Ways)

Excel stores fraction values as decimals in number format by default. But sometimes we may need to represent it as a stacked fraction for different purposes. ...

0
How to Send an Editable Excel Spreadsheet by Email (3 Quick Methods)

We can easily send Excel files as attachments from email. But that is not feasible always for some particular cases, like you may want to send only one ...

0
How to Apply Slice Theme in Excel

Excel has Theme feature by which we can change the presentation of our worksheets with a lot of customizations. There are several built-in themes and also you ...

0
How to Convert Decimal to Minutes and Seconds in Excel (3 Easy Ways)

Excel by default stores time in decimal format. But there are several ways by which we can convert it to hours, minutes, or seconds. Also, Excel has many ...

0
How to Round a Formula with SUM in Excel (4 Simple Ways)

We can round a value or can round the output of formula in Excel. So of course we can round a formula with the SUM function too. There are several ways to do ...

0
How to Remove Protected View in Excel (3 Quick Methods)

To explore the methods, we’ll use the following dataset representing the hourly rate of some ExcelDemy content writers. Method 1 - Remove Protected ...

0
How to Backup Excel Files to a Flash Drive (4 Useful Methods)

There are many risk factors for which we can lose our essential Excel files. So it’s vital to keep backups. Excel offers some exclusive ways to create a ...

0
How to Calculate Cross Correlation in Excel (2 Suitable Ways)

In statistical analysis, calculating cross-correlation is a common task. It may be quite tricky and time-consuming if you try to find it in the traditional ...

0
How to Transpose Rows to Columns Using Excel VBA (4 Ideal Examples)

For transposing rows to columns in Excel, there are many ways but we can do it smartly with lots of customization using VBA. From this article, we’ll learn 4 ...

0
How to Convert CSV to XLSX (4 Quick Methods)

Are you worried about your CSV file converting into XLSX file? No worries! You have come to the right place. There are several ways to do it but here I’ll show ...

0
Excel VBA: ExportAsFixedFormat PDF with Fit to Page (3 Examples)

We can easily export sheets as PDFs in Excel by using the default option. But using VBA you can export with a lot of customizations, Fit to Page is one of ...

0
[Fixed!] Excel SUM Formula Is Not Working and Returns 0 (3 Solutions)

To explore the solutions, use the following dataset that represents some ordered Smartphones and their Quantity. Issue 1 - Number Stored as Text ...

0
How to Split Text in Excel Using a Formula (5 Easy Ways)

To showcase the methods, we will use a simple dataset listing some items of clothing and their corresponding colors, and apply a formula to split each item ...

0
How to Move One Cell Down Using Excel VBA (4 Methods)

The dataset represents the sales of various salespersons in different regions. Method 1 – Using VBA to Move One Cell Down from an Active Cell ...

Browsing All Comments By: Md. Sourov Hossain Mithun
  1. Hello CJ, thanks for your feedback.

    Just skip the percentage if it doesn’t get relevant, the formula and procedures are the same.

  2. Hello JEMAIMAH OMAKEN, thanks for your feedback.
    Visit our site to explore more articles that will work on Excel 2013. As 2013 is not so older version so you will find no major differences.

  3. Hello Jane, thanks for your feedback.
    Yes, it’s possible, just add the column on the left and apply the commands as I applied.

  4. Hello ROY, thanks for your feedback. You have got a nice trick. I hope, it will help others.
    But if the reverse order affects the other calculation of any user then maybe the alternative methods are more feasible.

  5. Hello ANDY S, thanks for your feedback.
    I hope the following codes will be helpful for your problem.

    Sub Print_Button_for_DropDown()

    Sheets(“Data”).Range(“$B$4:$D$11”).AutoFilter Field:=2, Criteria1:=Range(“F4”).Value
    Sheets(“Data”).Select
    Sheets(“Data”).PrintOut

    End Sub

    Here, I have made a drop-down list in Cell F4 for the locations. Keep this cell in that sheet where the print button is located, that means the active sheet. You can change the reference and range in the codes according to your dataset.

  6. Reply Md. Sourav Hossain Mithun
    Md. Sourov Hossain Mithun Feb 25, 2024 at 3:59 PM

    Hello JULIA MANDEVILLE,
    We hope you are doing well. You got the exact mismatch between the code on the article and the code on the Excel file. That was very unfortunate and we really appreciate your feedback, thank you so much. We have fixed it on the article and Excel file.

    Thanks and regards,
    Md. Sourov Hossain Mithun
    Team ExcelDemy

  7. Reply Md. Sourav Hossain Mithun
    Md. Sourov Hossain Mithun Oct 29, 2023 at 11:45 AM

    Hello MEGAN M,
    Hope, you are doing well. Here’s the modified code below that will spell only whole numbers. Also, it will extract the whole number before spelling, if you insert decimal numbers.

    
    Option Explicit
    Function spelling_number(ByVal given_number)
        Dim us_dollars, temp
        Dim count
        ReDim Position(9) As String
        Position(2) = " Thousand "
        Position(3) = " Million "
        Position(4) = " Billion "
        Position(5) = " Trillion "
        given_number = Trim(Str(given_number))
        
        ' Extract the integer part of the number
        Dim integerPart As Double
        integerPart = Int(given_number)
        
        count = 1
        Do While integerPart <> 0
            temp = GetHundreds(integerPart Mod 1000) ' Process the last three digits
            If temp <> "" Then us_dollars = temp & Position(count) & us_dollars
            integerPart = Int(integerPart / 1000) ' Remove the last three digits
            count = count + 1
        Loop
        
        ' Check if the result is an empty string, and if so, set it to "Zero"
        If us_dollars = "" Then
            us_dollars = "Zero"
        End If
        
        spelling_number = us_dollars
    End Function
    
    Function GetHundreds(ByVal given_number)
    Dim output As String
    If Val(given_number) = 0 Then Exit Function
    given_number = Right("000" & given_number, 3)
    If Mid(given_number, 1, 1) <> "0" Then
    output = GetDigit(Mid(given_number, 1, 1)) & " Hundred "
    End If
    If Mid(given_number, 2, 1) <> "0" Then
    output = output & GetTens(Mid(given_number, 2))
    Else
    output = output & GetDigit(Mid(given_number, 3))
    End If
    GetHundreds = output
    End Function
    Function GetTens(tens_text)
    Dim output As String
    output = ""
    If Val(Left(tens_text, 1)) = 1 Then
    Select Case Val(tens_text)
    Case 10: output = "Ten"
    Case 11: output = "Eleven"
    Case 12: output = "Twelve"
    Case 13: output = "Thirteen"
    Case 14: output = "Fourteen"
    Case 15: output = "Fifteen"
    Case 16: output = "Sixteen"
    Case 17: output = "Seventeen"
    Case 18: output = "Eighteen"
    Case 19: output = "Nineteen"
    Case Else
    End Select
    Else
    Select Case Val(Left(tens_text, 1))
    Case 2: output = "Twenty "
    Case 3: output = "Thirty "
    Case 4: output = "Forty "
    Case 5: output = "Fifty "
    Case 6: output = "Sixty "
    Case 7: output = "Seventy "
    Case 8: output = "Eighty "
    Case 9: output = "Ninety "
    Case Else
    End Select
    output = output & GetDigit _
    (Right(tens_text, 1))
    End If
    GetTens = output
    End Function
    Function GetDigit(number)
    Select Case Val(number)
    Case 1: GetDigit = "One"
    Case 2: GetDigit = "Two"
    Case 3: GetDigit = "Three"
    Case 4: GetDigit = "Four"
    Case 5: GetDigit = "Five"
    Case 6: GetDigit = "Six"
    Case 7: GetDigit = "Seven"
    Case 8: GetDigit = "Eight"
    Case 9: GetDigit = "Nine"
    Case Else: GetDigit = ""
    End Select
    End Function
    

    Thanks and regards,
    Md. Sourov Hossain Mithun
    Team ExcelDemy.

  8. Reply Md. Sourav Hossain Mithun
    Md. Sourov Hossain Mithun Oct 12, 2023 at 11:18 AM

    Hello NYDA,
    Thanks a lot for your suggestion. We worked on your suggestion but couldn’t find the exact reason for which your solution worked. We tried it on Excel 365, maybe it can be applicable to the earlier versions. So it would be great a favor for us if you would share your Excel version and the specific reason for the issue.

    Thanks and regards,
    Md. Sourov Hossain Mithun
    Team ExcelDemy.

  9. Reply Md. Sourav Hossain Mithun
    Md. Sourov Hossain Mithun Aug 10, 2023 at 11:28 AM

    Hello PHIL REINIE,

    Thanks for your feedback. The issue you introduced is really a valid issue that we never faced before. Thanks a lot for sharing it with us. We have added this solution in our article, we hope it will help other users.

    Thanks and regards,
    Md. Sourov Hossain Mithun
    ExcelDemy

  10. Reply Md. Sourav Hossain Mithun
    Md. Sourov Hossain Mithun Mar 28, 2023 at 4:25 PM

    Hello MISTI,
    Thanks for your feedback. I hope you will be glad to know that, we have updated our methods according to related examples. Now it will help you to understand the specific use of every method.

  11. Hello WILL,
    Thanks for your feedback. There are some reasons that are why you may have faced the problem. You can solve it by following the steps:

    1. Maybe your Fill Handle tool is deactivated. To activate it, Click File > Options > Advanced > Enable fill handle and cell drag and drop.

    2. The AGGREGATE function can work only for vertical ranges, not for horizontal ranges. So always apply it for vertical ranges and then the Fill Handle should work.

    3. The AGGREGATE function is available since 2010, so if you are using an older version of Excel then it won’t work.

    If the above solutions fail to rescue you then your issue is quite particular and that is difficult to find out without the file. So if you share your file with us then we hope, we could provide you with the exact solution.

    *Sharing Email Address: [email protected]

  12. Hello EYAD,
    Thanks for your feedback. It’s possible to combine 3 columns using the 2nd method after a little bit modification of the formula.

    I added more 4 products in column D and then applied this formula in Cell E5:
    =IF(B5<>"",INDEX($B$5:$B$1048576,ROW()-COUNTA($B$5:$B$8)),IF(C1<>"",INDEX($C$5:$C$1048576,ROW()-ROW($E$8)),INDEX($D$5:$D$1048576,ROW()-11)))
    null
    *INDEX($D$5:$D$1048576,ROW()-11)
    Here, 11 is used based on the length of the second column.

  13. Hello ROXY,
    Thanks for your feedback. The above three issues are all the most common and possible issues that we have recognized till now. Would you please check whether your worksheet is protected or not? If not then maybe your problem is quite particular and that’s quite difficult to find without the file. So if you would share your file with us then hope, we could find out the reason and give a proper solution.

    *Sharing email address: [email protected]

  14. Hello DILEKA,
    Thanks for your feedback. There are some possible reasons for why the sort command may not work:
    1. Remaining blank rows, cells, or blank columns in the selected range.
    2. Presence of Leading Space.
    3. Mixed Data Type in the Same Column.
    4. Selecting multiple worksheets before sorting.

    To know in detail, please follow this article regarding on this issue:
    https://www.exceldemy.com/sort-and-filter-in-excel-not-working/#Sort_and_Filter_are_Greyed_out_in_Excel

    We hope the above solutions will rescue you. If not, then your problem is quite particular. In that case, if you share your worksheet with us then hope, we will be able to find out the issue and give a proper solution.

  15. Hello DANIEL,
    Yes, it’s possible to do that using the COUNTA function based on the first column. For that, use the following formula-
    =IF(B5<>"",INDEX($B$5:$B$1048576,ROW()-COUNTA($B$5:$B$8)),INDEX($C$5:$C$1048576,ROW()-COUNTA($B$5:$B$8)-4))

    ROW()-COUNTA($B$5:$B$8)-4
    Here, 4 is subtracted based on the length of the first column to return 1 as the output of this portion. So for your own dataset, modify the value according to the length of your first column.

  16. Hello TAB,
    Thanks for your feedback. You can easily do that by using a simple formula.
    Follow the steps:
    1. Select the range of dates.
    2. Click on the Conditional Formatting command from the Home tab.
    3. Then select New Rule.
    4. Select “Use a formula to determine which cells to format”.
    5. After that, insert the formula in the “Format values where this formula is true box”-
    =AND(D1<=TODAY(),F1<>"Complete")
    6. Choose the Red fill color from the Format command.
    7. Finally, hit the OK button.

    *To gray out the dates with complete status, use the following rule and Gray fill color:
    =AND(D1<=TODAY(),F1="Complete")

  17. Hello JULIE, thanks for your feedback. Use the below code to fix that-

    Sub Worksheet_SelectionChange(ByVal Target As Range)
    Static xRow
    Cells.Interior.ColorIndex = 0
    If xRow “” Then
    With Rows(xRow).Interior
    .ColorIndex = xlNone
    End With
    End If
    Active_Row = Selection.Row
    xRow = Active_Row
    With Rows(Active_Row).Interior
    .ColorIndex = 7
    .Pattern = xlSolid
    End With
    End Sub

    *Or you can use an alternative way with the previous code, after opening the file, click on any cell on the previously highlighted row, and then only the active row will be highlighted.

  18. Hello JK,
    Thanks for your feedback. Your problem is quite rare and unique. So it’s difficult to detect this type of problem without the user’s Excel file. If you would share your file with us, then hopefully we could detect the issue and could give you the exact solution. But temporarily we are suggesting you use the SUM function within the TRIM function, we are showing you a sample formula:
    =TRIM(SUM(C5:C9))

    The TRIM function will remove all extra spaces. I hope, it will help you.

  19. Hello HERMAN,
    Thanks for your feedback. You can follow the articles given below to create a payroll format based on 15 days. The steps and format will be pretty same, hope it will help you.

    https://www.exceldemy.com/daily-wages-sheet-format-in-excel/#Step_1_Calculate_Total_Daily_Working_Time_in_Daily_Wages_Sheet_Format_in_Excel

    https://www.exceldemy.com/calculate-hours-and-minutes-for-payroll-in-excel/

  20. Hello KATHY,
    Thanks for your feedback. Would you please check whether your worksheet is protected or not? If not then your problem is quite specific. So if you would share your file with us then hope, we could find out the reason and provide a solution.

  21. Hi MICHAEL,
    Thanks for your feedback.

    To count the number of items associated with each title (according to to catalog id), use this formula: =COUNTIF($B$2:$B$27,B2)

    And to sum the total number of uses of each item associated with that same title, use this formula: =SUMIF($B$2:$B$27,B2,$D$2:$D$27)

  22. Hello Mat, thanks for your feedback. The problem you mentioned will need a complex formula. You will have to apply a formula like this:
    =IF(SUM(–(MAX(AC2:AC12)=AC2:AC12))=1,INDEX(T2:AC12,MATCH(MAX(AC2:AC12),AC2:AC12,0),1)).

  23. Hello HOPE, thanks for your feedback. To do that, place Private Sub Workbook_open() in a new module and then call the previous Sub within it. I hope, it will work.

  24. Hello Mahedi, thanks for your feedback. When you download the file then there’s no connection between your downloaded file and our uploaded file. So, no worries, your file won’t lose.

  25. Hello TONIA.
    Thanks for your feedback. Autofit doesn’t work in a protected sheet, so please check it. If it remains unprotected then your problem is a quite particular type. So if you would share your workbook with us, we hope to find out the problem and give you a possible solution.

  26. Hello, HPOTTER.
    Thanks for your feedback. We think your problem is very specific which is difficult to identify without the file. So, if you would share your Excel file with us then we could find out the issue and hope, we could give you a solution.

  27. You are welcome 🙂 Glad to know that it helped you.

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo