Latest Posts From Nazmul Hossain Shovon
In this tutorial, I am going to show you 3 suitable ways to compute grades in excel. Although you can manually create a grade sheet, using excel will make the ...
Nazmul Hossain Shovon
In this tutorial, I am going to show you 3 easy methods to remove drawing tools in Excel. A lot of times when you copy any data from other sources, there might ...
In this tutorial, I am going to show you step-by-step procedures to convert CSV to XML in Excel. CSV files store data in a comma-separated values format. ...
In this tutorial, I am going to show you 5 practical examples of how to calculate annuity in Excel. Finding out the various aspects of an annuity is a fairly ...
In this tutorial, I am going to show you how to create student attendance sheets in Excel with formulas in a few easy steps. This type of monthly attendance ...
![[Fixed!] Excel Set Print Area Not Working (2 Possible Solutions)](https://www.exceldemy.com/wp-content/uploads/2022/08/excel-set-print-area-not-working-2-1.png?v=1697354448)
In this tutorial, I am going to show you 2 possible solutions to the problem Excel set print area not working. A lot of times after you have set a printing ...
In this tutorial, I will show you 7 easy methods to insert a page number in Excel. Obviously, adding page numbers to the document will make it easier to ...
In this tutorial, I am going to share with you 7 quick tricks to add text to the beginning of a cell in Excel. You may need to append extra text in a data cell ...
In this tutorial, I am going to show you 3 quick tricks on how to show only the working area in excel. Removing the unused cells from the worksheet makes it ...
In this tutorial, you will learn some easy methods on how to remove the page 1 watermark that appears in Excel workbooks. Although a watermark is sometimes ...
In this tutorial, you are going to learn a quick but very important method to convert number to text format in Excel with apostrophe. Furthermore, this method ...
In this tutorial, I am going to share with you 5 quick and simple methods to align shapes in Excel. When we talk about aligning, there are many ways we can use ...
In this tutorial, I am going to show you 3 suitable ways to find the equation of a trendline in Excel. A trendline equation is basically a formula of a line ...
In this tutorial, you will learn some valuable techniques to color your Excel Bubble Chart based on its value in the dataset. Because complex datasets are hard ...
In this tutorial, you will learn various easy methods to create graphs in Excel with multiple columns. Vertical bars are used in column charts to compare ...
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.