About author
## Designation

Junior Software Developer for the Excel Add-in project
## Lives in

Dhaka, Bangladesh.
## Education

B.sc in Industrial and Production Engineering (IPE), Bangladesh University of Engineering and Technology.
## Expertise

VBA, VB.Net, Microsoft Office, Content Writing.
## Experience

## Summary

Zahid Hassan, BSc, Industrial and Production Engineering, Bangladesh University of Engineering and Technology, has worked with Exceldmy for 1.5 years. He has written 95+ articles for Exceldemy. He has worked as an Excel & VBA Content Developer. He also worked as a VBA Developer for the Template team. Currently, he is working as a Junior Software Developer for the Excel Add-in project. He is interested in Software Development, Python, VBA, VB.NET, and Data Science, expanding his expertise in these domains.

- Technical Content Writing
- Junior Software Developer

- Currently working as Junior Software Developer for the Excel Add-in project of ExcelDemy
- Started technical content writing in Excel & VBA in June 2022 and now working as a Junior Software Developer.

Method 1 - Calculating Central Tendency and Variability The above dataset marks of 7th-grade students are given based on Math, History, Science, ...

Zahid Hasan
Jul 7, 2024

Method 1 - Create 2-D Pie Chart Select any cell of the dataset >> go to the Insert tab >> select the Insert Pie or Doughnut Chart option from ...

Zahid Hasan
Jun 4, 2024

Let’s say we have the Laptop Prices in the Micro Center Store as our dataset. We will use various filters based on cell values to filter the Pivot Table. ...

Zahid Hasan
Jun 12, 2024

The VBA VLookup Function and the Named Range Summary of the VBA VLookup Function The VBA VLookup function finds a specified value from the first column of ...

Zahid Hasan
Aug 13, 2024

Scenario Imagine we have an empty dataset for ABC Company’s sales data. Our objective is to populate this dataset using data validation with checkbox ...

Zahid Hasan
Jul 13, 2024

This is an overview: The DPRODUCT Function in Excel Syntax: =DPRODUCT(database,field,criteria) Arguments: ...

Zahid Hasan
Aug 14, 2024

If we delete some data from the source table of a Pivot Table, in the Pivot Table that data will still be available because the deleted cells are still present ...

Zahid Hasan
Jul 22, 2024

We have the Addresses of Employees of a Company as our dataset. We have information on the Street and the City for each employee. We will do a union of these ...

Zahid Hasan
Jul 29, 2024

Method 1 - Using Convert Option Steps: Go to the File tab from Ribbon. The following window will open in your worksheet. Select the Info ...

Zahid Hasan
Jul 5, 2024

Method 1 - Utilizing the Parametric Equation of a Circle The parametric equations of a circle are: x = r cos(t) y = r sin(t) x, and y are ...

Zahid Hasan
Aug 8, 2024

Method 1 - Find y Intercept to Calculate Standard Deviation in Excel Find the y-intercept of the given dataset. We can use various functions to find the ...

Zahid Hasan
Jun 25, 2024

The sample dataset showcases the Marks of Grade 6 Students. After opening the Excel file, a warning is displayed: Solution 1 - Using the Document ...

Zahid Hasan
Aug 6, 2024

Method 1 - Using Text Box Command from Insert Tab Steps: Go to the Insert tab from Ribbon. Choose the Text Box option from the Text group. ...

Zahid Hasan
Jul 6, 2024

We have the Store Location of different cars in different stores. The Serial Number follows a RegEx pattern but there are some cars that have the same Serial ...

Zahid Hasan
Jul 10, 2024

Our dataset includes the Addresses of ABC Company employees. Our goal is to find the ZIP Codes from the given addresses. Method 1 - Applying Excel ...

Zahid Hasan
Jul 3, 2024

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

Browsing All Comments By: Zahid Hasan

About ExcelDemy.com

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

I am sorry to hear that. Could you maybe describe which step of the procedure you are having trouble with so that I can clear up any confusions? Both methods worked fine for me. I have got the following output using these methods.

Dear AL,

Thank you for your query. So, your goal is to import data from a

CSVfile that has a column namedIDwith20 digitsin each cell of the column. You can use the following procedure to avoid converting the data into scientific notation while importing theCSVfile.First, create a

CSVfile with the required data. For demonstration, I have used the following data.Now, go to the

Datatab >> click onFrom Text/CSV.Then navigate to your file and select it >> click on

Import.Next, click on the drop-down button >> choose the

Do not detect data typesoption >> click onLoad.That’s it! Your data has been successfully loaded into Excel without any conversion to scientific notation or data loss.

I believe this has addressed your query. If you require additional support, please don’t hesitate to inform us.

Regards

Zahid

ExcelDemy

Hello ROBYRUBYJANE,

Thank you for your query. To create a search box that will search data based on a provided date, you can follow the steps given below.

First, construct a search box and add this code to it.

In this code, “

Sheet9” refers to the specific worksheet containing the data that requires searching based on dates. The code we have used employs the “greater than or equal” operator, indicating that any data with dates preceding the specified date will not appear in the output.I hope this answers your question. If you have any more queries, please please reach out to us.

Regards

Zahid

ExcelDemy

Hello ROBYRUBYJANE,

Thank you for reaching out. If I understand correctly, you are interested in creating a

search boxthat can locate values from another worksheet and transfer them to the current worksheet. To accomplish this, you can use the following steps:Begin by creating a search box, and then add the following code to it.

In this scenario, “

Sheet4” is the worksheet containing the search box, and any copied values will be pasted into the rangeB6:D19of this worksheet. Prior to pasting, the contents and formatting of the destination range will be cleared. “Sheet6” is the worksheet where the specified keyword will be searched for.With these steps completed, your search box is now ready for use.

I hope this helps you to achieve your goal. If you need further assistance in this regard, please let us know.

Regards

Zahid

ExcelDemy

Hello AMIT,

I appreciate your question. I’d like to clarify that in this article, the expression “

Current Volatility” refers specifically toImplied Volatility, rather thanRealised Volatility. When working withOption Probability, it’s generally more advantageous to useImplied Volatilityrather thanRealised Volatilitysince it enables us to make more precise predictions about the projected price range of a stock in the future.I hope this answers your question. If you have any more queries, please let us know.

Regards

Zahid

ExcelDemy

Dear UDAY KUMAR,

Good afternoon! Thank you for reaching out to us. In the following section, I’ve suggested a method for handling your issue.

First, apply this formula in cell

M2.`=LAMBDA(item_name,max_issue,XLOOKUP(SEQUENCE(SUM(max_issue)),VSTACK(1,SCAN(1,max_issue,LAMBDA(a,b,a+b))),VSTACK(item_name,""),,-1))(H2:H5,I2:I5)`

Formula BreakdownIn this formula,

item_namerefers to the cell rangeH2:H5of your provided worksheet, andmax_issuerepresents the cell rangeI2:I5of that worksheet.XLOOKUP(SEQUENCE(SUM(max_issue)),VSTACK(1,SCAN(1,max_issue,LAMBDA(a,b,a+b))),VSTACK(item_name,””),,-1))→ This part of the formula will generate theItem Namesaccording to their maximum issue number.(H2:H5,I2:I5)→ This part is required for specifying the cell ranges foritem_name, andmax_issueparameters of the formula.After applying this formula, you will get an output like this in your worksheet.

Now, select these cells and copy them. Later, paste them as values in the same location.

Now, apply the following formula in adjacent cell

N2and drag theFill Handleup to cellN32.`=RAND()`

After that, select the data of

Column MandColumn N. Then, go to theSort & Filteroption from theHometab and choose theCustom Sortoption from the drop-down.A dialogue box named

Sortwill appear on your worksheet. In theSort byfield, selectColumn N. You can keep the other fields unchanged. Finally, clickOK.Lastly, select the entire

Column Nanddeleteit.After following these steps, you will have a randomized list of

Item Namesfor a month as demonstrated in the following image.I sincerely hope that this resolves the issue that you are facing. If you need any further assistance, please let us know. Have a great day!

Regards

Zahid Hasan

ExcelDemy

Dear Mohtasham,

Thank you for your query. You wanted to extract a text value from a cell until a blank space appears in the text. It can be easily achieved by using a combination of

LEFT functionandFIND functionin Excel. The formula is given below.=LEFT(B3,FIND(” “,B3,1))Here, we have our original text in cell

B3. We applied this formula in cellC3.The

FINDfunction will return the position of the first space in the text of cellB3. Then, theLEFTfunction will extract the texts up to that position from the left side of the text. You can drag theFill Handleto copy down the formula for other cells as well. The following image demonstrates the formula and its associated outputs.I truly hope that this answers your question. Again thank you for reaching out to us. Please let us know in the comments area if there is anything about this approach that is unclear to you. I wish you all the best!

Regards

Zahid Hasan

ExcelDemy

Dear Uday Kumar,

Good day! I can comprehend how upsetting this situation could be. It took me a while to understand it, too. Hence, the portion of your formula that I have highlighted in the following figure is essentially what is causing the issue when doing

Conditional Formatting.It will display an error in the

Conditional Formattingwhen you specify a range using both acell referenceand aformula. As the goal of this formula is to add up to the cell that comes before the active cell, you can use the following formula instead. Here I simply replacedINDEX(B$3:B3,ROWS(B$3:B3)-1)byB2. The complete formula is:=AND(SUM(B$3:B3)>B$35, IF(ROWS(B$3:B3)<>1, SUM(B2:B$3)<=B$35, TRUE))Just paste this formula in the

Conditional Formattingoption and you will have your desired output as shown below.That should take care of your problem, I hope. If you run into any problems, please let us know.

Regards

Zahid Hasan

ExcelDemy

Good day, Don Rogers.

Thank you for your feedback. Could you please share your excel file with me so that I can better understand your problem and provide you with a solution? You can shareyour file to the email address provided below.

[email protected]

Thank you!

Dear Uday Kumar,

Good afternoon! First of all, thank you for the detailed description of the problem. What I have understood from your email, is that you want to highlight the cell where the sum of the distributed

X itemscrosses thePrevious Balance.Using the Excel formula in this situation becomes quite complicated and returns errors when used in the

Conditional Formattingoption. But running a simpleMacrocan achieve your desired output without any hassle.If you don’t know how to run a Macro, don’t worry. It’s not that complicated at all. Just follow the steps below, and you will be good to go.

Step 01: Create a Blank ModuleAt first, you will need to create a blank

Module. TheModuleis where we will write the code. Simply pressALT + F11on your keyboard to open the following window on your worksheet.Now, go to the

Inserttab and choose theModuleoption from the drop-down list.Step 02: Write and Run VBA CodeNow, a blank

Modulewill be created.Then, copy the following code and paste it into the blank

Module.After that, click on the

Saveicon.Following that, close the VBA window or simply press

ALT + F11. This will take you back to your worksheet.Now, carefully select the range of data.

Then, go to the

Developertab and click on theMacrosoption.Subsequently, the

Macrodialogue box will open.Now, select the

inventory_checkoption and click onRun.Then a window will appear asking you for the

Previous Balance. You need to enter the previous balance here and then clickOK.Boom! The highlighted cell will indicate your desired output.

You can change the

Previous Balanceaccording to your need and the highlighted cell will be changed accordingly.Things to Remember

If you don’t have the

Developeroption enabled thenfollow this article to enable it.Don’t forget to save the file as

Macro Enabled Workbook.I sincerely hope that this solves the issue you are facing. If any part of the solution is unclear to you, please let us know.

Regards

Zahid Hasan

ExcelDemy