# Fahim Shahriyar Dipto

Fahim Shahriyar Dipto is a graduate of Mechanical Engineering at BUET. With over 1.5 years of experience at Exceldemy, he authored 70+ articles on ExcelDemy. He has expertise in designing worksheets at You’ve Got This Math. Currently, He is a Team Leader at Brainor. Dipto's passion extends to exploring various aspects of Excel. Beyond tech, he enjoys creating engaging kids' worksheets using Illustrator. A dedicated employee and innovative content developer, He incorporates a commitment to academic excellence and tech-driven creativity.

## Designation

Team leader at Brainor in SOFTEKO.

## Education

B.sc in Mechanical Engineering (ME), Bangladesh University of Engineering and Technology.

## Expertise

Content Writing, Autocad, Solidworks, Adobe Illustrator, 3E Plus, Homer Energy for Microgrid, Microsoft Office, Visual Basic for Application (VBA), Data Analysis.

## Experience

• Technical Content Writing
• Team Management
• Trainee at Khulna Shipyard
• Mechanical Engineer
• HVAC Cooling System and Instrumentation.
• Expertise in Automobile Engineering.
• Microgrid Power Optimization in Homer Energy.
• Shell and Tube Heat Exchanger.
• Automated Paper Cutter.
• Amphibious Vehicle in Solidworks.
• Biogas Power Generation with KUBOTA Duel Fuel Generator.

## Summary

• Currently working as Team Leader of Brainor.
• Started technical content writing of Excel & VBA in August 2022 and later shifted as a content developer at You’ve Got This Math.
• Worked as a trainee in Khulna Shipyard.

## [Fixed] QUADF Not Working in Excel

Sometimes, you may need to estimate Excel's proper or improper integrals. There is no built-in software in Excel for computing the integrals. However, you can ...

## How to Count Alphabet in Excel Sheet: 5 Easy Methods

Method 1 - Using the LEN Function Steps: Go to cell C5 and insert the following formula. =LEN(B5) The syntax counts the letters of the ...

## How to Make a Wind Rose in Excel: 2 Easy Methods

There are two possible ways to make a wind rose in Excel. We have a dataset of Wind Speed with their Direction for a specific time. Method 1 - Using ...

## How to Create a Tooltip in Excel Chart (Easy Steps)

What is a Tooltip? Tooltip is a message or note that appears when the mouse pointer rests on an icon or any graphical interface. In Microsoft Excel, you can ...

## How to Create a 4-Variable Data Table in Excel (with Easy Steps)

A data table in Excel enables you to experiment with various formula input values and observe how these changes impact the formula's output. Whenever you work ...

## How to Create Animated Charts in Excel (with Easy Steps)

We have taken a dataset of monthly sales for 3 consecutive years: 2020, 2021, and 2022. We will generate a chart that changes automatically. Step 1 ...

## How to Calculate Option Greek Delta in Excel – 4 Steps

What Are Option Greeks? Option Greeks are monetary indicators of how sensitive the price of an option is to the factors that determine it, such as ...

## How to Encrypt Cell Content in Excel – 2 Methods

The dataset showcases Account Names, Card Numbers, and passwords. To encrypt the Password:   Method 1 - Applying VBA Macros to ...

## How to Make a Recalculate Button in Excel (5 Easy Steps)

The Recalculate button allows you to update formulas in your dataset. If you’re using volatile functions that change over time, you’ll need to recalculate the ...

## How to Add 2 Years to a Date in Excel – 3 Easy Methods

The dataset showcases Students' Admission Dates. To add 2 years to these dates:   Method 1 - Utilizing an Arithmetic Formula A year ...

## How to Show Data Labels in Thousands in an Excel Chart – 4 Steps

How to Edit Data Labels in Excel You can edit data labels and customize them in Excel. Select the data labels and go to format data labels. ...

## How to Show Only Dates with Data in an Excel Chart (3 Steps)

Here, we have taken a dataset of “Date-wise Sales” of “Sales Rep.” We want to create a chart showing the dates, but they are not displaying in our chart. We ...

## How to Create a Subtraction Formula in Excel – 7 Methods

The sample dataset showcases Employee's Salaries and Expenses.   Method 1 - Subtraction Between Two Cells Using Generic Formula Use  a ...

## Using the Excel COUNTIF to Count Cells That Contain Text from other Cells

You can use the COUNTIF function to count a cell that contains text from another cell in Excel. This is the sample dataset.   1. ...

## How to Copy and Paste a Column in Excel – 5 Methods

This is the sample dataset. You want to copy column B and paste it into another column.   Method 1 - Using a Keyboard Shortcut  Steps: ...

Browsing All Comments By: Fahim Shahriyar Dipto
Fahim Shahriyar Dipto Dec 1, 2022 at 2:28 PM

Hello Ken K,
Thanks for your feedback. The Print Title options including Rows to Repeat are always disabled in the Print Preview’s page setup. Display the spreadsheet in Normal view, go to the Page Layout tab and click on Print Titles. You may check whether your worksheet is protected or not. If you are facing the same problem then your problem may be quite exceptional. So, we can not solve the problem without your Excel file. You can share your Excel file via [email protected].
Hopefully, we will be able to solve your problem. Keep supporting us.
Regards,
Fahim Shahriyar Dipto
Excel & VBA Content Developer.

Fahim Shahriyar Dipto May 3, 2023 at 5:13 PM

To calculate the monthly lease payment in Excel, you can use the following formula:
=PMT(rate/12,nper,-PV,FV)
where:
rate = the interest rate per period (in this case, 20% divided by 12 for monthly payments)
nper = the total number of periods (in this case, 36 months)
PV = the present value of the lease (in this case, the selling price plus maintenance and repair costs, or Rs 28440 + Rs 4500 = Rs 32940)
FV = the future value of the lease (in this case, the residual value, or 7.5% of the selling price, or Rs 2133)
In our dataset, in Cell C11 we entered the below formula.
=PMT(C9/12,C8,(-C6),C7,0)
See the image for better visualization.

Hope you are able to calculate the monthly lease payment now. Have a nice day. Keep supporting us.
Regards,
Fahim Shahriyar Dipto
Excel and VBA Content Developer

Fahim Shahriyar Dipto Mar 9, 2023 at 5:52 PM

Hello Pepe,
Thanks for your feedback. It’s a matter of upset that the Copy and Paste solution is not working in your Excel file. Whereas our method is working smoothly. You have to copy a chart and then paste it on another chart and your work will be done. As per your comment, the method doesn’t work. So, we have attached some steps to do that in an alternative way. Follow the below step.
1. Select the first chart, then right-click and choose “Copy“.
2. Click on the second chart to activate it.
3. Right-click on the chart area and choose “Paste” from the context menu.
4. You should now have two chart objects overlapping each other. You can resize and reposition them as desired.
5. Select the first chart, then right-click and choose “Format Chart Area” from the context menu.
6. In the Format Chart Area pane, under the Fill & Line tab, choose “No fill” and “No line“.
7. Repeat step 5 and 6 for the second chart.
Now you should have two charts merged into one.
If the above method fails then you can use the below method also.
1. Select the data range for both series.
2. Click on the “Insert” tab and choose “Recommended Charts“.
3. Scroll down to the “Combo” charts section and choose a chart type that suits your needs.
4. Click “OK” to create the chart.
5. Right-click on the chart and choose “Select Data” from the context menu.
6. In the “Select Data Source” dialog box, click the “Add” button to add a new series.
7. Select the data range for the second series and click “OK“.
You should now have a single chart with both series displayed.
Hope the above methods will work. If this doesn’t work then please send your excel file to [email protected]
Have a good day!
Regards
Fahim Shahriyar Dipto
Excel and VBA Content Developer.

Fahim Shahriyar Dipto Jan 11, 2023 at 2:31 PM

Hello Anwer,
Thanks for your comment. It is the most common factor when you download a .xlsnm, the code doesn’t work. So, to avoid this consequence follow the steps stated below.
Firstly, download the .xlsm file from the article and right-click on the file. Select Properties.

Then, check the Unblock box and hit OK.

Hopefully, this method solves your issue. If not then change the directory of the file and Rename it at your preference. then the VBA code of the source file will run in the existing worksheet.
Again, if you are facing any obstacle then mail the Excel file to the address.
Regards,
Fahim Shahriyar Dipto
Excel & VBA Content Developer

Fahim Shahriyar Dipto Jan 11, 2023 at 2:00 PM

Hello Terry,
It’s really nice to hear from you. In your query, you wanted to know about changing the plot area where the chart area will be the same. The VBA code needs to be modified a bit. I have attached the code below.
Sub Resize_Chart_Plot_Area()
Dim ch1 As Chart, plot_height As Double, plot_width As Double
Set ch1 = ActiveChart
chart_height = ch1.PlotArea.Height: chart_width = ch1.PlotArea.Width
chart_height = ch1.PlotArea.Height: chart_width = ch1.PlotArea.Width
ch1.PlotArea.Height = 150: ch1.PlotArea.Width = 400
End Sub
Run the code with the F5 key and it will change the plot area without changing the plot area.
Have a great day.
Regards,
Fahim Shahriyar Dipto
Excel & VBA Content Developer.

Fahim Shahriyar Dipto Dec 28, 2022 at 11:35 PM

Hello Jim,
Thanks for commenting. If I am not wrong, you want to sort dates that don’t have the dollar like the dataset below.

Select the entire data range then navigate the Home tab >> choose Sort & Filter from #diting group >> pick Filter.

Choose the Filter dropdown and uncheck the blanks from the column.

Finally, the dates are sorted with the dollar.

Regards
Fahim Shahriyar Dipto
Excel & VBA Content Developer

Fahim Shahriyar Dipto Dec 28, 2022 at 3:30 PM

Hello Javate,
Thanks for commenting. Your query is similar to reverse names. You can do that in one column. For this, go to cell C5 and insert the following formula.
=MID(B5&","&B5,SEARCH(".",B5)+1,LEN(B5)+1)
You have to use the MID, SEARCH, and LEN functions combinedly. You will get the output like the image below after pressing ENTER.

You can follow the Reverse Names in Excel article to get the proper idea also.

Fahim Shahriyar Dipto Dec 28, 2022 at 2:16 PM

Hi Nathan,
Thanks for your valuable feedback. If I am not wrong, you want to count the characters without the symbols. For this factor, we have taken a sentence that contains commas. To remove the commas and count the characters insert the following formula in cell C5.
=LEN(SUBSTITUTE(B5," ",""))-LEN(B5)+LEN(SUBSTITUTE(B5,",",""))
Press ENTER and get the following output.

It counts the total characters without commas.

Fahim Shahriyar Dipto Dec 20, 2022 at 5:27 PM

Hi Quang,
Thanks for your feedback. You are right on this occasion. The formula will be =(D15+E15)*F12 in G16. unfortunately, we have made a mistake here. Thanks to you that you corrected us. We have updated the article.
Best wishes to you.
Regards
Fahim Shahriyar Dipto
Excel & Content Developer.

Fahim Shahriyar Dipto Dec 20, 2022 at 5:21 PM

Hi Anna,
Thanks for commenting. There are 13 commands under the Interior application. When you put a dot (.) after the Interior application you will find the commands. there are Color, Colorindex, Pattern, ThemeColor, etc in the command section. But all the commands have the built-in color code that’s why you won’t be able to choose a specific color using this code. but while you working with blanks you can insert the RGB command and the Custom Color Code. In our case, it is not possible as we have to maintain the same color for the duplicates. Hope, you understand our answer.
Regards,
Fahim Shahriyar Dipto
Excel & VBA Content Developer.

Fahim Shahriyar Dipto Dec 20, 2022 at 3:51 PM

Hello Sumeet,
Thanks for commenting. You can download the Excel file and also the Pdf file of all the formulas Cheat Sheet. For your betterment, we attached the Excel file and Pdf File links here also.

Fahim Shahriyar Dipto Dec 8, 2022 at 1:44 PM

Hello Espen,
First of all, thanks for commenting. it’s unfortunate that we don’t explain the line-shifting issues in this article. If I am not wrong, I think you are talking about the case like the image below.

For resolving the issue you can follow the procedure described in the method of Converting Word to Excel without splitting cells.You will get the result like the image below.

Hopefully, you will understand the steps mentioned in the link and solve your issue.
Have a nice day!
Regards
Fahim Shahriyar Dipto
Excel & VBA Content Developer

Fahim Shahriyar Dipto Dec 8, 2022 at 12:12 PM

Hello Maurice,
Thanks for your feedback. In your query, as you wanted to create the combination for 3 columns and five rows, you have to change the VBA code variables to X1, X2, and X3. Also, you need to change the row range. Don’t worry, We have added the code for your betterment. Follow the code and your work will be done.
Sub CombinationsFor3Columns()
Dim X1, X2, X3 As Range
Dim RG As Range
Dim xStr As String
Dim FN1, FN2, FN3, FN4 As Integer
Dim SV1, SV2, SV3, SV4 As String
Set X1 = Range("B5:B9")
Set X2 = Range("C5:C9")
Set X3 = Range("D5:D9")
xStr = "-"
Set RG = Range("D5")
For FN1 = 1 To X1.Count
SV1 = X1.Item(FN1).Text
For FN2 = 1 To X2.Count
SV2 = X2.Item(FN2).Text
For FN3 = 1 To X3.Count
SV3 = X3.Item(FN3).Text
RG.Value = SV1 & xStr & SV2 & xStr & SV3
Set RG = RG.Offset(1, 0)
Next
Next
Next
End Sub
Hope the above code solves your problem. Keep supporting us.
Regards
Fahim Shahriyar Dipto
Excel & VBA Content Developer

Fahim Shahriyar Dipto Dec 1, 2022 at 10:04 AM

Hello Fred,
Thanks for your appreciation. You can also do it for 4 columns also. All you need to change is the variable, integer and string. Without these changes, all the other code will be the same as before. We also provide the VBA code for the 4 columns below.
Sub CombinationsFor4Columns()
Dim X1, X2, X3, X4 As Range
Dim RG As Range
Dim xStr As String
Dim FN1, FN2, FN3, FN4 As Integer
Dim SV1, SV2, SV3, SV4 As String
Set X1 = Range("B5:B7")
Set X2 = Range("C5:C7")
Set X3 = Range("D5:D7")
Set X4 = Range("E5:E7")
xStr = "-"
Set RG = Range("H5")
For FN1 = 1 To X1.Count
SV1 = X1.Item(FN1).Text
For FN2 = 1 To X2.Count
SV2 = X2.Item(FN2).Text
For FN3 = 1 To X3.Count
SV3 = X3.Item(FN3).Text
For FN4 = 1 To X4.Count
SV4 = X4.Item(FN4).Text
RG.Value = SV1 & xStr & SV2 & xStr & SV3 & xStr & SV4
Set RG = RG.Offset(1, 0)
Next
Next
Next
Next
End Sub
Hope the above code solves your problem. Keep supporting us.
Regards
Fahim Shahriyar Dipto
Excel & VBA Content Developer

Fahim Shahriyar Dipto Nov 30, 2022 at 4:29 PM

Hello Euliin,
Thanks for commenting on our website. You can highlight a cell containing any random value with Conditional Formatting. Follow the steps.
Firstly, select the entire row that you want to be highlighted. Then go to the Conditional Formatting and choose New Rule.

Now, New Formatting Rule dialog box appears. Choose Use a formula which cells to format. Write the formula in the box in the Format values where this formula is true.
=OR(ISTEXT(B5),ISNUMBER(B5))
And click on Format.

Now, Format Cells appears. Pick a color and hit OK.

Now, again hit OK in the New Formatting Rule box.

Finally, as you see you can highlight the row.

Fahim Shahriyar Dipto Nov 30, 2022 at 3:58 PM

Hello Mr. Wilson,
Thanks for your valuable comment. If you want to paste only the value you can do it through Paste Special feature.
Firstly, create a dataset with the RANDBETWEEN function.

Whenever you press anything opening the file the numbers refresh automatically.

But, after copying the column with the CTRL + C key, right-click on the cell and choose Paste Special.

Paste Special dialog box appears. Check the Valuebox there and hit OK.

Finally, you have pasted the values without dragging anything.

I hope you got the solution. keep supporting us.
Regards,
Fahim Shahriyar Dipto
Excel & VBA content Developer.

Fahim Shahriyar Dipto Nov 30, 2022 at 3:38 PM

Hello Siti,
First of all thanks for your feedback. You can follow the below article to solve your problem. Go through it and you will get the solution hopefully.

You can also use the following VBA code to merge multiple sheets into one and into separate sheets. But you have to put all the files into a specific folder and paste the folder path into the code. (mentioned in the article).
Sub ConsolidateFiles()
Dim FileList, CurrentF As Variant
Dim nFiles, nSheets As Integer
Dim cSh As Worksheet
Dim cWB, sWB As Workbook
FileList = Application.GetOpenFilename(FileFilter:="Microsoft Excel Workbooks (.xls;.xlsx;.xlsm),.xls;.xlsx;.xlsm", Title:="Choose Excel files to merge", MultiSelect:=True)
If (vbBoolean <> VarType(FileList)) Then
If (UBound(FileList) > 0) Then
nFiles = 0
nSheets = 0
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Set cWB = ActiveWorkbook
For Each CurrentF In FileList
nFiles = nFiles + 1
Set sWB = Workbooks.Open(Filename:=CurrentF)
For Each cSh In sWB.Sheets
nSheets = nSheets + 1
cSh.Copy after:=cWB.Sheets(cWB.Sheets.Count)
Next
sWB.Close SaveChanges:=False
Next
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
End If
End If
End Sub
I hope you can get what you want after using the code. thanks again and keep supporting us.
Regards,
Fahim Shahriyar Dipto
Excel & VBA content Developer.

Fahim Shahriyar Dipto Nov 24, 2022 at 2:00 PM

Hello Edho,
Thanks for your feedback. Though the question is quite unclear to us but we have tried another code for your working purpose.
Sub X()
Set DataSet = Range("B4:D13")
Interval = 3
N = 4
FormulaColumn = 3
R = DataSet.Rows.Count
If R Mod Interval <> 0 Then
Ending = R + (Int(R / Interval) * N)
Else
Ending = R + ((Int(R / Interval) - 1) * N)
End If
For i = (Interval + 1) To Ending Step Interval
For j = 1 To N
DataSet.Cells(i, FormulaColumn).EntireRow.Insert
Next j
i = i + N
Next I
For i = 1 To Ending
If DataSet.Cells(i, FormulaColumn) = "" Then
DataSet.Cells(i - 1, FormulaColumn).Copy
DataSet.Cells(i, FormulaColumn).PasteSpecial xlPasteFormulas
End If
Next I
Application.CutCopyMode = False
End Sub

Look at the code image carefully. We have changed the row number,N=4. It will insert 4 rows in after the active cell. We have put the FormulaColumn number 3 as our formula is existed in column 3. You can change the FormulaColumn number at your preference and the formula will be copied in your inserted rows for the exact formula column.

Fahim Shahriyar Dipto Nov 23, 2022 at 11:16 AM

Hello Avery,
First of all, we would like to thank you for your appreciation. Again, thanks for taking the time to leave a comment about a problem that you’re facing. In our Excel file, the formula is working smoothly. You can follow the step-wise procedure thoroughly. If the problem in your file remains the same, then send the file to us. It will be easier for us to pinpoint the problem. We, the Exceldemy team, are always ready to solve users’ issues.
Regards,
Fahim Shahriyar Dipto
Excel and VBA Content Developer

Fahim Shahriyar Dipto Nov 23, 2022 at 10:32 AM

Hello, Mrs. Thomas. Thanks for your feedback. You can easily show the day in the text by using the TEXT function. Follow the steps for better visualization.
Firstly, go to cell E5 and insert the method.
=TEXT(D5,"dddd")
It will make the day in full form of the text.

Then press ENTER and drag it down for other cells with the Fill Handle tool.

For displaying the month in text go to the cell F5 and write up the formula.
=TEXT(D5,"mmmm")

Drag down it and get the full result for the dates.

Fahim Shahriyar Dipto Nov 17, 2022 at 12:37 PM

Hello Mr Martin. Thanks for your valuable feedback. We are grateful to you for informing us about the factor. According to your feedback, we cross-checked the issue. Unfortunately, the x and y values are switched unexpectedly somehow. we have updated the article. Thanks again.
Regards,
Fahim Shahriyar Dipto
Excel and VBA Content Developer.

Fahim Shahriyar Dipto Nov 17, 2022 at 10:08 AM

Hello Nicol,
Here’s the solution. You can subtract two dates and can find out the days remaining in your hand. I have attached the step-by-step procedure for better understanding.
Firstly, go to cell E5 and insert the formula.
=C5-D5

Secondly, press ENTER and drag down the Fill Handle tool.

Finally, you will get the result like the image below.

Fahim Shahriyar Dipto Nov 7, 2022 at 5:13 PM

Firstly, you need to set a list of ideas according to your category just like the image below.

Then in cell B5 write up the following formula.
=IF(\$B\$4=J5,I5,"")

Similarly, you have to put the same formula for the other columns but need to set the cell reference for the corresponding cells.
Then drag down the Fill handle Tool for C5, D5, E5 ad F5 cells to get the same formula.

Finally, you will get the result.

Now, if you want to add any category-wise idea then it will automatically be sorted in your dataset list. See the image for a better clarification.

Fahim Shahriyar Dipto Nov 7, 2022 at 2:57 PM

First of all, Thanks Mr. Smith for your valuable feedback. its means a lot to us. For your query, we have attached the steps with the image. Hopefully, you will understand this.
To merge numerous Excel files into one, first, convert the XLSX files to CSV files. Navigate to the File Tab. Select the Save As option and then click the menu icon next to the Save Option. Then, in the list, you will find many file formats; explore them and select CSV UTF-8 (Comma delimited) from the list of other formats. Additionally, rename the file from Sales of January to 1-Sales of January (the serial numbers preceding the file name will arrange the files serially according to which serial we want to merge them). Finally, select the Save option.

Then we’ll have a new file with the new format, 1-Sales of January.csv.

To begin, Copy the path to the folder Multiple Files where we have saved our Excel files in CSV format to be combined.

When you press the WINDOWS key + R, the Run window will appear. To launch the command prompt, type cmd in the Open box and hit OK.

We’ve opened the CMD, or Command Prompt, as you can see.

Enter cd and a space after it. To paste the copied path of our Multiple Files folder, press CTRL+V or right-click on your mouse.

After clicking ENTER, you will be sent to the directory specified in the preceding line.
Now, in the new line, put copy *.csv Consolidate.csv (where Merged Worksheet is our new filename), followed by

After clicking ENTER, the following command lines will be created automatically, where we can see the two file names that we wish to combine.

After you close the CMD window, navigate to the Multiple Files folder, where you will find the new merged file titled Consolidate.csv.

When we view the Consolidate.csv file, we notice the Sales Record of January heading first, followed by the equivalent numbers from the February file.
Hopefully, we think the solution is helpful for you