Latest Posts From Nazmul Hossain Shovon
In this tutorial, I am going to show you the step-by-step procedures to create scenarios in Excel. The Scenario Manager can create simple summaries which is a ...
Nazmul Hossain Shovon
We have taken a simple and concise dataset that has 3 columns and 6 records of students' marks to show how to save it as an XLSX file. Method 1 - ...
What Is a Data Model? In Excel, a data model is a collection of data tables. These tables are interconnected through one or more data series, forming a larger ...
In this tutorial, we will demonstrate 3 approaches to calculate college GPA in Excel. What Is GPA? GPA stands for Grade Point Average. It is the ...
In this tutorial, I am going to show you 2 effective ways how to lock table array in Excel. You can apply these methods to any type of dataset and lock them in ...
Method 1 - Using Ampersand Operator Steps: Double-click on cell D5 and type in the following formula: =(B5&” “%C5) Press Enter to ...
In this sample dataset the columns are labelled Name, Marks, and Grades. For the grades, we have 5 possible options. Method 1 - Computing ...
The dataset that we will use to remove the drawing tools contains various shapes as Excel objects. We put in multiple shapes to showcase ...
![[Fixed!] Excel Not Adding Negative Numbers Correctly (4 Solutions)](https://www.exceldemy.com/wp-content/uploads/2022/08/excel-not-adding-negative-numbers-correctly-1-4.png?v=1697354049)
In this tutorial, I am going to share with you 4 possible solutions to the problem of excel not adding negative numbers correctly. These solutions are quick ...
Method 1 - Opening CSV File in Excel Open the CSV file in Excel. Note down the heading of each column. This will be required to create the ...
In this tutorial, we will present 5 practical examples of how to calculate annuity in Excel. Determining the various aspects of an annuity is a fairly ...
In this tutorial, we'll create a simple Student Attendance sheet with formulas in Excel, that enables recording different students' attendance in a class over ...
Solution 1 - Using Page Break Preview If the Excel Set Print Area feature isn’t working as expected, try this first solution. Page Break Preview provides ...
In this tutorial, I am going to show you 4 quick tricks on how to hide gridlines in Excel when printing a worksheet. Although Excel hides the gridlines when ...
Method 1 - Using Page Layout View Style to Insert Page Number Steps: Go to the View tab and from the Workbook Views section, select Page Layout. ...
See Our Reviews at
Hi Shruti,
I have attached an Excel file that you can use to find specific absent dates. Hope it helps!
Download link
Hi Maikel,
Can you share your Excel file with us, kindly? So that we may have a look at it and give you some suggestions.
Hi Cory,
You can follow the steps below for this:
1. Fill up the information in the pdf file. Then go to File >> Save as Text. This will create a file in .txt format.
2. Now open an Excel sheet. Go to the Data tab. Here in the top left corner, click on From Text/CSV and select the text file you just saved.
3. Finally in the next window, click on Load and this should bring the filled-in information as well.
Hope this helps!
Hi Mike,
You can try the following steps to change the date format in excel comments:
1) Type intl.cpl in the Windows Search Box.
2) Now, under Date and time formats, click on the Short date drop-down and choose the date format that you want to use in the comments in excel.
Hi James,
Thanks for your correction. To add, you can also calculate the GST amount using this formula:
GST Amount =
(C4*C5)/(1+C5)Then we can deduct this value of cell C6 from C4 to get the original price in cell C7.
Hi Brijesh,
I have created a simplified solution below. Please follow them:
1. I am assuming that you have a Sheet1 like below:
2. Now, go to the Sheet2 and insert the following formula in cell C5:
=IFERROR(VLOOKUP(Sheet1!$B$5,B5:B12,1,FALSE),"Not Found")3. Now, simply copy this formula down using Fill Handle and this should tell you whether the product in cell B5 inside Sheet1 exists in the Product List column or not.
Hi KARLHEINZ,
Looks like you have missed the <> symbol in the SMALL(IF((LEN($H$6:$H$13)0) portion of the formula. The correct formula should be this:
SMALL(IF((LEN($H$6:$H$13)<>0)
I hope this solves your problem. Please let us know if you face any other issues.