Latest Posts From Nazmul Hossain Shovon
In this tutorial, I am going to show you 4 effective ways to put negative percentage values inside brackets in excel. You can use these methods even in large ...
Nazmul Hossain Shovon
![[Fixed!] Excel AutoSum Not Working (4 Possible Solutions)](https://www.exceldemy.com/wp-content/uploads/2022/10/excel-autosum-not-working-3.png?v=1697437443)
In this tutorial, I am going to show you 4 possible solutions to Excel AutoSum not working. You can quickly use these fixes even in large datasets to solve ...
In this tutorial, I am going to show you 6 simple methods of how to get cell value by address in Excel. You can quickly use these methods even in large ...
In this tutorial, I am going to share with you step-by-step procedures to make a class schedule on Excel. This can be very helpful if you are a teacher or ...
In this tutorial, I am going to share with you step-by-step procedures to make first derivative graph on Excel. Also, throughout this tutorial, you will learn ...
In this tutorial, I am going to show you 3 simple methods on how to apply a formula to an entire column using Excel VBA. These methods will save a large ...
When working with large data sets, there may be hidden cells that are not displayed on the screen, and selecting these cells along with the visible ones can ...
In this tutorial, I am going to share with you 6 quick tricks to reverse a number in excel. You can easily apply these methods whether the numbers are small or ...
In this tutorial, I am going to show you 5 simple methods to solve a polynomial equation in Excel. You can use these methods to solve simple polynomial ...
In this tutorial, I am going to show you step-by-step procedures to remove GST from the total amount in Excel. If you own a business, then you might be facing ...
In this tutorial, I am going to share with you 5 suitable ways to save a copy of an Excel file in XLSX format using VBA. You can use these methods in any type ...
In this tutorial, I will show you 2 quick tricks to remove a table from the data model in Excel. These methods are simple and do not require the use of any ...
In this tutorial, I am going to show you 3 handy approaches to calculate college GPA in excel. You can use these methods to find out the GPA of any number of ...
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 ...
In this tutorial, I am going to share with you 3 simple methods on how to undo text to columns in Excel. Sometimes, you may not want to split your dataset into ...
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.