User Posts: Lutfor Rahman Shimanto
0
How to Apply Cubic Spline Interpolation in Excel (with Easy Steps)
0

When it comes to software, Microsoft Excel is in a league of its own. Thanks to its many useful features, we may fully use any data. This article will cover ...

0
Opportunity Cost Calculator in Excel (3 Suitable Examples)
0

One of the most helpful software you can use is Microsoft Excel. It is possible to do an endless number of things with a dataset by utilizing Excel's ...

0
Excel Number Format Not Working (2 Reasons with Solutions)
0

Microsoft Excel is considered one of the most valuable tools currently accessible. With Excel's tools and capabilities, it is feasible to perform an endless ...

0
Min Max Inventory Calculation in Excel (with Easy Steps)
0

Microsoft Excel is one of the most beneficial programs you can use. Using Excel's features and tools, you can do an almost infinite number of things with a ...

0
How to Use LOOKUP Function Among Multiple Sheets in Excel
0

Microsoft Excel is a helpful program. You can conduct infinite operations on a dataset using Excel's tools and capabilities. Regularly, we must search for data ...

0
How to Use NOT and ISNA Functions in Excel (2 Examples)
0

The tool known as Microsoft Excel is quite helpful. You can execute an infinite number of operations on a dataset using Excel's tools and capabilities. When ...

0
Nested IF and ISERROR Formula in Excel (2 Practical Examples)
0

Microsoft Excel is a practical application. With Excel's tools and capabilities, you can perform an endless number of operations on a dataset. Frequently, we ...

0
How to Interpolate Time Series in Excel (3 Easy Ways)
0

Microsoft Excel is an intuitive tool that more than lives up to its excellent reputation. Thanks to Excel's tools and functions, we can perform various actions ...

0
How to Create Rainflow Counting Algorithm in Excel
1

Microsoft Excel is one of the most valuable tools available. Using Excel's capabilities and tools, a dataset can be utilized in an almost limitless way. This ...

0
How to Use IF Statement with Not Equal To Operator in Excel
0

Microsoft Excel is a practical application. With Excel's tools and capabilities, you can perform an endless number of operations on a dataset. Frequently, we ...

0
How to Plot Histogram with Unequal Class Intervals in Excel
0

Microsoft Excel is one of the most useful software you can get. Using Excel's features and tools, it is possible to do an infinite number of things with a ...

0
[Fixed!] Drop Down List Ignore Blank Not Working in Excel
0

Microsoft Excel is an intuitive tool that more than lives up to its illustrious reputation. We can perform many actions on a dataset thanks to Excel's tools ...

0
How to Count Frequency of Unique Values in a Column in Excel
0

Excel by Microsoft is a user-friendly program that more than lives up to its stellar reputation. We can do various operations on a dataset thanks to Excel's ...

0
Return Non Blank Cells from a Range in Excel (3 Suitable Ways)
0

Microsoft Excel is, in fact, a beneficial program. We can do many things with a given dataset using Excel's tools and features. In Excel, we often need to ...

0
How to Change Axis to Log Scale in Excel (3 Easy Ways)
0

Microsoft Excel is a practical application. With Excel's tools and capabilities, you can perform an endless number of operations on a dataset. Frequently, we ...

Browsing All Comments By: Lutfor Rahman Shimanto
  1. Reply Avatar photo
    Lutfor Rahman Shimanto Jan 26, 2023 at 2:03 PM

    Hello Raj
    Thank you for reaching out with your comment. You encountered a different result than what was described in the post. I assume that you missed inserting positive numbers in the range C16:C17. However, once those values were included, I discovered a result identical to what is described in the post. Therefore, It’s essential to ensure all intended data is inputted correctly.
    Regards
    Lutfor Rahman Shimanto

  2. Reply Avatar photo
    Lutfor Rahman Shimanto Jan 26, 2023 at 3:31 PM

    Hello Charlotte Fahey
    Thank you for reporting on this fascinating issue. I experience the same problems when a postal code begins with 0, and it is essential to preserve the leading zero when entering data into the system or application.
    The Postal Code column must be formatted as text. Following that, insert the desired data.
    converting into text format
    Now, adhere to the methods mentioned in this article. Ideally, you will observe the desired results.
    The desired output with leading-zero
    Regards
    Lutfor Rahman Shimanto

  3. Reply Avatar photo
    Lutfor Rahman Shimanto Jan 29, 2023 at 11:02 AM

    Thank you for bringing this issue to my attention, William Wyatt. I understand that you have been experiencing difficulties using formulas on cells formatted as fractions in your workbook. I apologize for any confusion or frustration this may have caused you.
    I have gone through this article and did not experience any of your issues. I am using Microsoft 365 to investigate this case. Could you share your workbook with us via email to better understand your situation? I would appreciate it if you could assist me more effectively.
    Regards
    Lutfor Rahman Shimanto

  4. Reply Avatar photo
    Lutfor Rahman Shimanto Jan 31, 2023 at 9:59 AM

    Hello DEBB WOLFE
    We appreciate your comment. I understand your difficulty, and you can avoid the issue by importing the CVS file into the existing worksheet.
    Change the column type in the Power Query window to text, as this article mentions. Next, select the Home tab. Select Close & Load and then Close & Load To at a later time.
    Loading the cvs data
    As a result, the Import Data window will display. Check the Existing Worksheet and then press OK.
    Choosing the Existing worksheet from the Import Data window
    Thus, you will be able to solve the problem.
    Regards
    Lutfor Rahman Shimanto

  5. Reply Avatar photo
    Lutfor Rahman Shimanto Jan 31, 2023 at 1:02 PM

    Hi D KELLY,
    Thanks for reaching out! I’d be happy to help you with your code and provide a solution. To solve this issue, we built a procedure called GetLatLong and a user-defined function named GetTotalDistance3Locations using VBA. You can input your desired locations in the GetLatLong procedure. The model calculates the total distance for three locations. Please click the link underneath this section to get a copy of the illustration workbook.
    https://www.exceldemy.com/wp-content/uploads/2023/01/Total-Distance-Calculation-for-Three-Locations.xlsm
    Best regards,
    Lutfor Rahman Shimanto
    (ExcelDemy Team)

  6. Reply Avatar photo
    Lutfor Rahman Shimanto Jan 31, 2023 at 4:01 PM

    Hello ARON HOLMBERG
    Thank you for reporting your issues. To count the number of components for each station, when the Station ID may be in one of three different columns, you can use the SUMPRODUCT function.
    =SUMPRODUCT((InputSheet!$B:$B=B5)+(InputSheet!$C:$C=B5)+(InputSheet!$D:$D=B5))
    This formula will test each of the three columns for the station ID and return 1 if it’s present in any of the columns and 0 if it’s not. Then, SUMPRODUCT will sum up the results, giving you the components for the station.
    This solution is more elegant than creating a new column that combines the three columns, as it avoids the need to manipulate the data. If you would like a copy of the illustrated workbook, please click the link provided below this section.
    https://www.exceldemy.com/wp-content/uploads/2023/01/To-Count-the-Number-of-Components-for-Each-Station.xlsx
    Best regards,
    Lutfor Rahman Shimanto

  7. Reply Avatar photo
    Lutfor Rahman Shimanto Mar 12, 2023 at 11:40 AM

    Hello DAVID,
    Thank you for reaching out with your comment. You encountered a different problem than what was described in the article. There could be several reasons why the problem is happening. Some of your add-ins may mess up the delete sheet feature, which may not work in your version of Microsoft Excel. To fix this, you should update your program.
    You can use an Excel VBA code to delete a sheet by inputting the sheet name.
    Excel VBA Code:

    Sub DeleteSheet()
        Dim sheetName As String
        sheetName = InputBox("Enter the name of the sheet you want to delete:")
        If sheetName <> "" Then
            If WorksheetExists(sheetName) Then
                Application.DisplayAlerts = False
                Sheets(sheetName).Delete
                Application.DisplayAlerts = True
            Else
                MsgBox "The workbook has no sheet with the provided name."
            End If
        End If
    End Sub
    Function WorksheetExists(shtName As String, Optional wb As Workbook) As Boolean
        Dim sht As Object
        If wb Is Nothing Then Set wb = ThisWorkbook
        On Error Resume Next
        Set sht = wb.Sheets(shtName)
        WorksheetExists = Not sht Is Nothing
        On Error GoTo 0
    End Function
    

    The VBA code and suggestions will solve your issue. Good luck.
    Regards,
    Lutfor Rahman Shimanto

  8. Reply Avatar photo
    Lutfor Rahman Shimanto Feb 6, 2023 at 12:00 PM

    Hello AYESHA
    Thanks for your query. I have analyzed the workbook Rafiul Haq shared. A prominent approach to avoid data overlapping is to create the employee record separately for each month. So don’t hesitate to make the Employee Leave description for each month.
    Regards
    Lutfor Rahman Shimanto

  9. Reply Avatar photo
    Lutfor Rahman Shimanto Feb 5, 2023 at 4:51 PM

    Hello ERICH NAGY
    I appreciate your time in reading the article. I’m delighted you found the information helpful and learnt something new. Your attention to detail is really appreciated, and you are correct. The appropriate range should be the C5:C20 range instead of D5:D20. An immediate correction will be made. Once again, We appreciate your comments and support. Continue reading our blog, and we aim to offer you further helpful information soon.
    Regards
    Lutfor Rahman Shimanto (ExcelDemy Team)

  10. Reply Avatar photo
    Lutfor Rahman Shimanto Feb 5, 2023 at 3:55 PM

    Hello ERIC SCHOENTHALER,
    Thank you for your nice words! Great that you found our website and information helpful and relevant to your goal. I’m glad we could provide you with the information you were looking for. Regarding your question, you can use the following VBA code to insert a specific amount of page breaks starting at a particular line.
    Regards
    Lutfor Rahman Shimanto

    Sub SpecificAmountOfPageBreaksWithStartingLine()
    Dim Lastrow As Long
    Dim Mysheet As Worksheet
    Set Mysheet = Application.ActiveSheet
    Row = Application.InputBox("Enter Amount of Row Number", TitleId, "", Type:=1)
    NumBreaks = Application.InputBox("Enter The Number of Page Breaks", TitleId, "", Type:=1)
    StartPoint = Application.InputBox("Enter The Starting Line Number", TitleId, "", Type:=1)
    Mysheet.ResetAllPageBreaks
    Lastrow = Mysheet.Range("B1").SpecialCells(xlCellTypeLastCell).Row
    For i = StartPoint To Lastrow Step Row
    If i <= StartPoint + (Row * (NumBreaks - 1)) Then
    Mysheet.HPageBreaks.Add Before:=Mysheet.Cells(i, 1)
    End If
    Next
    End Sub
  11. Reply Avatar photo
    Lutfor Rahman Shimanto Feb 2, 2023 at 5:27 PM

    Thank you so much for sharing this tip, Andy! I sincerely appreciate the time you took to share your expertise and assist others with this problem. Your suggestion proved effective, and We are genuinely grateful for it. Thank you again!
    Regards
    Lutfor Rahman Shimanto

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo