User Posts: Rafiul Hasan
0
How to Edit Comment in Excel (Including More Features)
0

When you are sharing an Excel file with someone else, you might need to share some information, express your feelings or concern, and put questions about some ...

0
How to Track Cash Flow in Excel (Step-by-Step Guideline)
0

Cash Flow is one of the basic fundamentals of financial statements. It is a frequently used tool to to insight into the performance of a company. If you work ...

0
Why Are My Percentages Wrong in Excel? (4 Solutions)
0

Trying to calculate percentages from some data but getting the wrong results? Thinking why my percentages are wrong in Excel? Actually, this may happen from ...

0
How to Create Comparative Balance Sheet Format in Excel
0

Wanna compare between financial figures of your company on different time periods? You will need a comparative balance sheet then. A comparative balance sheet ...

0
How to Calculate Utilization Percentage in Excel (3 Cases)
0

Working for a company in the managerial sector? Want to maximize the utilization of every sector of your company to achieve a definite goal? The more you ...

0
How to Prepare Charitable Trust Balance Sheet Format in Excel
0

Running a charitable trust organization? Looking for creating a balance sheet for your organization? Hey…hold on! Stick to this article. Here, I am going to ...

0
How to Create a Department Budget in Excel (with Detailed Steps)
0

Looking for a way to create a department budget in an Excel workbook? Don't worry at all. You have landed in the right place. just take a cup of tea and read ...

0
How to Prepare a Sales Budget with Example in Excel
0

Tired of keeping the sales record? Looking for a way to create sales budget in Excel for your company? Hang on! You have come to the right place. In this ...

0
How to Calculate Days with Aging Formula in Excel
0

Looking for a way to calculate days in Excel? Excel has several built-in functions to calculate days. This tutorial will give you a clear idea about the ...

0
How to Change Semicolon to Comma in Excel (6 Effective Ways)
0

Preparing Excel worksheet and have given semicolon mistakenly instead of a comma in your texts? Want to change semicolon to comma but find it difficult to do ...

0
Character Codes for CHAR Function in Excel (5 Common Uses)
0

Looking for a way to use Excel character codes for the CHAR function? Don’t worry, you have come to the right place. In this article, I will show you how to ...

0
How to Return Cell Address Instead of Value in Excel (5 Ways)
0

While applying Excel formula, we frequently use the cell address or cell reference to return a cell value. But if you work on an Excel sheet of a large amount ...

0
How to Create Mind Map from Data in Excel (2 Common Ways)
0

Looking for a way to create a mind map in Excel? You have landed in the right place. Although Excel allows a user to create charts and sparklines for better ...

0
How to Stop Name Conflict Dialog Box in Excel (3 Effective Ways)
0

When you try to move or copy one or more worksheets to a destination sheet in Excel, the Name Conflict dialog box may appear referring to an error in the ...

0
How to Remove Comma from Currency in Excel (6 Handy Tricks)
0

Does comma in numbers in an Excel worksheet bother you? Do you want to clean up your data by removing the comma from the number describing currency? Are tired ...

Browsing All Comments By: Rafiul Hasan
  1. 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

  2. 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))
    Use of Wildcards
    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

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

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

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

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

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

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

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

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

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

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

  13. 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(&).

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

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

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

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo