About author
## Designation

Project Manager at ExcelDemy in SOFTEKO.
## Lives in

Dhaka, Bangladesh.
## Education

B.sc in Computer Science and Engineering (CSE), East West University.
## Expertise

Data Analysis, Content Writing, C, C++, Python, JavaScript (Basic), HTML, SQL, MySQL, PostgreSQL, Microsoft Office.
## Experience

## Summary

## Research & Publication

Shamima Sultana, BSc, Computer Science and Engineering, East West University, Bangladesh, has been working with the ExcelDemy project for 2 years. She has written over 75+ articles and reviewed 1000+ articles for ExcelDemy. She has also led several teams with Excel VBA and Content Development works. Currently, she is working as the Project Manager and oversees the day-to-day work, leads the services team, allocates resources to the right area, etc. Her work and learning interests vary from Microsoft Office Suites, and Excel to Data Analysis, Data Science, VBA, Python, and developing Excel Applications.

- Project Management
- Technical Content Writing
- Team Management
- Software Engineer
- Data Architecture [Analysis and Diagram]
- Data Governance [Using Excel and Postgre SQL]
- 3D Object Visualization [Using Python]

- Undergraduate Projects
- Industrial Visit Planning Website
- Database Management System
- Factoid Question Answering System (over Bangla Comprehension)

- Currently working as Project Manager of ExcelDemy
- Started technical content writing of Excel & VBA in October 2021 later prompted as Team Leader for Content Management.
- I worked at Adipster Tech Limited as a Software Engineer from November 2020 – May 2021. I’ve Done several real-life projects and documented several projects with analytical reports.

- Digital Governance for Pension Withdrawal System in Bangladesh. In 2019 2nd International Conference on Applied Information Technology and Innovation (ICAITI) IEEE.
- Awarded Best Presenter for “Digital Governance for Pension Withdrawal System in Bangladesh” in Bali, Indonesia
- Factoid Question Answering over Bangla Comprehension. In 2020, 4th International Symposium on Multidisciplinary Studies and Innovative Technologies (ISMSIT) IEEE.

Excel Interest Rate Calculator: Knowledge Hub Effective Interest Method of Amortization Excel Interest Rate Swap Calculation Excel Interest Rate ...

Shamima Sultana
Apr 29, 2024

In Microsoft Excel, it is easy to convert the currency to a number. For different types of purposes, you may need to convert your stored currencies to numbers. ...

Shamima Sultana
Dec 19, 2023

To demonstrate how to change the column width into cm (centimeters) in Excel, we'll use a dataset of order details with multiple columns. We've used ...

Shamima Sultana
May 15, 2024

A Proforma invoice is used to request payments from the dedicated buyer for any items, goods, services and etc before supply. It includes details of the items ...

Shamima Sultana
Dec 22, 2023

In Excel, storing phone numbers can be a bit tricky. Excel doesn't always recognize them automatically, especially when there are extensions involved. This ...

Shamima Sultana
Jan 18, 2024

The sample dataset contains Hyperlinks. Solution 1 - The Pound (#) Sign is Not Accepted in Hyperlinks If the link contains the Pound (#) sign, it ...

Shamima Sultana
May 25, 2024

To do analysis or to keep numbers in order, Sorting is important. In Excel, there are a couple of ways to Sort numbers. There are two possible ways to Sort ...

Shamima Sultana
Dec 21, 2023

In an Excel sheet, you can use different kinds of formats based on your need. Percentage is one of the number formats which is used to show a relative value ...

Shamima Sultana
Dec 27, 2023

For the purpose of demonstrating how to remove Filter in Excel, we'll use a sample dataset of a particular salesperson’s sales information, containing 4 ...

Shamima Sultana
May 19, 2024

The VBA Mod is not a function whereas MOD is a function in an Excel worksheet. VBA Mod is an operator which divides two numbers and returns the remainder. The ...

Shamima Sultana
Sep 12, 2023

Let's use a sample dataset that represents the personal information of a particular person. The dataset has 3 columns these are Name, City, and Zip Code. ...

Shamima Sultana
May 7, 2024

In Excel you can create a Pivot Table from any dataset, Pivot Table is useful when you need a new data point that can be obtained by using existing data points ...

Shamima Sultana
Dec 19, 2023

In Excel, you can split your full name into separate columns. There are a couple of ways to split first name and last name. You can use Excel inbuilt features ...

Shamima Sultana
Dec 21, 2023

Microsoft Excel has 6 logical operators which are also known as comparison operators. And Less Than or Equal to (<=) is one of them. The Less Than or Equal ...

Shamima Sultana
Dec 20, 2023

Understanding Lookup Tables in Excel When working with large datasets, you often need to retrieve specific values. Excel provides a powerful feature called ...

Shamima Sultana
Apr 26, 2024

- 1
- 2
- 3
- …
- 5
- Next Page »

Browsing All Comments By: Shamima Sultana

Hi

ArdaHope you are doing well.

I checked the code you mentioned above and it works. To make it more clear I’m attaching some images with the code.

Here, I tried the exact code in the same dataset.

`MsgBox Range("E5").End(xlToRight).Offset(0, 1).Address`

You can see the result

$G$5.Again I changed the dataset slightly.

Here, the result is also based on the location.

NB.If it doesn’t help you then please send your dataset to [email protected] or [email protected]Thanks

Shamima SultanaExcelDemy

Hello

Laura,Sorry to hear your issue. Here, I am suggesting some troubleshooting steps to resolve the problem. But I will encourage you to submit your Excel file in our

ExcelDemy Forumso that we can inspect it thoroughly.1. Remove Non-Printable Characters:

Use

=CLEAN(C2)to clean the data.2. Check for Merged Cells:

Ensure there are no merged cells in your dataset.

Data Consistency:

3. Make sure all data in Column C are of the same type (text).

4. Sort by Multiple Columns:

Use

Data > Sort,and add levels to sort by Column C first and then Column E.

5. Manual Inspection:

Check the middle section where the sort restarts for any anomalies.

6. New Worksheet:

Copy and paste the data into a new worksheet and try sorting again.

Regards

ExcelDemyHello

Selva,You are most welcome.

Regards

ExcelDemyHello

Kitonski,Here, I made some fixes. Please try this updated code:

Used the shell.Run command which is synchronous (True as the last parameter), ensuring the Python script completes before the VBA code proceeds.

Using the Now function to calculate the start and end times accurately.

To be safe used the Shell execution uses the correct quotation marks to avoid syntax errors.

Regards

ExcelDemyHello

Hassan Ibrahim Mohammed,Hope you are doing well. I will suggest you to go through the article again. You can download the dataset to try the calculations.

1: Likert Scale Range and Its Effect on Final ResultsHere, each Likert scale response (ranging from 1 to 5) is assigned a numerical value. These values are added up for each respondent to get a total score. For example, if a respondent’s answers to five questions are 4, 3, 5, 2, and 1, the total score is 15. This summed score helps in analyzing the overall sentiment or opinion of the respondents. Higher scores indicate more positive responses, while lower scores indicate more negative responses.

2: Adding Non-Parametric Tests to ExcelTo add non-parametric tests like the

Mann-Whitney U testor theKruskal-Wallistest to your Excel sheet, you can use the dataset from the article. But Excel does not have built-in non-parametric test functions, you need to manually calculate them using formulas and the Data Analysis ToolPak (If not available in Ribbon, get it from Excel options). For example, you can rank your Likert scale data using theRANKfunction and then apply the necessary formulas to perform the tests. It may require detailed setup and understanding of the test procedures, but it can be done effectively in Excel.Regards

ExcelDemyHello

Patricia,To solve this issue:

First, add columns for monthly interest and new balance.

Then, for each debt, include columns for monthly interest and new balance.

Use the following formula to calculate monthly interest:

Monthly Interest = Previous Balance * (Annual Interest Rate / 12)Example:

Debt 1 (D2): =C2*0.17/12

Debt 2 (H2): =G2*0.19/12

Debt 3 (L2): =K2*0.20/12

Use the following formula to calculate new balance:

New Balance = Previous Balance + Monthly Interest – PaymentExample:

Debt 1 (E2): =C2+D2-B2

Debt 2 (I2): =G2+H2-F2

Debt 3 (M2): =K2+L2-J2

Regards

ExcelDemyHello

Sandy,You can use this formula:

=OR(WEEKDAY([@DATE], 2) = 6, WEEKDAY([@DATE], 2) = 7)This checks if the [@DATE] column value is a Saturday (6) or Sunday (7).

Regards

ExcelDemyHello

Poppy Lukhele,Could you be more specific? If possible share any sample data.

Regards

ExcelDemyHello

Mary Grace,Please use this updated code to get your desired result:

Here I added an input box to select the column with the names of the recipients (XRcptsName ). Then, updated the email body to include the recipient’s actual name and removed the word “text.”

Regards

ExcelDemyHello

Paul Tupper,Yes, we can use this formula too. Thanks for your suggestions, we really appreciate it.

Regards

ExcelDemyHello

Paul Tupper,Of course, you can use this formula too. Both are doing the same calculations. Our formula is simpler nothing else. Thanks for your suggestions, we really appreciate it.

Regards

ExcelDemyHello

George Jululian,You are most welcome.

Regards

ExcelDemyHello

Hen,Thanks for your appreciation.

Regards

ExcelDemyDear,

You are most welcome.

Regards

ExcelDemyHello

Jeromy Adofo,You are most welcome. please stay connected with us.

Regards

ExcelDemyHello

Myron,You are most welcome.

Regards

ExcelDemyHello

Aleksandar,You can concatenate the cell values into a single string to get one QR code from different cell values.

You can use the following code:

Regards

ExcelDemyHello

Muhammad Afzaal Jutt,You need to use a combination of functions like

SUBSTITUTE,TEXTJOIN,FILTERXML, andSUM. Currently, Excel does not directly provide a simple formula for this without VBA.You can use the following formula:

`=SUM(FILTERXML("<t><s>" & SUBSTITUTE(SUBSTITUTE(A1, " ", "</s><s>"), "$", "") & "</s></t>", "//s[number(.)=.]"))`

Regards

ExcelDemyHello

Ckwong,To get the result as

State Name. You need to use the state name column as an array ofINDEXfunction. Just replace the cell range fromC5:C12toB5:B12.You can use the following formula:

=INDEX(B5:B12, MATCH(TRUE, INDEX(C5:C12>700000, 0), 0))Regards

ExcelDemyHello

Esraa Yaseen,You are most welcome. We are glad to help you.

Regards

ExcelDemyHello

Prabhakar Srinivasagam,You are most welcome. Your kind words means a lot to us. We are always here to help you.

Regards

ExcelDemyHello

Abinsh,You are most welcome.

Regards

ExcelDemyHello

Jen,Thanks for coming back, hopefully it will work this time. If it doesn’t work, you can let us know your problem in the comment section below.

Regards

ExcelDemyHello

Usama Jamil,You are most welcome.

Regards

ExcelDemyHello

Atif Hassan,Thanks for your appreciation. You can use the following formula to use XLOOKUP with tolerance level:

=XLOOKUP(TRUE, IF(ABS($C$2:$C$4 – $A$2) <= $B$2, TRUE, FALSE), $D$2:$D$4, "Not Found")https://www.exceldemy.com/wp-content/uploads/2024/05/XLOOKUP-Based-on-Customized-Criteria.gif

Please download the Excel file for better understanding:

XLOOKUP with Tolerance Level.xlsxRegards

ExcelDemyHello

Danielle Davies,You are most welcome. Your appreciation means a lot to us.

Regards

ExcelDemyHello

Vito,Don’t be sorry Vito. Let us know your feedback, hopefully it will work.

Regards

ExcelDemyHello

Jose,You are most welcome. Your appreciation means a lot to us.

Regards

ExcelDemyHell

MM,You are most welcome.

Regards

ExcelDemyHello

Michael,You are most welcome.

Regards

ExcelDemyHello

T Althoff,Our updated article indeed includes three templates of different cases, each addressing different scenarios. You can modify these templates to recalculate interest and principal based on irregular payment dates, they offer versatile solutions for various other scenarios.

Regards

ExcelDemyHello

Reza Fadlilah,Here are some articles from where you can download dataset of different types to practice your skills.

Excel Sample Data (Free Download 13 Sample Datasets)Excel Data for Analysis (Free Download 11 Suitable Datasets)Excel Data for Practice Free DownloadRegards

ExcelDemyDear

Ayebusiwa Oyesanmi Emmanuel,Answers are given in the Solution sheet of Excel File which is in

Download Practice Workbooksection.Regards

ExcelDemyHello

Emon,You can download the Cheat Sheet free of cost just by providing your valid email address. To get the files go to the “

Download Excel Formulas Cheat Sheet PDF & Excel Files” section of this post and enter your email address. Then check your email to get the download links.Best Regards

ExcelDemyHello

Abdul,It’s glad to hear and you are most welcome.

Regards

ExcelDemyHello

Rhonda Rodriguez,Thanks for your appreciation. You are most welcome.

Regards

ExcelDemyHello

Michailmqo,You can mail to [email protected].

Regards

ExcelDemyHello

Rajkapoor,Thanks for your appreciation and you are most welcome.

Regards

ExcelDemyHello

Deborah Yassen,You are most welcome.

Regards

ExcelDemyHello

Kukuh Romansyah,You are most welcome (Sama-sama). It’s glad to hear that you found it useful.

Regards

ExcelDemyHello

Lukas Cenjar,This VBA code won’t work on MAC but here we are giving you a sample code that might work on MAC. We updated our existing code based on MAC requirements.

1. We used AppleScript to interact with the Mail application on macOS to create and send the email.

2. Then, used MacScript to run AppleScript commands from VBA to handle Mac-specific scenarios.

Regards

ExcelDemyHello

ER,We are glad to hear that our article was helpful to you. Thanks for your appreciation. Keep learning Excel.

Regards

ExcelDemyHello

Jan,You need to scale the image to show the borders.

You can use the following updated code to do so.

Here, I used

0.9,to scale 90% of the cell’s width and height.Next, used

LockAspectRatioto maintain the aspect ratio of the pictures.Then, Adjusted the alignment using

Left and Top, it will center the picture within the cell after resizing.Regards

ExcelDemyHello

Alami,Yes. you need to select the cell in the InputBox every time you want to clear the cells.

But if you want to avoid using InputBox, I’m giving you two different code to do so.

Mentioned the range then clear cells:

Select the cells then run the VBA code:

Regards

ExcelDemy

Hello

A.Nirmala Rani,You can the following formula for the volume of a cylindrical segment:

Where:

V is the volume in liters,

L is the length of the cylinder in meters,

R is the radius of the cylinder in meters,

h is the height of the liquid level in meters.

Given the specific dimensions:

L=5.0 meters (500 cm),

R=1.0 meter (100 cm),

h varies from 0.01 meters (1 cm) to 2.0 meters (200 cm)

This formula calculates the volume of the liquid based on the height from the base up to the liquid level within a horizontal cylindrical tank. To use this formula, ensure to convert all measurements (radius, length, and height) to meters before applying them in the calculation.

At 1 cm height: Approximately 9.41 liters

At 2 cm height: Approximately 26.59 liters

At 3 cm height: Approximately 48.77 liters

At 4 cm height: Approximately 74.97 liters

At 5 cm height: Approximately 104.62 liters

At 10 cm height: Approximately 293.63 liters

———————————————————

To see the full list of calculated volumes for each centimeter increment from 1 cm to 100 cm for the horizontal cylindrical tank, Download the Excel File.

List of Calculated Volumes.xlsxRegards

ExcelDemyDear

Curt,It’s glad to hear that our article solved your issue. You are most welcome.

Regards

ExcelDemyHello

Kevin,Here the needle is pointing at 45 but as we kept the number inside the pie chart may seem 55 but actual point is 45. For your better understanding I am attaching another article for the clear view. Sorry for the confusion.

Please read this article from step 6: How to Create a Gauge Chart in Excel (With Easy Steps)

You can watch these two images to clear the confusion.

Regards

ExcelDemyHello

Harry Ingram,You can use this formula to extract only the numbers, including the decimal point.

=TEXTJOIN(“”, TRUE, IFERROR(IF(ISNUMBER(SEARCH(MID(B5, ROW(INDIRECT(“1:” & LEN(B5))), 1), {“0″,”1″,”2″,”3″,”4″,”5″,”6″,”7″,”8″,”9″,”.”})), MID(B5, ROW(INDIRECT(“1:” & LEN(B5))), 1), “”), “”))

Feel free to download the Excel file from the link below, you’ll find examples of the formula.

Excel file:

Extract Decimal Point NumbersRegards,

ExcelDemy

Hello

Paresh Kanti Paul,This article includes two dynamic ways for currency conversion.

Real Time Currency Converter in Excel

Regards

ExcelDemyHello

Martin,We are glad to hear that you found this article useful! Including a real-life example in tutorials can indeed make the steps more relatable and easier to understand. Applying these models to specific scenarios like maximizing profit by determining the production units for products A and B is a great way to leverage linear programming. We will include this in our next update.

Regards

ExcelDemyHello

Karunesh Pandey,As calibration details varies with lab type we can provide you the criteria. You can fill out your information and edit the list.

Equipment NameSerial NumberManufacturerModelCalibration FrequencyLast Calibration DateNext Due DateTechnician InitialsCommentsRegards

ExcelDemy

Hello

Gary Ward,Thanks for your valuable suggestion we will include this in our article.

Regards

ExcelDemyHello

Liz,You can avoid the absolute reference ($ sign). Here absolute reference is used so that it can avoid error if anyone copy the formula in another cell.

Regards

ExcelDemyHello

Alphonse,We are glad to hear from you again! Don’t worry about missed message, technical glitches happen to the best of us. We are glad to hear that the code for counting Mondays worked well for you. Thank you so much for expressing your gratitude—it’s always means a lot to us to know when something was helpful. You are most welcome and cheers to you too.

Regards

ExcelDemyHello

Cynthia Satterwhite,Neither any problem nor any solution are given. These dataset are given to practice by yourself.

Regards

ExcelDemyHello Nilanjan,

Excel for Mac doesn’t support the WorksheetFunction.WebService method due to differences in how Excel for Mac interacts with web services compared to Excel for Windows. In Mac, you need to directly access Google Translate’s API using HTTP requests or using a different method provided by Google Translate.

Replace

“YOUR_API_KEY”with your actual Google Cloud Platform API key.Remember to enable the

“Microsoft XML, v6.0”reference in the VBA editor (under Tools > References) to use CreateObject(“MSXML2.XMLHTTP”) for making HTTP requests.Regards

ExcelDemyHello

Umang,Here are some articles from where you can download dataset of different types to practice your skills.

Excel Sample Data (Free Download 13 Sample Datasets)Excel Data for Analysis (Free Download 11 Suitable Datasets)Excel Data for Practice Free DownloadRegards

ExcelDemyHello

Sameul Smith,You can follow any of the methods of your choice to make your list. If you face any problem regarding it you can share your list with us. If you want to upload any image or Excel file you can post it on ourExcelDemy Forum.Regards

ExcelDemyHello

Fredrick Aringo,You must use the last line to do AutoFilter based on criteria.

Please avoid the first line. We updated our code.

Regards

ExcelDemyDear

Bharath L,You are most welcome. We are glad that our solution worked for you.

Regards

ExcelDemyHello,

These datasets are given to use it for practice purpose. Currently we don’t have any solution of the task. But if you want you can send your completed task, we will review it for you.

Regards

ExcelDemyHello

NadineB,You are most welcome. Thanks a lot for your appreciation.

Regards

ExcelDemyHello

Valen,Can you mention the URL, please? In our site all URL’s of this article are working perfectly.

Regards

ExcelDemyHello

Dianne Waginauru,You are most welcome and thanks for your appreciation. All the very best for you project management journey.

Regards

ExcelDemyHello

Gwenn,Thanks for your suggestion. We deeply appreciate the solution provided in the comments. Thank you for your helpful contribution!

Regards

ExcelDemyHello

Ameer Ahmed,We don’t have any dataset you asked for and your question is not clear enough. Our datasets are given in the article.

Regards

ExcelDemyHello Gaurav,

You are most welcome.

Regards

ExcelDemy

Hello

Joellah,Thanks for your appreciation, it means a lot to us. We are trying our best to provide Excellent articles. Keep reading to boost your knowledge.

Regards

ExcelDemyHello

Leonardo Lagos,You can use the

HYPERLINKfunction in Excel 360 online version.Insert the following formula in your formula bar:

=HYPERLINK(“#’SheetName’!A1”, “Link Text”)But unfortunately, you can’t directly use the context menu to add a hyperlink to another sheet in Excel Online. You’ll need to use the formula approach described above.

Regards

ExcelDemyHello

Shaul Bel,Thanks for your appreciation. You’re welcome and I’m really glad to hear that the SUBTOTAL formula worked well for you in achieving the desired results. If you have any more questions or need further assistance with formulas or anything else, feel free to ask!

Regards

ExcelDemyHello

Michelle G,Thank you for reaching out to us. We request your attention to the above article to get your desired template on bonds purchased at a discount using the effective interest rate method.

Your requested update is incorporated into our template. Please refer to the sheet named ‘Effective Interest (Discount)’ for the template on bonds purchased at a discount using the effective interest rate method. Click on the three dots (…) if you don’t find the template in your downloaded file.

Regards

ExcelDemyHello

Martin,Excel for Mac does not offer right-clicking option like Excel for Windows.

You can double click on the macro button or you can try the control click.

A common workaround is to delete the existing button and create a new one, typing the correct text when you first insert it. While this might seem inefficient but you can “edit” the button text.

Regards

ExcelDemyHello

ScubaCamper,Thanks for your appreciation. You are getting the error with asterisk because your formula attempts to multiply by 1 (*1) directly within the MID function’s parameters, that is not correct. You need to apply the multiplication outside of the MID function but within the array operation.

Please try this formula:

=TEXTJOIN(“”, TRUE, IFERROR(MID(B5, ROW(INDIRECT(“1:” & LEN(B5))), 1)* 1, “”))In your formula style the formula would be:

textjoin(“”,true,iferror((mid([cellref],row(indirect(“1:”&LEN([cellref]))),1)*1),””))The purpose of multiplying by 1 (*1) in Excel formulas often is to convert text numbers to actual numeric values.

Regards

ExcelDemyHello

Dan,You can use this VBA code to delete sheet named “BETA”, from multiple Excel files which are in same folder.

Regards

ExcelDemyHello

Michelle,You are most welcome. Your appreciation means a lot to us.

Regards

ExcelDemyHello

Terry Wayne Sutfin,Thanks for your appreciation, it means a lot to us.

Regards

ExcelDemyHello

Margit,You are most welcome.

Regards

ExcelDemyHello

Jitendra Sahu,Thanks for your kind words. Our goal is to make Excel easy for everyone.

Regards

ExcelDemyHello

Melissa,We are glad that our article solved your problem. You are most welcome. Thanks for your appreciation.

Regards

ExcelDemyHello

Robert,You are most welcome. Thanks for your appreciation.

Regards

ExcelDemyHello

Ayokanmi,Thanks for your appreciation. You are most welcome. Our paid courses are in Udemy not in WordPress. But we have 7500++ free tutorials and 340+ YouTube videos. You can explore these learning materials for free.

Regards

ExcelDemyHello

Feven,You are most welcome.

Regards

ExcelDemy

Hello

Brent Hamilton,Thank you for your feedback. We used Microsoft 365 at work. We apologize for any confusion caused. The reason the “Show Changes” feature only becomes available after saving the file on OneDrive for real-time collaboration and tracking of changes. If you save it on OneDrive, it allows Excel to track changes made by different users and enables the “Show Changes” feature to display those revisions. This integration with OneDrive enhances collaboration and ensures that users can effectively manage changes made to shared documents.

Regards

ExcelDemyHello

David Rascati,You are most welcome. If you want you can share your code here so that we can debug it to find out the reason.

Regards

ExcelDemyHello

Mervyn,Thanks for visiting our blog and sharing your questions. You wanted to clarify the difference between a Table and a Dynamic Table.

Table and Dynamic table may look similar but they are not same.

In the context of the article,

Regular Table – is created manually by the user within Excel’s interface.

Dynamic Table – is generated automatically using VBA code.

When data is turned into a table, Excel automatically adds functions like sorting, filtering, and structured referencing. These tables are dynamic and adjust automatically when the data changes.

But a Dynamic Table in the article’s context likely refers to a table created dynamically using VBA code from a range. It is able to automatically manage specific criteria or changes.

Regards

ExcelDemyHello

Phil Hall,If you want the

Excel Workbookof this article you will get it from Download Practice Workbook section.If you want the get the advanced exercises from

“Get FREE Advanced Excel Exercises with Solutions!”button please fill your information correctly in the form. Next, you will get the exercise list in your given email. For your concern I tried it again it’s working perfectly.Regards

ExcelDemyHello

Vijay,Thanks for your appreciation.

Regards

ExcelDemyDear

RB,You are most welcome.

Regards

ExcelDemyDear

SKM,You are most welcome.

Regards

ExcelDemyDear

Sudarshan Dhuru,You are most welcome. Thanks for your appreciation it means a lot to us.

Regards

ExcelDemyDear

Xyand,You are most welcome. Thanks for appreciation. We updated the image of Method 6.

Regards

ExcelDemyHello

Saeed Anwar,You can download the Cheat Sheet free of cost just by providing your valid email address. To get the files go to the “

Download Excel Formulas Cheat Sheet PDF & Excel Files” section of this post and enter your email address. Then check your email immediately after to get the download links.Best Regards

ExcelDemyHello

Minzameera,Hope you are doing well. Here we calculated the overtime based on your criteria. We assumed that this time spans are for one person. If these are for different person you can modify the formula.

Formula ta calculate working hours:

=(IF(B2Formula to calculate the total working hours:

=C2+C3Formula to calculate the overtime,

here we assumed the working hours are 8:=IF(D2>B6,D2-B6,”No Overtime”)Regards

ExcelDemyHi

Paulinus Friday,You are most welcome. Data Files are available in the

Excel Practice filesection.Regards

ExcelDemyHello

ابو معاذ,You are most welcome.

Regards

ExcelDemyHello

Dwbi,You are most welcome.

Regards

ExcelDemyHello

Rao,We will try to upload it in our up coming videos.

Regards

ExcelDemyHello

Jessica H,You are most welcome.

Regards

ExcelDemyHello

Jennifer,You are most welcome.

Regards

ExcelDemyHello

Federico Cofederi,To send Email without pressing “Send” you can use

.Sendproperty in your code instead of.Display.Regards

ExcelDemyHello

Obinna,You are most welcome.

Regards

ExcelDemyHello

Prakash,You are most welcome.

Regards

ExcelDemyHello

Salomé Magerstein,You are most welcome.

Regards

ExcelDemyHello

Kristi,You are most welcome.

Regards

ExcelDemyHello

Muhammad Ismail Jumarang,You are most welcome.

Regards

ExcelDemyHello

Lory,You can use the following formula: =IFERROR(INDEX(‘Round 1′!$B$3:$AJ$25,MATCH(A5,’Round 1’!$B$3:$B$25, 0),34),””)

It will leave a cell blank if no matches are found.

Regards

ExcelDemyHello Kndn,

The Measuring unit of the result is “Mile”.

Hello,

You are most welcome.

Regards

ExcelDemyHello,

You are welcome.

Regards

ExcelDemyDear

Icarus Builders,You are most welcome.

Regards

ExcelDemyHello

Vini,Updated the code spilt data into multiple Excel file.

Regards

ExcelDemyHello

Syed Mohisn Ahmed,Updated the code in the marked section. Where I replaced “Rupees” text from condition.

You can use the following code.

Regards

ExcelDemyHello,

Thanks for reaching out to us.

First, remember that rules and instructions for interest calculation after garnishment order vary among countries and states. Next, post-judgment interest accrues only on the unpaid balance of the judgment.

However, to calculate interest if the judgment was turned into a garnishment, you can follow the steps below.

1. Take your judgment amount and deduct the amount of garnishment.

2. Multiply it by your post-judgment rate (%).

3. Take the total and divide it by 365 (the number of days in a year).

4. With the amount of post-judgment interest per day (in step 3), multiply it by the number of days from your date of judgment to the date you file your execution.

Simply, use the following formula to calculate interest if the judgment was turned into a garnishment:

Interest after Garnishment

= (Judgment Amount – Garnished Amount) ( Interest Rate / 365) Interim DaysThanks again for your thoughtful comments, especially the points you made about garnishment. It adds valuable perspective to our discussion.

Regards,

Abdullah Al Masud,ExcelDemy Team

Hello

Muhammad Asif,You are most welcome.

Regards

ExcelDemyHello

Joseph Jabatie,You are welcome. You can get the notes or Excel workbook from the Download section.

Regards

ExcelDemyHello

Mohammed.Thanks for your appreciation. Our content is completely free for our users learning but don’t use it for your business purpose without proper agreement.

Regards

ExcelDemyHello

Mohamed Sufi,You are most welcome.

Regards

ExcelDemyHello

Jude Ranby,Here, the first methods

Linking Existing Table on Another Sheet in Excelis duplicating the source table.Here, I’m

attaching a videofor understanding.Regards

ExcelDemyHello

Drishti,Here are some article you will find more exercises.

Excel Practice Exercises PDF with Answers

Sample Excel File with Employee Data for Practice

Advanced Excel Exercises with Solutions PDF

Regards

ExcelDemyHello

Smn,Formula of Exercise -5:

=AND(G102=”Astro”,OR(C102=”Laptop”,C102=”Mobile Phone”))is used to check multiple conditions using the AND and OR logical functions.Here,

G102=”Astro”: It checks the value of G102 is equal to “Astro” or not.OR(C102=”Laptop”,C102=”Mobile Phone”): It checks the value of cell C102 is equal to either “Laptop” or “Mobile Phone”. Here, the OR function will return TRUE if any of the conditions are TRUE.AND(G102=”Astro”, OR(C102=”Laptop”, C102=”Mobile Phone”)): Here, the AND function combines the two conditions. It will return TRUE only if both/two conditions are TRUE.Regards

ExcelDemyHello

M-curious,To do a conditional formatting follow the steps of method 1. Instead of using custom option from format cells, you can use the Alignment options.

Go to

Format cellsdialog box then fromAlignmentselect any select anyAlignmentsof your choice.Regards

ExcelDemyHello Dear,

You can download the Cheat Sheet free of cost just by providing your valid email address. To get the files go to the “

Download Excel Formulas Cheat Sheet PDF & Excel Files” section of this post and enter your email address. Then check your email immediately after to get the download links.Best Regards

ExcelDemyDear

Anthonia Aniekule,You are most welcome.

Regards

ExcelDemyHello

Bob Leslie,You will get Break Even Analysis Template template in this article.

Regards

ExcelDemyHello

Oscar,Glad to hear that our blogs are helping professionals.

Regards

ExcelDemyHello

IDD,If you want real-time synchronization between the Excel file on your computer and Google Sheets, you can use the Google Drive desktop app.

1. Download and install the Google Drive app on your computer.

2. Sign in with the same Google account used to upload the Excel file.

3. Copy or move the Excel file to the Google Drive folder on your computer.

Open the Excel file from the Desktop App of Drive. Then, any changes made to the file on your computer will be automatically synced with Google Drive, and subsequently, with Google Sheets.

Finally, open the google sheets from the Drive. You will get the updated Excel file.

Regards

ExcelDemyDear

TonyYou are most welcome.

Regards

ExcelDemyDear

Yasin,You are most welcome.

Regards

ExcelDemyDear

OppaPanda,You are most welcome.

Regards

ExcelDemyHello

Thomas,Thanks for your appreciation. We are working on it.

Regards

ExcelDemyDear

AKhtar Khilji,I hope this message finds you well too. Thank you very much for your kind words and your interest in using the training material from my blog for your nonprofit Excel training program. I’m thrilled to hear that you found the content helpful and that it will be used to empower the youth of marginalized communities in Pakistan.

I’m more than happy to grant you permission to utilize the exercises from the blog for your educational initiative. Please feel free to mention “ExcelDemy” along with the web address to provide proper attribution. It’s wonderful to know that the material will be shared with the trainees to enhance their learning experience.

If you have any specific requests or need further assistance with anything related to the training material, please don’t hesitate to reach out. I’m here to support your efforts in any way I can.

Wishing you great success with your Excel training program and the empowerment of the youth in marginalized communities.

Best regards,

ExcelDemyHello

Rahul,You are most welcome.

Regards

ExcelDemyHello

AJ,You are most welcome.

Regards

ExcelDemyHello

Ankur Vaish,Thanks for your suggestions.

Hell

o Sam Arthur,You are most welcome.

Regards

ExcelDemyDear

John Summers,You are most welcome. Your appreciation means a lot to us to write such technical and informative article in future.

Regards

ExcelDemyHello

Tiffany A Snyder,You are most welcome.

Regards

ExcelDemyHello

Earlington Etienne,You are most welcome.

Regards

ExcelDemyHello

Loni,You are most welcome.

Regards

ExcelDemyHello,

You are most welcome.

Regards

ExcelDemyHello

Jane Wanjiku,You are most welcome.

Regards

ExcelDemyHello

Sandra Merlo,You are most welcome.

Regards

ExcelDemyHello

Gallienus,You are most welcome.

Regards

ExcelDemyHello

John,You are most welcome.

Regards

ExcelDemyDear

Margaret,You are welcome.

Regards

ExcelDemyHello

Akram Siddique,Here, in the formula : =WEEKDAY(B5,11)

11 means – Numbers 1 (Monday) through 7 (Sunday). Here the weeks starts from Monday. So it will count the days of week from Monday and the integer value will be 1, Tuesday (2) and so on.

Regards

ExcelDemyHello

Noelle,To highlight the entire row, insert the following formula:

=$C5 < TODAY()In applies to select the rows

Regards

ExcelDemyDear

Daniela Vognar,You are most welcome.

Regards

ExcelDemyDear

Radu Pescaru,Sunteți foarte bineveniți.

Regards

ExcelDemyHello

Patricia Pearson,You are most welcome.

Regards

ExcelDemyHello

Ehia,You are most welcome.

Regards

ExcelDemyHello

You are most welcome.

Regards

ExcelDemyHello

Chris,You are most welcome.

Regards

ExcelDemyHello

Sirajudeen,You are most welcome.

Regards

ExcelDemyHello

Patrick Opiola,Thanks for your appreciation.

Regards

ExcelDemyHello

Mardell Daubney,Thanks for your appreciation.

Regards

ExcelDemyHello

Dr.M. Veerendra Kumar,You are most welcome.

Regards

ExcelDemyHello

Hamed,You are most welcome.

Regards

ExcelDemyHello

AJ,You are most welcome.

Regards

ExcelDemyHello

Joedel,You are most welcome.

Regards

ExcelDemyHello

Abdul Kader Osman,You are most welcome.

Regards

ExcelDemyDear

Saiful Amin,You are most welcome.

Regards

ExcelDemyHello

Abdrman,You are most welcome.

Regards

ExcelDemyHello

Nick,You are most welcome.

Regards

ExcelDemyHello

Gianluigi,You are most welcome.

Regards

ExcelDemyHello

JC,You are most welcome.

Regards

ExcelDemyHello

JC,You are most welcome.

Regards

ExcelDemyHello

Andrii,You are welcome.

Regards

ExcelDemyHello

Syed Minhaj,You are most welcome.

Regards

ExcelDemyHello

Peter,So kind of you.

Regards

ExcelDemyHello

Nurit,You are most welcome.

Regards

ExcelDemyHello

Ava,Thanks

Hello

Tamiko,You are most welcome.

Regards

ExcelDemyHello

Huongpt,You are welcome.

Regards

ExcelDemyHello

Brenda Gale Austin-Sanders,You are most welcome.

Regards

ExcelDemyDear

Mario,You are most welcome.

Regards

ExcelDemyHello Amanz,

We shared our ideas with you in your ExcelDemy Forum post.

Hello

Adam Ingleton,You are most welcome.

Regards

ExcelDemyHello

Ani,You are most welcome.

Regards

ExcelDemyHello

Vijiaselvam Nayagam,You are most welcome.

Regards

ExcelDemyHello

Mohammad,You are welcome.

Regards

ExcelDemyHello

Suzie,Glad to hear that our solution helped you.

Regards

ExcelDemyHello

Romeo Nyi,You are most welcome.

Regards

ExcelDemyDear

Minzitia Lawrence,You are welcome.

Regards

ExcelDemyHello

Juan,You are most welcome.

Regards

ExcelDemyDear

Kagiso,Thanks for your appreciation.

Regards

ExcelDemyHello

Azreim,You are most welcome.

Regards

ExcelDemyThanks for your appreciation.

Regards

ExcelDemyHello

Lee G,You are most welcome.

Regards

ExcelDemyHello

Tanveer,Thanks for your appreciation.

Regards

ExcelDemyHello

Mian Muhammad Saleem,You are most welcome.

Regards

ExcelDemyHello

JD,You are most welcome.

Regards

ExcelDemyHello

Eduardo,You are welcome.

Regards

ExcelDemyDear

Sam,Thanks for your appreciation.

Regards

ExcelDemyHello

Mongwongprue Marma,You are welcome.

Regards

ExcelDemyHello

Calin,You are most welcome.

Regards

ExcelDemyHello

Adam,Thanks for your appreciation. You are most welcome.

Regards

ExcelDemyHello

Ali,Thanks for your appreciation. You are most welcome.

Regards

ExcelDemyHello

Dawood,Thanks for your appreciation.

Regards

ExcelDemyHello

Eduardo,Kindly share your Excel File and images in ExcelDemy Forum.

Regards

ExcelDemyHello

Daniel Woods,To make problem sharing easier we launched

ExcelDemy Forum, so that you can upload Excel Files and images of your problem. You can share your workbook in ExcelDemy Forum our expert team will reach out to you.Regards

ExcelDemyHello

Daniel Woods,To make problem sharing easier we launched

ExcelDemy Forum, so that you can upload Excel Files and images of your problem. You can share your workbook in ExcelDemy Forum our expert team will reach out to you.Regards

ExcelDemyHello

Abishek,You are most welcome.

Regards

ExcelDemyHello

David,Thanks for your valuable suggestions.

Regards

ExcelDemyHello

Mike Longoria,You are most welcome.

Regards

ExcelDemyHello

Z Thomas,You are most welcome.

Regards

ExcelDemyDear

Andrija,You are most welcome.

Regards

ExcelDemyHello

Mohammed,Kindly share the issues you are facing while using the Excel file in the comment box. In case you need to share images, Excel file, you also can post your problem in

ExcelDemy Forum.Regards

ExcelDemyHello

Syifaa’ Mustafa,To get the

Developer tabfollow the steps mentioned in the article “Display the Developer tab in Excel“. Then you can use it to create Tooltip.Regards

ExcelDemyHello

Selam,You are most welcome.

Regards

ExcelDemyHello

DanJ,You are most welcome.

Regards

ExcelDemyHello

Matt S,You are most welcome.

Regards

ExcelDemyHello

Odedele Olufemi,You are welcome.

Regards

ExcelDemyHello

Joel,You are most welcome.

Regards

ExcelDemyHello

Chanyalew,Thanks for your appreciation.

Regards

ExcelDemyHello

Lynn,You are most welcome.

Regards

ExcelDemyHello

Nasir Ahmed,Thanks for your appreciation.

Regards

ExcelDemyDear

Anon,You are most welcome.

Regards

ExcelDemyHello

Vickie Addo,We have given the answers of 100 questions in our Excel File, which is given in the

Download Practice Workbook Section. As these questions are given to test your skills it won’t be helpful to check the answer immediately. A gif is given how you can test your skills at the end. Please download the Excel File and test you skills then see the answers.Regards

ExcelDemyHello

Venkatesh,You are most welcome.

Regards

ExcelDemyDear

Alexandar P,You are most welcome.

Regards

ExcelDemyHello

Naziom,You are most welcome.

Regards

ExcelDemyHello

Viraltecho,You are most welcome.

Regards

ExcelDemyHello

Joel,You are most welcome.

Regards

ExcelDemyHello,You are most welcome.

Regards

ExcelDemyHello

Suhaili,You don’t need to worry about payment. If you want any read-to-use template kindly send your requirements using [email protected] email.

Regards

ExcelDemyDear

Dave,You are most welcome.

Regards

ExcelDemyDear

Komal Thakur,You are most welcome.

Regards

ExcelDemyHello

Samia,In the

Download Practice Workbooksection, you will get the dataset used in the article.Regards

ExcelDemyHello

Nafez,You are most welcome and thanks for you invitation to visit Qatar.

Regards

ExcelDemyHello

May,The

“Developer Tab”option is missing in default Excel versions. You can enable it from Excel Options. By following this articleDisplay the Developer Tabyou can enable it easily.Regards

ExcelDemyDear

Laurie,You are most welcome.

Regards

ExcelDemyDear

Sovereign,Thanks for your appreciation.

Regards

ExcelDemyHello

Sagar,You will get the solutions in the Excel file, which is given in the

Download Practice workbookSection.Regards

ExcelDemyDear

Anusha Uppuganti,You are most welcome. We are so glad that our article explanation helped you.

Regards

ExcelDemyDear

PK,Thanks for your appreciation. You are most welcome.

Regards

ExcelDemyHello

Tsegay Gebreselasie,Our aim is giving you the best Excel-related content like this.

Regards

ExcelDemyDear

Mark,Thanks for your appreciation.

Regards

ExcelDemyHello Rolan,

Thanks for your suggestion. Article is updated.

Hello

Damien,From our

Download Practice Workbooksection, you will get the Excel file.If you face any difficulties after downloading the above file, follow this article to

Enable Macros but Not WorkingRegards

ExcelDemyHello Taiwo,

All the solution are available in the

Excel Practice filesection.We used this formula to get discount amount:

=F5*IF(D5<1,0.03,0.05)Regards

ExcelDemyHi

viralTechoThanks for your appreciation.

Regards

ExcelDemyHello

James Ward,To run the code from Excel you can follow these steps:

Developertab >>Macros>> Select anySub Procedurefrom the listRegards

ExcelDemyHello

Hugh Richards,Thanks for your appreciation.

Regards

ExcelDemyDear

Noe Albarran,You are most welcome.

Regards

ExcelDEmyDear

Yuan,Thanks for the suggestions. The code is updated you can check it now.

Regards

ExcelDemyDear

AmirYou have to use either the combined formula or the vba code. Because converting number to words maintaing the place vaule is not possible by simple formula.

Regards

ExcelDemyDear

Ian Fisher,You are most welcome.

Regards

ExcelDemyHello

Viraltecho,You are most welcome.

Regards

ExcelDemyHello

Viraltecho,You are most welcome.

Regards

ExcelDemyDear

Roberto,You are most welcome.

Regards

ExcelDemyDear

AubreyYou are most welcome. Your appreciation means a lot to us.

Regards

ExcelDemyDear

Dilip PaunikarYou are most welcome.

Regards

ExcelDemyDear

SoumendraYou are most welcome.

Regards

ExcelDemyHello Manwesh,

You can state your problem in the comment section or in our

ExcelDemy Forum.Regards

ExcelDemyDear Ashab,

We do have a YouTube channel named ExcelDemy

Regards

ExcelDemyDear

Evangeline,Thanks for your appreciation. Our experienced writers write these questions after doing a complete research about the topic.

Regards

ExcelDemyDear

Jason,You are most welcome.

Regards

ExcelDemyDear

Ryan,Glad to hear that our article helped you.

Regards

ExcelDemyDear

Endashaw Balcha,To know more about excel formula you can explore our Excel Formulas category. From here you will get practical use of

different formulas in different fields.Regards

ExcelDemyDear

Raf,You are most welcome.

Regards

ExcelDemyHello

Muhammad Amin,Good to hear that. To get more helpful contents explore our site.

Regards

ExcelDemyDear

Jess,Thanks for your appreciation.

Regards

ExcelDemyDear

Jimmy,You are most welcome.

Regards

ExcelDemyHello

y2mate,Thanks for your appreciation.

Regards

ExcelDemyDear

ytMp3,Thank you so much.

Regards

ExcelDemyDear

Martin Carrion,You are most welcome.

Regards

ExcelDemyDear

Dina,Thank you so much for your appreciation.

Regards

ExcelDemyDear

Navini,You are most welcome.

Regards

ExcelDemyDear

Gopi Sahu,Thanks for reaching out to us. You will get various types of WFM related articles here

Excel SolverIf you need solution of any specific topic kindly comment down below.

Regards

ExcelDemyDear

Justice,You are most welcome.

Regards

ExcelDemyDear

Merry,You are most welcome.

Regards

ExcelDemyDear

Karen,You are most welcome.

Regards

ExcelDemyHi

Putul ch. Borah,Yes, you can do it by following the mentioned steps.

Dear

Tiago,You are most welcome.

Regards

ExcelDemyDera

Ashok,You are most welcome.

Regards

ExcelDemyDear

Foysal,You are most welcome.

Regards

ExcelDemyDear

kinyapreen,To get virtual lessons you can follow our youtube channel Youtube Channel

Regards

ExcelDemyHello

BART,It is possible to add a VB line of code to run the selection change code only when you click the tab of the worksheet called “index.” To achieve this, you can use the Worksheet_Activate event in the code module of the “index” worksheet. Here’s the code.

Regards

Alif Bin HussainDear,

You are most welcome.

Regards

ExcelDemyDear

Bart,You are most welcome. Sure, you can inform us.

Regards

ExcelDemyDear

Najeeburk,You are most welcome.

Regards

ExcelDemyDear

Danny Van Straten,If you need any types of customized templates you may contact us through [email protected]

We have a expert team to create any types of professional templates.

Regards

ExcelDemyHello

Yaojm,Thanks for your suggestions. Here we focused on the comparison/difference of VLOOKUP and XLOOKUPp that’s why we didn’t improvised the use of VLOOKUP.

Regards

ExcelDemyHello

Pankaj,You are welcome.

Regards

ExcelDemyDear

Charlotte,You are most welcome.

Regards

ExcelDemyDear

Mustafa,You are most welcome.

Regards

ExcelDemyHello

Abubakar,You are most welcome. We hope so you will be able to create an interim certificate template following these steps.

Regards

ExcelDemyDear

B,You are welcome.

Regards

ExcelDemyDear

Akash,You are most welcome.

Regards

ExcelDemyDear

Carl,You are most welcome.

Regards

ExcelDemyHello Dear,

You can download the Cheat Sheet free of cost just by providing your valid email address. To get the files go to the “

Download Excel Formulas Cheat Sheet PDF & Excel Files” section of this post and enter your email address. Then check your email immediately after to get the download links.Best Regards

ExcelDemyDear

Macel Williams,To customize any templates you can contact with us via this mail problem @exceldemy.com

Regards

ExcelDemyDear

Macel Williams,To customize any templates you can contact with us via this mail problem @exceldemy.com

Regards

ExcelDemyDear

Qasim,Thanks for your suggestions we have updated our Exercise 3 you can check it now.

Regards

ExcelDemyDear

Kenny H,This Email address is valid but if you face any problem you can post your problem in our ExcelDemy Forum.

Regards

ExcelDemyDear

Nikhil Pandey,You will get all the solutions in the workbook’s Solution sheet. Here I’m giving you the query answer for your understanding.

The Formula is :

=WEEKDAY(B5,11)Regards

ExcelDemyDear

Nikhil Pandey,You will get the solution sheet in the Download Practice Files section. Download the workbook there in Solution sheet you will get all the solutions. You you can get the workbook from this link

Solution SheetRegards

ExcelDemyDear

Aiden,Yes you can do that.

Regards

ExcelDemyDear

Macel,You are welcome.

Regards

ExcelDemyDear

Marc,You are welcome.

Regards

ExcelDemyDear

Kim,Thanks for your appreciation.

Regards

ExcelDemyDear

Prakash Tulsiani,You are most welcome.

Regards

ExcelDemyDear

Kay,To get a customized templates you can contact with us through this Email: [email protected]

Regards

ExcelDemyHello Dear,

You can download the Excel and PDF files free of cost just by providing your valid email address. To get the files go to the “

Download Excel Formulas Cheat Sheet PDF & Excel Files” section of this post and enter your email address. Then check your email immediately after to get the download links.Best Regards

ExcelDemyDear

Nadew w/yesus,You are most welcome.

Regards

ExcelDemyDear

Dr,You are most welcome.

Regards

ExcelDemyDear

Adil Ahmed,You are most welcome.

Regards

ExcelDemyDear

Macel Williams,You are most welcome.

Regards

ExcelDemyHello Dear,

Download Excel Formulas Cheat Sheet PDF & Excel Files” section of this post and enter your email address. Then check your email immediately after to get the download links.Best Regards

ExcelDemyDear

Isaac,You are most welcome.

Regards

ExcelDemyDear

MADI,Thank you for following our article.

To split into sheets based on certain row conditions, we have to enter an IF condition that checks if the row is of a certain colour. Here, I have added the code to do this.

This code checks if the interior colour of the first cell in each row of the selected range is

Green(RGB(0,255,0)). The entire row is copied and pasted into a new sheet if rows meet the condition. You can alter this colour condition according to your need.Regards

Priti

Dear

Sara,You will find the solutions in the Excel file which is given in

Download Practice Workbooksection.Regards

ExcelDemyDear

Sakshi,You are most welcome.

Regards

ExcelDemyDear

Md. Morshed Alam,You are most welcome.

Regards

ExcelDemyDear

Alex,Thanks for your feedback.

Regards

ExceldemyDear

Paresh Kanti Paul,We are glad to hear that.

Regards

ExcelDemyHello Dear,

You can download the Excel and PDF files free of cost just by providing your valid email address. To get the files go to the “

Download Excel Formulas Cheat Sheet PDF & Excel Files” section of this post and enter your email address. Then check your email immediately after to get the download links.Best Regards

ExcelDemyDear

Sushil,You are most welcome.

Regards

ExcelDemyDear

Duncan R Walk,You are most welcome.

Regards

ExcelDemyDear

Bolajoko Olufemi,You will get all resources related to Data Analysis here

All About Data Analysis. We are planning to launch courses as soon as possible.Regards

ExcelDemyDear

Ronald,You are most welcome.

Regards

ExcelDemyDear

Ronhat Minmin,If you want to get the Excel File, you can download it from

Download Practice WorkbookRegards

ExcelDemyDear

Ebrahim Ahmadi,You are welcome.

Regards

ExcelDemyHello Dear,

You can download the Excel and PDF files free of cost just by providing your valid email address. To get the files go to the “

Download Excel Formulas Cheat Sheet PDF & Excel Files” section of this post and enter your email address. Then check your email immediately after to get the download links.Best Regards

ExcelDemyDear

Lin Giralt,You are most welcome.

Regards

ExcelDemyDear

Khin Soe,You are most welcome.

Regards

ExcelDemyDear

Tha’ir,You are most welcome.

Regards

ExcelDemyDear

Mohamad,Thanks for your appreciation

Regards

ExcelDemyDear

Minhajul,You are most welcome.

Regards

ExcelDemyDear

Sandeep Bhattacharjee,You are most welcome and thanks for your appreciation.

Regards

ExcelDemyHello

Sujay Jain,You can download the Excel and PDF files free of cost just by providing your valid email address. To get the files go to the

Top 100 MCQ of Excelsection of this post and enter your email address. Then check your email immediately after to get the download links.Best Regards

ExcelDemyDear

S Roy,You are most welcome.

Regards

ExcelDemyHi

Kazem,You are welcome.

Regards

ExcelDemyDear

Lana,You are most welcome.

Regards

ExcelDemyDear Seamus Madden,

Thanks for your appreciation.

Regards

ExcelDemy

Hi Ndonwi,

Thanks

Dera

Merc,You are most welcome.

Regards

ExcelDemyDear

Joanna,You are most welcome.

Regards

ExcelDemyDear Richard,You are most welcome.

Regards

ExcelDemyDear Andrei,

These functions are available in WPS office.

Regards

ExcelDemy

Dear

Kapil,You are most welcome.

Regards

ExcelDemyDear

Tommy Fuifui,You are most welcome.

Regards

ExcelDemyDear

Excel Nob,You are most welcome.

Regards

ExcelDemyDear

Car,You are most welcome.

Regards

ExcelDemyDear

Jamie,You are most welcome.

Regards

ExcelDemyDear

Anitelleth,You are most welcome.

Regards

ExcelDemyDear

Anitelleth,You are most welcome.

Regards

ExcelDemyDear

Kay,You are welcome.

Regards

ExcelDemyDear

Pirooz Rahimi,You are most welcome and thanks for your appreciation.

Regards

ExcelDemyDear

Abel,Thanks for your appreciation. You are most welcome.

Regards

ExcelDemyDear

Kh Paydar,You are most welcome.

Regards

ExcelDemyDear

Joris,You are most welcome. We are glad to hear that.

Regards

ExcelDemyDear

Raja,You are most welcome.

RegardsExcelDemy

Dear

Kapil,Thanks for your appreciation.

Regards

ExcelDemyDear

Polepeddi Sasidhar,We are glad to hear that.

Regards

ExcelDemyHello

Silpa,Download Excel Formulas Cheat Sheet PDF & Excel Files” section of this post and enter your email address. Then check your email immediately after to get the download links.Best Regards

ExcelDemyDear

Jidith Savidge,You are most welcome.

Regards

ExcelDemyDear

Ajij Nadaf,We will love to give you suggestions. kindly share your problem.

Regards

ExcelDemyGood day,

Daniel,The issue you’re having might be because your workbook’s data range differs from the data range specified in our code.

Change the data range according to your worksheet.

This might be the solution to your issue. I’d appreciate it if you could send me the worksheet you’re working on so that I can better understand your issue and give you an exact solution.

Regards

Sakibul Hasan Nahid | ExcelDemy TeamHey

Philip,Thanks for your response. You can use the

SORTandFILTERfunctions along with theLARGEfunction to solve your problem.Here’s the practice sheet we used. You can check it out for a better understanding.

SORT-FILTER.xlsx

You can also check out this article for more detailed explanations.

https://www.exceldemy.com/excel-top-10-list-with-duplicates/

Regards

Hassan Shuvo| ExcelDemy TeamHello

Chandan,Thanks for commenting. If I’m not wrong, you want to match the dataset like the one below.

Select the entire dataset without the heading then go to conditional formatting >> New Rule

Then select “Use a formula to determine which cells to format.”

In the formula bar, enter the following formula:

=AND(A3<>B3,C3<>B3)Press OK

Here, “A3” represents the cell containing the customer name, “B3” represents the cell containing the ID name, and “C3” represents the cell containing the real name. You can adjust the cell references based on your data.

Choose the formatting option that you want to use for the highlighted rows. For example, we took light green color here for highlighting.

The final outcome will look like the image below.

I hope this answer will help you to identify matched names. Please let us know if you have any other queries. Also, you can post your Excel-related problem in ExcelDemy Forum with images or Excel workbooks.

Regards

Mizbahul Abedin | ExcelDemy TeamDear

MD. KAMAL HOSSAIN,To obtain your required format please follow the following simple steps:

From your Excel Workbook, press ALT + F11 to open Visual Basic Editor.

Insert a module.

Paste the following code:

Now, return to your worksheet. Type in the following formula in the cell where you require the output and press Enter key.

=NumberToWords(B5) & ” Taka Only”Here, B5 indicates the reference of the cell where you have the input number.

I hope this solution will be sufficient for your requirements. Let us know your feedback.

Regards,

ExcelDemyDear

Rich Saunders,Query 1:The method 7 works just fine. If you write March in F4, you will get the values for that month as well.Query 2:The formula is universal for any Excel version. If you write the formula in any cell the formula will get you the entire row value for the name you will write in the F4 cell. For example, if you write “Nathan” in F4 cell and paste the formula in the A1 cell then the formula will write the values of the entire row( B8:D8) in the A1:A3 range.Yes, we should have mentioned the Ctrl+Shift+Enter in the article. We will make sure of that in the next articles. As we used Microsoft 365 so it works by pressing Enter. We are sorry for that.

Regards

ExcelDemyDear

Tudor,Hope you are doing well. Answer of your questions are given below with explanation.

1. How can I change the month and day from English to Romanian?Select the cell with month and date, cell C7 in our case.

Right-click with the mouse and select Format Cells.

In the Format Cells window, select Romanian (Moldova) under the Locale menu.

Then, select any type under the Type menu and click the OK button.

The month and date are changed into Romanian from English. Do the same process for cell E7.

2. If an employee works on Saturday and/or Sunday, how can I collect those weekend hours separately, in a cell?Let’s say the first employee works on Saturday and Sunday for 5 and 6 hours respectively. He works on 4 weekends which you can see in the picture. To sum these values we’ll use the SUMIFS function.

Apply the formula in any cell where you want the weekend hours, let’s say cell AM11-

`=SUMIFS($F$11:$AJ$11,$F$11:$AJ$11,"<>P",$F$11:$AJ$11,"<>A")`

After pressing Enter you’ll get the total weekend hours. You can use the Fill Handle tool to apply this formula to other employees.

Dear

Aspen,You are most welcome.

Regards

ExcelDemyThanks for your suggestions.

Dear

Victor,You are most welcome.

Regards

ExcelDemyDear

Elizabeth,You are most welcome. We are so glad that our article fulfilled your need.

Regards

ExcelDemyDear

Anjli Gupta,Answers are given in the Solution sheet of Excel File which is in

Download Practice Workbooksection.Regards

ExcelDemyDear

HG,You are most welcome.

Regards

ExcelDemyDear

Seaunders,Thanks for your appreciation. It means a lot to us.

Regards

ExcelDemyDear

Gunawan,Thanks for your suggestions. We updated the article. You can check it now.

Regards

ExcelDemyHi

Fake Hidden,Thanks for your suggestions. We updated our article so that it fulfills the need of all types of readers. You may check our article now and let us know any kinds of suggestions.

Regards

ExcelDemyDear

Rafi,Thanks for your appreciation.

Regards

ExcelDemyDear

Elly,Thanks for your appreciation. We re-explained our formulas to make them more understandable. If you find any difficulty now, let us know in the comment section below.

Regards

ExcelDemyDear

Rashmi,You are most welcome.

Regards

ExcelDemyDear

Jay Dee,That’s good to hear. We are interested to know more from you.

Regards

ExcelDemyDear

Silver,You are most welcome.

Regards

ExcelDemyDear

William B,You are most welcome.

Regards

ExcelDemyDear

Eugen Safta,You are most welcome.

Regards

Shamima Sultana | ExcelDemyDear Radu,

Thanks for your suggestion and we appreciate it. We updated the cell range.

Dear

Sanket,Thanks for your appreciation.

Regards

Shamima SultanaProject Manager | ExcelDemy

Dear

Yar Zar Htun,You are most welcome. We are glad that through

ExcelDemyyou are improving your skill.Regards

Shamima SultanaProject Manager | ExcelDemy

Dear

Vivasvan,You are most welcome. It’s great to know that our article helped you to complete your project.

Regards

Shamima SultanaProject Manager | ExcelDemy

Dear

Bo Thibaut,We are willing to do any Excel-related projects. Kindly share your requirements through this Email: [email protected]

Regards

Shamima SultanaProject Manager | ExcelDemy

Hi

Robert Bakinam,Here, you will get the full copy in pdf

Marking Result Sheet.Regards

Shamima SultanaProject Manager | ExcelDemy

Dear

German,You are most welcome. To get solutions with detailed explanations, followExcelDemy.Regards

Shamima SultanaProject Manager | ExcelDemy

Dear

Kirsten Wheeler,Thanks for your appreciation. To get solutions with detailed explanations, followExcelDemy.Regards

Shamima SultanaProject Manager | ExcelDemy

Dear

NancyM,Thanks for your appreciation. To get solutions with detailed explanations, follow

ExcelDemy.Regards

Shamima SultanaProject Manager | ExcelDemy

Dear

CJvW,Thanks for your appreciation. To get more helpful content be with

ExcelDemy.Regards

Shamima SultanaProject Manager | ExcelDemy

Dear

Geogre,Thanks for your kind attention and suggestion. We updated it.

Dear

Michael Gamal Aziz,You are most welcome.

Regards

Shamima SultanaProject Manager | ExcelDemy

Dear

Glenn,We are glad to hear that. ExcelDemy is trying hard to give you quality content.

Regards

Shamima SultanaProject Manager | ExcelDemy

Dear Uday Kumar,We are working on your problem. We will appreciate you to post your problem in our

ExcelDemy Forum.Regards

Shamima SultanaProject Manager | ExcelDemy

Dear

Ramandeep Kaur,Thanks for your appreciation. Sooner we will make another exercise based on

Basic and Advanced Formulas.Regards

Shamima SultanaProject Manager | ExcelDemy

Dear

Datla Srinivas,We are working on your requirements. We hope we will come back to you with your expected solutions.

Regards

Shamima SultanaProject Manager | ExcelDemyDear

Mody,Thanks for your appreciation.

Regards

Shamima Sultana | Project Manager | ExcelDemyHello

Joanie,You are most welcome.

Regards

Shamima Sultana | Project Manager | ExcelDemyDear Map,

Thanks for your appreciation and suggestion. Sooner we will write an article regarding this topic.

Regards

Shamima Sultana | Project Manager | ExcelDemyDear

Ven Upekkha,Thanks for your appreciation.

Regards

Shamima Sultana | Project Manager | ExcelDemyDear

Rajesh,You are welcome.

Regards

Shamima Sultana | Project Manager | ExcelDemyDear

umit,Thanks for your appreciation it means a lot to us.

Regards

Shamima Sultana | Project Manager | ExcelDemyHello

Zuri,Thanks for your suggestion.

Regards

Shamima Sultana | Project Manager | ExcelDemyDear

Carl,Thanks for your appreciation.

ExcelDemyis glad to help you.Regards

Shamima Sultana | Project Manager | ExcelDemyDear

Sandra Aldridge,Thanks for your appreciation it means a lot to us.

ExcelDemyis glad to help you.Regards

Shamima Sultana | Project Manager | ExcelDemyDear

Micah,Thanks for your kind words.

ExcelDemyis dedicated to provide solutions to help you.Regards

Shamima Sultana | Project Manager | ExcelDemyDear

Mukibul Hasan,Thanks for your appreciation. Stay in touch with

ExcelDemy.Regards

Shamima Sultana | Project Manager | ExcelDemyDear

Shanmuga Raja V S,Thanks for your appreciation. Stay in touch with

ExcelDemy.Regards

Shamima Sultana | Project Manager | ExcelDemyDear

Adam,Thanks for your appreciation.

Shamima | Project Manager | ExcelDemyDear

Zidane,Thanks for your appreciation.

Shamima | Project Manager | ExcelDemyDear

Kayla,Thanks for your appreciation and we are glad that our Dataset Template helped you.

Regards

Shamima | Project Manager | ExcelDemyHello Uday Kumar,

Kindly check the reply to your previous comment. We have given you a non-macro solution.

Dear

Forte,Thanks for your appreciation. Stay in touch with ExcelDemy to get more helpful content.

Regards

Shamima | Project Manager | ExcelDemyDear

Gilson,Thanks for your appreciation. Stay in touch with ExcelDemy to get more helpful content.

Regards

Shamima | Project Manager | ExcelDemyDear

Gerry Conroy,You are most welcome.

Regards

Shamima | Project Manager | ExcelDemyDear

Syed Anwar Hussain,Thanks for your appreciation.

Regards

Shamima | Project Manager | ExcelDemyHello,

Xzavier!For better understanding, we updated the article. Kindly check it now it would be helpful.

Regards

ExcelDemyHello,

An!You are most welcome. To get helpful content follow

ExcelDemy.Regards

ExcelDemyHello,

James!Your appreciation means a lot to us. To have a more wonderful experience follow

ExcelDemy.Regards

ExcelDemyHi

Rassulsson!Thanks for your appreciation.

Regards

ExcelDemyThanks, Michael, for your query. From your comment, it seems that you want to permanently assign the replacing dataset (denoted by Reprng in the code) instead of taking them in a prompted input box. You can do that by following the steps below.

1. First, set a Name to the range that contains the Find & Replace with columns (In this case E5:F6). To do that, select the range and type a suitable name on the Name Box. Suppose you give the name “Find_Replace_Array”

2. Now, open a new module and write the given code of method 1.

3. Then, on the code, replace the line :

Set Reprng = Application.InputBox(“Replace with: “, Title, Type:=8)

With the following line.

Set Reprng = Range(“Find_Replace_Array”)

Now, if you run the code, you will only need to select the range where you want to replace values and it will automatically replace the values for you. Here, you will not be required to manually input the address of Find_Replace_Array.

Hope it does the job for you. If you have any further queries, do let us know. Moreover, if your problem persists, you can post your problem in our Exceldemy Forum along with your Excel file.

Hello,

Hamza!Thanks for your appreciation. We are glad that our article helped you.

Regards

ExcelDemyHello, A!

If your file is protected by using

Encrypt with Passwordfeature then it won’t work. We mentioned it in theThings to Remembersection.Regards

ExcelDemyHello,

Nabil sellami!Thanks for your appreciation. To get more enjoyable articles stay in touch with

ExcelDemy.Regards

ExcelDemyHello,

JeteMc!Welcome, JeteMc. To get more helpful information stay in touch with

ExcelDemy.Regards

ExcelDemyHello,

Helen!Thanks for your appreciation. To get more helpful information stay in touch with

ExcelDemy.Regards

ExcelDemyHi,

Irene!Thanks for your appreciation. To get more helpful information stay in touch with

ExcelDemy.Regards

ExcelDemyHi,

Elton!Thanks for your appreciation. We will try to launch pdf files.

Regards

ExcelDemyHello,

Muhammad Luqman!You can download it from Download Excel Formulas Cheat Sheet PDF section.

Regards

ExcelDemyHi,

Bosco!Thanks for your appreciation. To get more informative contents stay in touch with ExcelDemy.

Regards

ExcelDemyHello,

Joe Smith!The 64-bit version of Excel is not compatible with 32-bit active x controls. To know more about it you can visit this site

Regards

ExcelDemyHello,

Aleksandra!Thanks for your appreciation.

Regards

ExcelDemyHello,

Bennie!Thanks for your appreciation.

Regards

ExcelDemyHello, Harry!

You can download the copy from Download Sample Workbook

Regards

ExcelDemy

Hello,

Emil Lazar!Thanks for your appreciation. Stay in touch with

ExcelDemyto get more useful articles.Regards

ExcelDemy