Registration: Jun 15, 2022

Comments: 32

Total submitted: 68

Rafiul Hasan

Rafiul Hasan, holding a BSc in Naval Architecture and Marine Engineering from Bangladesh University of Engineering & Technology, contributes significantly to the ExcelDemy project with almost 1.6 years of dedicated work. Currently an Excel and VBA Content Developer, he has a passion for problem-solving. Authoring over 100 articles for ExcelDemy showcases expertise in Microsoft Office Suites and Data Analysis. In addition to content development, Rafiul actively engages with the ExcelDemy forum, offering valuable solutions to user queries and insights into Excel-related problem-solving.

Designation

Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.

Education

B.sc in Naval Architecture & Marine Engineering (NAME), BUET.

Expertise

Data Analysis, Content Writing, Microsoft Office, AutoCAD.

Experience

Technical Content Writing
Team Work
Naval Architect
Undergraduate Projects
- Design of an Oil Tanker
- Risk assessment of LNG carrier with Fuzzy Logic approach.

Summary

Currently working as an Excel & VBA Content Developer.
Started technical content writing of Excel & VBA in June 2022.
I worked at Three Angle Marine Limited as a Naval Architect from June 2019 – October 2019.

Latest Posts From Rafiul Hasan

How to Insert Carriage Return in Excel Cell (3 Simple Ways)

Method 1 - Using Keyboard Shortcut Let’s say a cell is describing a student studying a specific subject at a university. The data here is separated by ...

Rafiul Hasan Apr 25, 2024

READ MORE +

How to Create a Balanced Scorecard in Excel (with Detailed Steps)

Watch Video – Create a Balanced Scorecard in Excel Step 1 - Assign Factors for the Scorecard Model Assign the parameters which will determine the ...

Rafiul Hasan Jun 17, 2024

READ MORE +

How to Make a Pattern Repeat in Excel (8 Easy Ways)

We have a sample dataset of various types of products ordered by different customers from an online store, their units, and the price per unit. We want ...

Rafiul Hasan Jul 9, 2024

READ MORE +

How to Show Negative Numbers in Excel (5 Ways)

Method 1 - Using Parenthesis STEPS: Select the data range containing negative numbers. Click on the Number Format icon in the Number group. As a ...

Rafiul Hasan Jul 6, 2024

READ MORE +

How to Create Cash Flow Statement Format in Excel

If you searching for a ready-to-make cash flow statement format, then you have definitely landed in the right place. Excel allows you to create cash flow ...

Rafiul Hasan Apr 29, 2024

READ MORE +

How to Make Time Attendance Sheet in Excel: 2 Easy Methods

Method 1 - Make Generic Time Attendance Sheet Step 1: Assign Date & Day Create a sheet table for one of the employees (i.e. Mike Almas) with multiple ...

Rafiul Hasan Jul 5, 2024

READ MORE +

How to Set Print Area with Blue Line in Excel: 5 Easy Ways

Method 1 - Set Print Area from Page Layout Tab Select the area you want to print> go to the Page Layout tab> click Print Areas> select Set Print ...

Rafiul Hasan Jul 4, 2024

READ MORE +

How to Determine What Is Causing a Large Excel File Size (10 Methods)

Method 1 - Check for Unnecessary Hidden Worksheet If you’ve received an Excel file from someone else or downloaded it from the internet, it may contain ...

Rafiul Hasan Jul 27, 2024

READ MORE +

How to Add a Number in Front of a Number in Excel (7 Easy Ways)

Method 1 – Using Double Quotes to Add a Number Let's say we have a dataset of different products and their corresponding Product ID Before Delivery. ...

Rafiul Hasan Apr 30, 2024

READ MORE +

How to Put Comma in Numbers in Excel (7 Easy Ways)

Suppose we have a dataset of some salesman and their respective annual sales (in USD). Let's insert some commas to make the Sales numbers much more ...

Rafiul Hasan Jun 3, 2024

READ MORE +

How to Convert Percentage to Whole Number in Excel (4 Methods)

This article will demonstrate how to convert a percentage to a whole number in Excel. About Percentage and Whole Numbers Percentage refers to a part of ...

Rafiul Hasan Jul 17, 2024

READ MORE +

How to Remove Background in Excel (2 Practical Cases)

What Is a Background in Excel? Usually, the default background in an Excel sheet is set to rectangular cells of equal width and height separated by gridlines. ...

Rafiul Hasan Jul 16, 2024

READ MORE +

How to Add A3 Paper Size in Excel (2 Quick Ways)

Download Practice Workbook Adding A3 Paper Size.xlsx Method 1 - Use Page Layout Tab to Add A3 Paper Size We have a sample dataset of some ...

Rafiul Hasan Jun 18, 2024

READ MORE +

How to Change Column Name from ABC to 1 2 3 in Excel

Method 1 - Use the R1C1 Reference Style to Change Column Names We have a dataset of sales of the sales assistants of a shop over a certain period of time. ...

Rafiul Hasan Aug 5, 2024

READ MORE +

How to Add Data to an Existing Chart in Excel (5 Easy Ways)

Method 1 - Add Data to an Existing Chart on the Same Worksheet by Dragging We have a dataset of sales for sales assistants who work at a shop over a certain ...

Rafiul Hasan Jun 15, 2024

READ MORE +

Browsing All Comments By: Rafiul Hasan

Reply
Rafiul Hasan Jan 21, 2024 at 2:31 PM

Hi ROXANNE,
Thanks for your complement. The number 122 used for scaling is chosen based on empirical or trial-and-error methods to visually match the bell curve with the histogram in the specific context of this tutorial. It is not a standard or universally defined scaling factor; rather, it appears to be chosen to align the bell curve with the histogram in a way that the author finds visually pleasing or appropriate for his dataset. If you are reproducing this analysis for a different dataset, you may need to experiment with the scaling factor to achieve the best visual fit for your specific data. Adjusting this factor allows you to customize the appearance of the bell curve to better match the characteristics of your dataset.

Regards,
Rafiul Hasan
ExcelDemy

Rafiul Hasan Jan 16, 2024 at 4:06 PM

Hi,
You can use the following code. After sending mail for the first sheet, it will show message box for next sheet. Insert your ranges carefully for different sheets in the appeared input message box.

Public Sub SendReminderMailForAllSheets()
    Dim ws As Worksheet
    For Each ws In ThisWorkbook.Sheets
        ' Call the existing SendReminderMail subroutine for each sheet
        SendReminderMail ws
    Next ws
End Sub

Public Sub SendReminderMail(ws As Worksheet)
    'Declare the variables
    Dim XDueDate As Range
    Dim XRcptsEmail As Range
    Dim xMailContent As Range
    Dim xRngDn As Range
    Dim xCrtOut As Object
    Dim xValDateRng As String
    Dim xValSendRng As String
    Dim k As Long
    Dim xMailSections As Object
    Dim xFinalRw As Long
    Dim CrVbLf As String
    Dim xMsg As String
    Dim xSubEmail As String
    On Error Resume Next
    'To select the date column insert an input box
    Set XDueDate = Application.InputBox("Select the column for Deadline/Due Date date column in " & ws.Name & ":", "ExcelDemy", , , , , , 8)
    If XDueDate Is Nothing Then Exit Sub
    'Insert an input box for selecting the recipients
    Set XRcptsEmail = Application.InputBox("Choose the column for the email addresses of the recipients in " & ws.Name & ":", "ExcelDemy", , , , , , 8)
    If XRcptsEmail Is Nothing Then Exit Sub
    'To enter the text mail, insert an input box
    Set xMailContent = Application.InputBox("In your email, choose the column with the reminded text in " & ws.Name & ":", "ExcelDemy", , , , , , 8)
    If xMailContent Is Nothing Then Exit Sub
    'Count rows for the due dates
    xFinalRw = XDueDate.Rows.Count
    Set XDueDate = XDueDate(1)
    Set XRcptsEmail = XRcptsEmail(1)
    Set xMailContent = xMailContent(1)
    'Set command to open MS Outlook Application
    Set xCrtOut = CreateObject("Outlook.Application")
    
    'Apply For loop to conduct the operation in each row one by one
    For k = 1 To xFinalRw
        xValDateRng = ""
        xValDateRng = XDueDate.Offset(k - 1).Value
        'Apply If condition for the Due Date values
        If xValDateRng <> "" Then
            'Condition set to send mail if the difference between due dates and the current date is greater than 1 and less than 7 days
            'Means 1 < X < 7, X = Due Date - Current Date
            If CDate(xValDateRng) - Date <= 7 And CDate(xValDateRng) - Date > 0 Then
                xValSendRng = XRcptsEmail.Offset(k - 1).Value
                'Create the subject, body, and text contents with the required variables
                xSubEmail = xMailContent.Offset(k - 1).Value & " on " & xValDateRng
                CrVbLf = "<br><br>"
                xMsg = "<HTML><BODY>"
                xMsg = xMsg & "Dear " & xValSendRng & CrVbLf
                xMsg = xMsg & "Text : " & xMailContent.Offset(k - 1).Value & CrVbLf
                xMsg = xMsg & "</BODY></HTML>"
                'Create the email
                Set xMailSections = xCrtOut.CreateItem(0)
                'Define the position to place the Subject, Body, and Recipients Address
                With xMailSections
                    .Subject = xSubEmail
                    .To = xValSendRng
                    .HTMLBody = xMsg
                    .Display
                    ' .Send ' Uncomment this line if you want to send emails automatically without displaying
                End With
                Set xMailSections = Nothing
            End If
        End If
    Next k
    Set xCrtOut = Nothing
End Sub

Regards
Rafiul Hasan
ExcelDemy

Reply
Rafiul Hasan Jan 16, 2024 at 4:01 PM

Hi AMY,
Most probably you haven’t disable the “.Send” statement in the VBA code. Disable the “.Send” statement by putting an apostrophe before it.

Regards
Rafiul Hasan
ExcelDemy
Reply
Rafiul Hasan Oct 29, 2023 at 12:32 PM

Hello JOHN,
Thanks for your comment. If new value is inserted in the range, the range changes (for example, from A2:A21 to A2:A25). You want to make the formula dynamic for the changed range. It seems you don’t want to use table. Actually, without using table, you won’t be able to make the formula dynamic.

The RANK function and the RANK.EQ function allow you to make the rank dynamic. But these functions assign the same rank to tied numbers and does not leave gaps in the ranking sequence. For example, if there is a tie for the second and third positions, both positions will be assigned a rank of 2, and the next distinct number will be ranked 4. But if you want to fill the next rank after ties, these functions are not useful. In that case, you have to use any of the methods stated in the article and copy the formula for the newly inserted value in the range. Without using table, it is not possible to make the formula dynamic.

Regards
Rafiul Hasan
Team ExcelDemy
Reply
Rafiul Hasan Oct 18, 2023 at 12:12 PM

Hi STEVE,
Thanks for your appreciation. And also sorry to hear that you faced difficulties with the 3rd method. I think you have faced problem in the GET.CELL function. Previously the sheet name (GET.CELL!) was also included in the formula and this may have occurred error. Actually there is no need to use the sheet name in the formula because Excel automatically updates the sheet name in the Name Manager. So, we have updated the formula to “=GET.CELL(38,$D5)“. Try it and hope you will be able to make it now. Thanks again for your observation.

Regards
Rafiul Hasan
Team ExcelDemy
Reply
Rafiul Hasan Oct 2, 2023 at 5:44 PM

Hi VLAD,
Thanks for your comment. You can checkout this article: How to Add Milestones to Gantt Chart in Excel.
Hope you find this helpful.

Regards,
Rafiul Hasan
Team ExcelDemy
Reply
Rafiul Hasan Sep 7, 2023 at 2:33 PM

Hi BAGUS,
In the context of Exponential Smoothing in Excel’s Data Analysis Toolpak, the Damping Factor refers to a parameter used to control the impact of older observations on the forecasted values.
The damping factor has a value between 0 and 1. It determines the weight assigned to the most recent observation when calculating the forecast. A higher value (closer to 1) gives more weight to the most recent data point, making the forecast more responsive to recent changes in the data. On the other hand, a lower value (closer to 0) gives less weight to the most recent data point, making the forecast more stable and less responsive to short-term fluctuations.

The value of Damping Factor being 0.91 suggests relatively high importance to the most recent data while still considering some historical data. The choice of 0.91 is somewhat arbitrary and depends on the specific characteristics of the data and the desired balance between responsiveness and stability in the forecast. Different values of the damping factor may be chosen based on the analyst’s judgment and the nature of the data being analyzed.

To determine the most appropriate value for the Damping Factor, it’s often a good practice to experiment with different values and evaluate the forecast accuracy using techniques like Mean Absolute Error (MAE) or Mean Squared Error (MSE). The choice of Damping Factor should ideally be data-driven and selected based on how well it performs in forecasting historical data or predicting future values.

Regards
Rafiul Hasan
Team ExcelDemy
Reply
Rafiul Hasan Aug 23, 2023 at 11:40 AM

Hi ANTHONEY,
Thanks for your comment. You requirement needs the Excel file. Please share your Excel file and repost your problem on our official ExcelDemy Forum. Our experts will try to reach you out.

Regards
Rafiul Hasan
Team ExcelDemy
Reply
Rafiul Hasan Aug 10, 2023 at 4:44 PM

Hi GREG,
I appreciate your suggestion. In VBA, there isn’t a built-in function to directly evaluate a string as code like in some other programming languages. You cannot directly evaluate a string as executable code like you would with the eval() function in JavaScript. Here, alternative approach has been provided to achieve similar results. You can achieve the concept of “evaluating strings as code” through code manipulation and dynamic formula evaluation. If you are looking for a method to directly execute arbitrary VBA code contained within a string, Excel VBA doesn’t provide a direct “eval” function for this purpose. The technique shared here provides structured way to achieve dynamic behavior in VBA.
Reply
Rafiul Hasan Jul 23, 2023 at 10:40 AM

Hello KRISTY,
If you want to create a weight loss graph with values from 230 to 150, you’ll need to adjust the scale of the vertical (y-axis) to accommodate the new range. If you want to set your target weight as 150, you can create the weight loss graph in Excel like below:

Regards
Rafiul Hasan
Team ExcelDemy
Reply
Rafiul Hasan Jul 17, 2023 at 12:23 PM

Hello EDI,
the INDEX-MATCH formula can return a #VALUE! error under certain circumstances.
1. The MATCH function within the INDEX-MATCH formula couldn’t find a match for the lookup value in the specified array or range.
2. The INDEX function is expecting a numeric value as a result, but the matched value is non-numeric.
3. Incorrect arguments or ranges.

If you elaborate the problem you’re facing, then it will be easy to provide solution. Let us know if you face any difficulties.

Regards
Rafiul Hasan
Team ExcelDemy
Reply
Rafiul Hasan Jul 2, 2023 at 12:10 PM
Hi MASHAL,
You can use use VBA macro to automatically convert any entry you enter in specific cells to upper case by just only entering the text. Just follow these steps:
1. Press ALT + F11 to open the Visual Basic for Applications (VBA) editor.
2. In the Project Explorer window, locate and double-click on the “ThisWorkbook” module for the desired workbook.
3. In the appeared code window, paste the following code:
```
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Dim rng As Range
Set rng = Sh.Range("A1:Z100") ' Replace with the desired range

If Not Intersect(Target, rng) Is Nothing Then
Application.EnableEvents = False
On Error Resume Next
Target.Value = UCase(Target.Value)
Application.EnableEvents = True
End If
End Sub
```
Replace “A1:Z100” with the range of cells you want to convert to uppercase.
4. Close the VBA editor.

Now, whenever you enter any text within the specified range, it will be automatically converted to uppercase without the need to manually run any macro. Adjust the range in the code as needed to match your desired cells.

Regards
Rafiul Hasan
Team ExcelDemy
Reply
Rafiul Hasan Jun 26, 2023 at 12:00 PM

Hi MARTIN PEREZ,
Thank you for your comment and for sharing your additional solution! I appreciate your input and the effort you put into finding a workaround for area chart markers. It sounds like you found an interesting method using a supporter series to manipulate the legend key font size. Your explanation will undoubtedly help other readers who come across your comment. Thank you again for your contribution!

Regards
Rafiul Hasan
Team ExcelDemy
Reply
Rafiul Hasan Jun 15, 2023 at 11:10 AM

Hi MARK,
Thanks for your comment. To learn different ways to print multiple sheets, you can follow this article of ExcelDemy: Print multiple sheets in Excel

If you want to print multiple sheets using VBA only, then follow this one: Print multiple Excel sheets to single PDF with VBA

Hope you will find this helpful.

Regards
Rafiul Hasan
Team ExcelDemy
Reply
Rafiul Hasan Jun 12, 2023 at 12:37 PM

Hi HANI,
Thanks for your query. The choice of epsilon depends on the desired accuracy of the eigenvalue estimate. It is typically a small positive value, and the algorithm terminates when the absolute difference between consecutive eigenvalue estimates falls below epsilon.

The specific value of epsilon will vary depending on the application and the desired level of accuracy. Using epsilon = 0.0005 indicates that the power method iterations will continue until the absolute difference between consecutive eigenvalue estimates falls below 0.0005. This level of tolerance can be suitable for many applications, especially when the eigenvalues of the matrix are relatively close in magnitude.

However, it’s important to note that the appropriate value of epsilon may vary depending on the specific problem and matrix being analyzed. If you find that the algorithm converges too quickly or does not reach the desired accuracy with epsilon = 0.0005, you may need to adjust the value accordingly.

Consider the scale and conditioning of the problem as well. If the matrix is ill-conditioned or has eigenvalues with large differences in magnitude, a smaller epsilon may be necessary to obtain accurate results.

So, it’s always important to assess the specific requirements of your problem and adjust the value of epsilon accordingly to achieve the desired accuracy.

Regards
Rafiul Hasan
Team ExcelDemy
Reply
Rafiul Hasan May 17, 2023 at 10:56 AM

Hi KEN,
This may encounter from several reasons.
1. If you have protected the worksheet or specific cells, it can prevent changes to the font settings. Try unprotecting the cells or the entire worksheet to see if that resolves the issue.
2. If there are any conflicting formatting applied to the cells, it might cause the barcode font to revert. Select the cells and clear any formatting such as bold, italic, or color changes. Then, set the font to “Code128” again.
3. Ensure that the page setup and print preview are correctly configured. Check the scaling options to make sure that the labels fit properly on the A4 sheet. Adjust the margins and other settings as needed to accommodate 51 labels per sheet.
4. If the above steps don’t solve the problem, try creating a new Excel file and follow the barcode printing steps from scratch. This can help identify if the issue is specific to your existing file.

Regards,
Rafiul Hasan
ExcelDemy Team
Reply
Rafiul Hasan Mar 28, 2023 at 11:30 AM

Hi ALLISON,
If you want to use wildcards with the second formula, you need to modify the dataset a little bit. Let’s say, we have short form of country name in the “Country” column. Our aim is to find the name of the person aged “38” and whose country is “India“. You can use the following formula:
=INDEX($B$5:$B$17, SMALL(IF(COUNTIF($F$6, $C$5:$C$17)*COUNTIF($G$6,$D$5:$D$17&”*”),ROW($B$5:$D$17)-MIN(ROW($B$5:$D$17))+1), ROW(A1)), COLUMN(A1))

We have used the wildcards character ampersand (*) in the second COUNTIF portion: COUNTIF($G$6,$D$5:$D$17&”*”)
As we want to find multiple output so it will result from an array. So, the $D$5:$D$17 acts as criteria as we can use wildcards character in criteria. This formula will match the short form mentioned in the country column and match it with criteria and extract the Name.
Hope you find this helpful.

Regards
Rafiul Hasan
Team ExcelDemy
Reply
Rafiul Hasan Mar 27, 2023 at 2:26 PM
Hi SINGGIH WAHYU N,
You can use VBA code for serving your requirement.
1. Select the merged cell(s) that contain data you want to copy.
2. Open the Visual Basic Editor by pressing Alt + F11.
3. Insert a new module by selecting “Insert” -> “Module” from the menu bar.
4. In the new module, enter the following code:
```
Sub CopyMergedCells()
    Dim mergedRange As Range, cell As Range
    Dim unmergedRange As Range, destCell As Range
    Set mergedRange = Selection 'Assuming the merged cells are currently selected
    Set unmergedRange = mergedRange.Cells(1).Resize(mergedRange.Rows.Count * mergedRange.Columns.Count, 1)
    Set destCell = Application.InputBox(prompt:="Select the top-left cell of the destination range", Type:=8)
    If destCell Is Nothing Then Exit Sub 'User cancelled the selection
    For Each cell In unmergedRange.Cells
        If cell.Value <> "" Then
            destCell.Value = cell.Value
            Set destCell = destCell.Offset(1, 0)
        End If
    Next cell
End Sub
```
5. Run the code and a prompt will ask you to select the first cell of destination range. Select a cell where you want to paste values and you will get output.

Hope this help you. If you don’t want to use VBA, you have to first paste values and then use the “Go To Special” (pressing CTRL+G) dialog box and then select “Blanks”> click “OK” to remove blank cells.

Regards.
Rafiul Hasan
Team ExcelDemy
Reply
Rafiul Hasan Mar 27, 2023 at 12:17 PM

Hi DARRELL,
Congratulations on your new project. Be confident, you can make it. Based on your selections, you may use any of the following to get resulting list:
1. IF function: You can use the “IF” function to create a formula that checks if certain criteria are met and return the appropriate value. For example, if you have a pick list for materials and another for color, you can use an “IF” function to generate a list of materials that match the selected color.
2. VLOOKUP function: The “VLOOKUP” function can be used to search for a value in a table and return a corresponding value. You can set up a table with all the possible combinations of selections and use “VLOOKUP” to generate the resulting list based on the selections made.
3. FILTER function: The “FILTER” function can be used to filter a list based on certain criteria. You can set up a table with all the materials and their attributes (such as color, size, etc.) and use “FILTER” to generate a list of materials that match the selected attributes.
4. PivotTable: Pivot tables can be used to analyze and summarize data in a table. you can set up a table with all the selections made and your corresponding materials and use a pivot table to generate a list of materials based on the selections made.

These are just a few options you can consider. You will need to choose the one that works best for your specific situation. Don’t hesitate to contact with us if you face any problem. Best of luck.

Regards
Rafiul Hasan
Team ExcelDemy
Reply
Rafiul Hasan Mar 9, 2023 at 2:01 PM

Hi NOUR,
Thanks for the appreciation.
As per your requirement, it is possible to allow multiple users to access and edit a workbook on a network computer. Here are some steps you can follow in this regard:

1. Save your workbook on a shared network drive that all users have access to.
2. Restrict editing access for other users to ensure only authorized users can edit the workbook.
3. Create a login form that allows users to enter their credentials to access the userform. You can store user credentials in a separate worksheet within the workbook or use an external database.
4. Use VBA code to pull the necessary data from the shared workbook and display it to the userform.
5. When a user makes changes to the data in the userform, use VBA code to write the changes back to the shared workbook.
6. Implement a save feature that automatically saves changes made to the shared workbook when the userform is closed.
7. Create a backup plan to ensure data is not lost in case of system failure or network issues. This can include regular backups or saving a copy of the workbook in a secure location.
8. Test the userform with different user accounts to ensure it works as intended and all users can access and edit the shared workbook.

Hope this guide helps you to approach and solve the issue you’re facing. Actually it is not possible to give an exact solution without checking the Excel file. Most probably you need physical assistance in this regard. Let us know if you have any additional questions or concerns. You can also send your Excel file to our official mail address: [email protected]
Have a great day!

Regards
Rafiul Hasan | ExcelDemy Team
Reply
Rafiul Hasan Feb 27, 2023 at 3:14 PM

Hi DIEP TRAN,
The “Yes to all” button is a feature in Excel that allows you to apply a selected action to all the occurrences of the same conflict during a process. This button is usually available in the Name Manager dialog box, which pops up when you create, edit or delete names in your workbook.

The availability of the “Yes to all” button may vary depending on the version of Excel you are using. However, in most versions of Excel, including the latest version, which is Excel 2021, the “Yes to all” button should be available in the Name Manager dialog box.

If you are not seeing the “Yes to all” button in the Name Manager dialog box, it could be that the dialog box is not showing all the options. You can try expanding the dialog box to see if the “Yes to all” button is hidden or check your Excel settings to ensure that the option is enabled.

Overall, it’s best to consult the specific version of Excel you are using or refer to the documentation to learn more about the availability and functionality of the “Yes to all” button in Excel.

Regards
Rafiul | ExcelDemy Team
Reply
Rafiul Hasan Feb 27, 2023 at 10:12 AM

Hi JEFF,
Thanks for your concern. Actually, all the methods here explained are very easy to understand. Considering the situation, you have to choose the best-suited method for serving your purpose. If you don’t want to use any formula, then you can use Method 1.

Regards,
Rafiul | ExcelDemy Team
Reply
Rafiul Hasan Feb 22, 2023 at 4:34 PM

Hello AARON MWALE,
Thanks for your comment. Sorry to hear that you’re facing issues with Excel.
When Excel hangs and starts an Undo action, that means Excel is trying to process a large amount of data or executing a complex operation. This may cause the program to be unresponsive for a period of time while it completes the task.

In order to stop the undo action, you can try pressing the “Esc” key on your keyboard. If this does not work, you can try pressing “Ctrl” & “Break” on your keyboard. If don’t find these helpful, you may need to wait for Excel to finish the operation before you can regain control of the program.

To prevent Excel from hanging and starting an Undo action in the future, you can try the following:

1. Limit the amount of data you are working with at one time. If you are working with a large amount of data, try breaking it up into smaller chunks that are easier for Excel to handle.

2. Close any unnecessary programs or applications running in the background. This can free up system resources and improve Excel’s performance.

3. Disable any add-ins or macros that may be causing Excel to slow down or become unresponsive.

4. Check for and install any available updates for Excel. Updates often include bug fixes and performance improvements that can help prevent Excel from hanging in the future.

5. Consider upgrading your computer hardware if it is outdated or underpowered. Excel can be resource-intensive, and having a fast and capable computer can make a big difference in its performance.

Hope you find these ways helpful to overcome your issues.

Regards,
Rafi
ExcelDemy team
Reply
Rafi Dec 5, 2022 at 2:52 PM

Dear BILLY,
Your PDF file should be readable in order to extract data. The application needs to recognize data. Please ensure a readable copy.
Regards
ExcelDemy Team
Reply
Rafi Dec 5, 2022 at 1:39 PM

Hi TOM,
Thank you so much for letting us know. The formula has been edited. Thanks for your concern. Stay connected!

Regards,
Rafi
Author: ExcelDemy Team
Reply
Rafi Dec 5, 2022 at 10:14 AM

Hello STEPH,
Did you enter any newer data into your pivot table field? With newer or re-entry of data, you need to go to the PivotTable Fields window (at the right corner of the worksheet)-> unmark the corresponding field of your data (i.e. Ship Date for this article) -> right-click on the PivotTable and click Refresh-> again mark the corresponding field that you unmarked a little bit ago.
Thanks and Regards
Reply
Rafi Oct 23, 2022 at 2:26 PM

Hello SG,
You can customize the error message. In the Data Validation message box=> Error Alert icon, you can choose “Warning” style from the dropdown list. Now, if you try to input invalid data, the error message will show 3 options asking you whether you want to continue: Yes/No/Cancel/Help. Clicking “Yes” will allow you to proceed with the current value and will not show the error again.
Reply
Rafi Oct 23, 2022 at 1:00 PM

Hello ANN HALL,
This may happen for different reasons.
1. Putting two statements in a single line. Check whether this is encountered and send the second statement in a new line.
2. Absence of parentheses.
3. Lack of whitespace in front of the ampersand(&) interpret as a long variable. So, put space between the variable and operator(&).
Reply
Rafi Sep 4, 2022 at 4:51 PM

Hi KAREN LING,
Glad that you liked the template. This template has got fixed interest rate. You can add variable extra payments manually to your Excel file if you need it.
Regards,
Rafi (ExcelDemy Team)
Reply
Rafi Sep 4, 2022 at 4:32 PM

Hi JON,
Thanks for your feedback. Can you please elaborate on your problem?
What I can say is that paying an extra amount from the minimum will reduce the next payments. You can proceed with your data. You can also share your Excel file with us and we will look into it.
Regards.
Rafi (ExcelDemy Team)
Reply
Rafi Sep 4, 2022 at 2:32 PM

Hi ABDUS SALAM,
An equation is not like a formula as it isn’t supposed to perform any calculation. You can’t enter an equation in a particular cell in Excel just like you do for a formula. What you can do here is that, you can adjust height and width of the “Equation Editor” box or the cell as if it looks like the equation stays in the cell. This can serve your purpose to some extent.
Regards.
Reply
Rafi Sep 4, 2022 at 2:27 PM

Hi KRISHNENDU,
Thanks for your comment. An equation is not like a formula as it isn’t supposed to perform any calculation. You can’t enter an equation in a particular cell just like you do for a formula. What you can do here is that, you can adjust height and width of your “Equation Editor” box or the cell as if it looks like the equation stays in the cell. I think this can serve your purpose to some extent.
Regards.