MD Tanvir Rahman, BUET graduate in Naval Architecture and Marine Engineering, dedicated over a year to the ExcelDemy project. He is an Excel and VBA Content Developer. Having authored 50+ insightful articles, he actively updates and improves over 80 articles, reflecting his commitment to accuracy and currency, managing day-to-day operations, and analyzing and developing Excel and VBA tutorials. His broad interests encompass Data Analysis, Advanced Excel, VBA Macro, Excel Templates, Excel Automation, and Excel Power Query, showcasing a comprehensive skill.
In this Excel tutorial, you will learn to create dynamic Excel charts using Excel Table, Define Name Range commands, and the VBA Macro tool. In addition, we ...
This tutorial will delineate the approaches to turning on Excel AutoSave. While constructing approaches we are likely to use Quick Access Toolbar (QAT), Excel ...
In this article, we delineate why is Excel not opening files. The main reason for not opening your .xlsx or .xlsm files can be corrupted. However, there are ...
The Leave Calculation Formula in Excel is essential for accurately calculating and tracking employee leave balances. In this Excel ...
In this Excel tutorial, you will learn to create a search box in Excel using several functions like FILTER, ISNUMBER, SEARCH, INDEX, and so on. Perhaps, The ...
In this tutorial, we will learn the approaches to save Excel as image. We will discuss the use of the keyboard shortcut, Camera, Copy a Picture and Save as ...
Importing vCard to Excel is essential to consolidating and organizing contact information in a spreadsheet format, sorting and filtering data, as well as ...
Throughout the content, we elaborate on the opening of the Page Setup in Excel with Page Layout, View, and File tabs. Further, we discuss the applications of ...
Database in Excel means gathering and arranging information on individuals, products, demands, transactions, and so on. In this Excel tutorial, you will learn ...
Data Extraction is the approach of gathering particular data from a source or replicating the data from somewhere else. In this Excel tutorial, you will learn ...
In this Excel tutorial, you will learn how to add, change, format, draw, remove, and create custom styles for cell borders in Excel, and even how to work with ...
Have you ever discovered that Excel does not always accurately compute formulas? I imagine that we have all worked with Excel files that were enormous and ...
Most computer programming languages provide the Try...Catch...End syntax. Make an effort to avoid making errors, misfits, and mistakes. Nevertheless, if an ...
Generally, a function can output a single value at a time while using the Excel VBA function. Any type of data can be declared that is supported by Excel VBA ...
It appears to be quite easy to declare a variable. However, in order to have excellent practical experience, we must comprehend the range of those factors. In ...
ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems.
Contact | Privacy Policy | TOS
Dear Bemina, thank you so much for your query. To apply the NORM.DIST function as well as the arithmetic formula for calculating the Normal Distribution, it is required to calculate Mean and Standard Deviation first.
The formula we have used for Normal Distribution is:
=NORM.DIST(C5,$C$13,$C$14,FALSE)
The generic syntax of the NORM.DIST function is:
=NORM.DIST(x,mean,standard_dev,cumulative)
Here,
x = C5 = supplied value to calculate the distribution
mean = $C$13 = arithmetic average of the distribution
standard_dev = $C$14 = standard deviation of the distribution
cumulative = FALSE = Returns probability mass function if the value is FALSE
Related Articles:
• How to Calculate Average in Excel
• How to Calculate Mean and Standard Deviation
• Calculate Normal Distribution in Excel
Thanks for reaching out. We, team ExcelDemy are here to assist you. Please feel free to let us know if you face any other shortcomings.
Regards,
MD Tanvir Rahman
Excel and VBA Content Developer
Exceldemy, Softeko.
Dear MARCO, Thanks a ton, and my heartfelt gratitude to you.
Query 1: #NAME? error
Considering you are trying the code mentioned in the content. However, there are several reasons for getting #NAME? error in Excel.
Issue 1: The code contains custom custom-created Public Function. So, when you download the file from our site, by default it it may be blocked by your local administration. Macro remains disabled in the blocked file. So, you must unblock the file by selecting File > Right-Click on Mouse > Properties > Check Unblock.
Issue 2: Spelling mistake in the function name shows #NAME? error.
Issue 3: Incorrect range and cell references also lead to #NAME? error.
To learn more about #NAME? error, go through #NAME? error in Excel.
Query 2: Convert Km instead of Miles
The mentioned code returns the outcome in Miles. However, you can convert Miles into Kilometers by inserting the following formula.
=(Calculate_Distance(C8,C9,C11))*1.61
or,
=CONVERT(Calculate_Distance(C8,C9,C11),”mi”,”km”)
Thanks for reaching out. We team Exceldemy are here to assist you. Please let us know if you face any other shortcomings.
Regards,
MD Tanvir Rahman
Excel and VBA Content Developer
Exceldemy, Softeko.
Dear Jae, You have my heartfelt gratitude. I found your queries quite distinctive and innovative. Yes, you can find out Names based on multiple data. Although there is no single functions in VBA that can extract result based on data, you must apply multiple VBA functions such as SPLIT, COUNTA, OFFSET, IF to get the job done.
Step 1: Write the VBA code in the module and hit the Run icon.
VBA Code
Step 2: Obtain output as follows.
Thanks a ton. Have a good day.
Regards,
MD Tanvir Rahman
Excel and VBA Content Developer
ExcelDemy, Softeko
Hello Nathan, Thanks for your observation. I got your shortcoming. This article focuses on removing links of local storage before opening Excel Spreadsheet files.
However, probably you are likely to remove hyperlinks such as doc links, youtube links, any website links. To remove hyperlinks, you can follow the article: Remove Hyperlinks from Excel Worksheets
I hope now you will be able to fix the issue. For any further shortcomings please let me know. We, team ExcelDemy are ready to assist you.
Thanks a ton. Have a good day.
Regards,
MD Tanvir Rahman
Excel and VBA Content Developer
ExcelDemy, Softeko
Hello! Peter Atallah, Thanks for the Query. It sounds like you’re encountering an issue with the “Find and Replace” feature in Microsoft 365 Apps for Enterprise, where you used to see a message box indicating the number of replacements made, but it’s no longer appearing. Here are a few steps you can try to troubleshoot and resolve this issue:
1. Check Notification Settings: Make sure that notifications are enabled in your Microsoft Office settings. Sometimes, notifications may have been disabled, which could prevent the message box from appearing.
2. Update or Repair Office Installation: Ensure that your Microsoft Office installation is up to date. Sometimes, issues can arise due to outdated software. If updating doesn’t work, you could also try repairing your Office installation. To do this, go to “Control Panel” > “Programs and Features,” select Microsoft Office, and choose “Change.” Then, select “Repair” and follow the prompts.
3. Reset Office Settings: If the issue persists, you can try resetting your Office application settings to their defaults. To do this, open any Office application (e.g., Word), go to “File” > “Options” > “Advanced,” and click the “Reset” button under the “Reset” section. Please note that this will revert all customizations back to their default settings.
Please feel free to let us know the update after trying these approaches.
Thanks a ton. Have a good day.
Regards,
MD Tanvir Rahman
Excel and VBA Content Developer
ExcelDemy, Softeko
Dear Lorenzo Pomini, Thank you so much for your queries. Probably Excel file location is not correct or you forgot to rename a sheet as “January“. However, please follow the mentioned steps. I hope it works.
Step 1: Make sure you created 2 or more worksheets in a preferred location.
Step 2: Create a worksheet named “January”
Step 3: Insert the following code in the module and hit the Run button.
Code Explanation:
Step 4: Select the folder to where Excel files are located.
Step 5: Obtain outcome containing data of 2017, 2018, 2019, 2020 in the January worksheet of the active workbook.
I hope these steps will be helpful to you. Please let me know if you face any further shortcomings. Thanks a ton. Have a good day.
Regards,
MD Tanvir Rahman
Excel and VBA Content Developer
Exceldemy, Softeko.
Dear Brittany, Thank you so much for your distinctive query. Here we are setting up a sample dataset of Electronics, Fashion and Snacks category. Using the following formula containing IF function in the D5 cell, you will be able to call the value of cells of the row once it is matched to a cell of same column.
=IF(C5=C$2,D$2,IF(C5=C$3,D$3,IF(C5=C$4,D$4,”Uncategorized”)))
Now drag the Fill Handle tool to fill the cells automatically.
I hope, the solution will be fruitful to you. For any further shortcomings, don’t forget to reach us. Have a good day.
Regards,
MD Tanvir Rahman
Excel and VBA Content Developer
Exceldemy, Softeko
Dear Savvas, You are most welcome. Your encouraging words motivate us a lot. Please stay tuned with Exceldemy for amazing contents.
Regards,
MD Tanvir Rahman
Excel and VBA Content Developer
Exceldemy, Softeko
Hello Asmitha, Thanks for your query. I found it very fascinating. Yes, we can insert a image in the A1 cell and export it to the Outlook in the middle of the email body.
Put the following VBA code in the module and get the output like below image.
Thanks a ton and have a good day.
Regards,
MD Tanvir Rahman
Excel and VBA Content Developer
Exceldemy, Softeko