Arin Islam

Anowara Islam Arin, a graduate of Civil Engineering from Khulna University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Arin exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Besides, she is also interested in Advanced Excel, Data Analysis, Charts & Dashboards, Power Query, and Excel VBA.

Designation

Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

Education

B.Sc. in Civil Engineering, KUET.

Expertise

Content Writing, Microsoft Office, AutoCAD, Machine Learning, ArcGIS

Experience

• Technical Content Writing

Achievement

• The Effect of Stone Dust and Polypropylene Fiber in the Geotechnical Properties of Fine-Grained Soil: 5th International Conference on Advances of Civil Engineering
• (ICACE-2020)

How to Convert Hours to Minutes in Excel (3 Easy Ways)

To demonstrate our methods, we'll use a dataset containing "Movie Name" and "Duration" in h:mm format, which we'll convert into minutes. Method 1 - ...

How to Convert Minutes to Seconds in Excel (2 Quick Ways)

Here, we have a dataset containing the Player Name and Swim Time in minutes of swimmers. Method 1 - Using an Arithmetic Formula to Convert Minutes ...

How to Create Search Box in Excel with Conditional Formatting (5 Ways)

In this article we will demonstrate 5 ways to create a search box in Excel with Conditional Formatting. We'll use the following dataset containing the Customer ...

How to Calculate the Second Derivative in Excel (2 Examples)

Method 1 - Manually Calculating Second Derivative Steps: Select cell C5. Enter the following formula: =2*COS(B5^2)-4*B5*B5*SIN(B5^2) ...

Descriptive Statistics – Input Range Contains Non-Numeric Data

Descriptive Statistics can work only on numeric values. When non-numeric data is used for Descriptive Statistics, it shows an error that instructs us to input ...

How to Make a Venn Diagram in Excel (3 Easy Ways)

Method 1 - Using SmartArt to Make a Venn Diagram in Excel Step 1 - Adding SmartArt to Make a Venn diagram We have a dataset containing the names of ...

How to Mirror Text in Excel: 5 Easy Ways

Method 1 - Use of Combined Functions to Mirror Text in Excel Steps: Select Cell C5. Insert the following formula. ...

How to Create a New Workbook and Name It Using Excel VBA (6 Methods)

Method 1 - Using the Add Method We'll use the below workbook with several Worksheets. In the first method, we will create a new workbook and name it using the ...

How to Draw to Scale in Excel (2 Easy Ways)

We'll draw a simple floor plan to scale. Method 1 - Using Border Options to Draw to Scale in Excel Step 1 - Setting Up Row Height and Column Width ...

Create Cash Flow Statement Format with Indirect Method in Excel

What Is a Cash Flow Statement? A cash flow statement is a type of financial statement that shows the inflow and outflow of cash and cash equivalents of a ...

How to Calculate Future Value of Uneven Cash Flows in Excel

What Is the Future Value of Uneven Cash Flows? Future Value is the total amount of the Present Value and Total Interest. To calculate the future value ...

How to Add Double Quotes in Excel Concatenate (5 Easy Ways)

Here, we have a dataset containing the First Name, Last Name, and Age of some people. Now, we will show you how to add double quotes in Excel concatenate ...

How to Create a Bar Chart in Excel with Multiple Bars (3 Ways)

Method 1 - Using the Insert Chart Feature to Create a Bar Chart with Multiple Bars Step 1 - Inserting a 3-D Clustered Bar Chart We have a ...

How to Make Excel Look Like an Application – 4 Steps

Step 1 - Creating a Dataset in Different Sheets Open a new Excel File. Add two sheets: Sheet1 and Sheet2. Enter data in Sheet1. ...

How to Print Avery 8160 Labels in Excel – 2 Steps

Step 1 - Creating Avery 8160 Labels from Excel Using Microsoft Word Create a dataset. Here, the dataset contains Name, City, State and Zip. Click ...

Browsing All Comments By: Arin Islam
1. Hi EDD,
Thanks for your comment. Hiding the Formula bar and Ribbon are typically done on a per-workbook basis and aren’t usually carried over to other workbooks you open. However, when you hide Formula Bar and Ribbon from any specific worksheet of your workbook, they’ll be removed from all the other worksheets of that workbook.
You can follow a manual process to align the range in the center of the screen. To center align all the elements on the screen, select the whole range and press Ctrl + X to cut the total range. Here, for the Home page, we will cut cell range B1:H12.

Then, press Ctrl + V to paste it in the center of your screen.

Similarly, you have to cut and paste all the elements to the center and align them on the screen manually.

We hope this will solve your problem. Please let us know if you face any further problems.
Regards,
Arin Islam,
ExcelDemy

2. Dear Anthony Maviglia,
Thank you for your comment. Sometimes keyboard shortcuts may not work in Excel for several reasons. You can check an alternative solution below.

• If you want to select column A and B and then unhide them, first press Ctrl + G >> type A:B in the Reference box >> click on OK. This will select your hidden columns.

• Then, go to the Home tab >> click on Format >> click on Hide & Unhide >> select Unhide Columns option.

I hope this will help you to solve your problem. Please let us know if you have other queries.
Regards,
Arin Islam
ExcelDemy.

3. Dear Eugenia,
Thank you for your comment.
To ensure that the progress bar accurately reflects the progress of your macro, you can use the following modified code.
• Insert this code into your module.

``````Private Sub cmd_Click()
Progress_Bar
End Sub
Sub Progress_Bar()
Dim Counter1, Row_no, Col_no As Integer
Counter1 = 1
Row_no = 1
Col_no = 1
For Counter1 = 1 To 1000
DoEvents
Cells(Row_no, Col_no) = 5
Application.StatusBar = "Loading data... " & Round((Counter1 / 1000) * 100, "0") & "%"
Row_no = Row_no + 1
If (Row_no = 5) Then
Col_no = Col_no + 1
Row_no = 1
End If
Next Counter1
Application.StatusBar = "Done " & Round((Counter1 / 1000) * 100, "0") & "%"
End Sub``````

Here, the Progress_Bar subroutine is called by the cmd_Click event. We used the (Counter1 / 1000) * 100 formula to calculate the progress of the macro execution as a percentage and set it as the value of StatusBas.

• Then, create a button in your worksheet >> right-click on it >> select Assign Macro.

• Assign the Progress_Bar named macro to that button.

Now, if you click on the button, It will show progress in the status bar.
We hope this will solve your problem. Please let us know if you face any further problems.
Regards,
Arin Islam,
ExcelDemy

To use the same code but save it as an Excel file without formulas you need to have some minor changes in the code.
• To create a name for saving the new Excel file use the following code. Here, we changed the “.pdf” part to “.xlsx” as you want to save it as an Excel file instead of a PDF.

``````'create default name for saving file
strFile = strName & "_" & "As of_" & strTime & ".xlsx"
strPathFile = strPath & strFile``````

• Then, to select a folder for the file use the following code. Here, we changed the FileFilter to “Excel Files (*.xlsx), *.xlsx” for the Excel file.

``````'use can enter name and select folder for file
myFile = Application.GetSaveAsFilename _
(InitialFileName:=strPathFile, _
FileFilter:="Excel Files (*.xlsx), *.xlsx", _
Title:="Select Folder and FileName to save")``````

• Finally, save the worksheet as an Excel file using the following code. Here, we used the ActiveSheet.UsedRange.Value property which will copy only the values in the used range.

``````'save worksheet as Excel file if a folder was selected
If myFile <> False Then
wsA.Copy
With ActiveSheet.UsedRange
.Value = .Value
End With
Application.ActiveWorkbook.SaveAs Filename:=myFile, FileFormat:=51, CreateBackup:=False
Application.ActiveWorkbook.Close False
'confirmation message with file info
MsgBox "Excel file has been created: " & vbCrLf & myFile
End If``````

• After employing these changes, your code may look like the following one.

``````Sub Excel_file_without_formula()
Dim wsA As Worksheet
Dim wbA As Workbook
Dim strTime As String
Dim strName As String
Dim strPath As String
Dim strFile As String
Dim strPathFile As String
Dim myFile As Variant

On Error GoTo errHandler

Set wbA = ActiveWorkbook
Set wsA = ActiveSheet
strTime = Format(Now(), "yyyymmdd_hhmm")

'get active workbook folder, if saved
strPath = wbA.Path
If strPath = "" Then
strPath = Application.DefaultFilePath
End If
strPath = strPath & "\"

'replace spaces and periods in sheet name
strName = Replace(wsA.Name, " ", "")
strName = Replace(strName, ".", "_")

'create default name for saving file
strFile = strName & "_" & "As of_" & strTime & ".xlsx"
strPathFile = strPath & strFile

'use can enter name and select folder for file
myFile = Application.GetSaveAsFilename _
(InitialFileName:=strPathFile, _
FileFilter:="Excel Files (*.xlsx), *.xlsx", _
Title:="Select Folder and FileName to save")
'save worksheet as Excel file if a folder was selected
If myFile <> False Then
wsA.Copy
With ActiveSheet.UsedRange
.Value = .Value
End With
Application.ActiveWorkbook.SaveAs Filename:=myFile, FileFormat:=51, CreateBackup:=False
Application.ActiveWorkbook.Close False
'confirmation message with file info
MsgBox "Excel file has been created: " & vbCrLf & myFile
End If

exitHandler:
Exit Sub
errHandler:
MsgBox “Could not create Excel file”
Resume exitHandler
End Sub``````

We hope this will solve your problem. Please let us know if you face any further problems.

Regards,
Arin Islam,
ExcelDemy

Thanks for your appreciation.
When we auto-populate Word documents from Excel it automatically generates data in individual documents for each data.
However, you can go to the View tab and then click on Web Layout from the Views group to see all the values in a single layout.

6. Hi OZZY,
Thanks for your comment.
If the given codes are not working for the .Send function,
• Use the following code in your worksheet by clicking on View Code.

``````Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
If Target.Cells.Count > 1 Then Exit Sub
Set r = Intersect(Range("D5"), Target)
If r Is Nothing Then Exit Sub
If IsNumeric(Target.Value) And Target.Value > 700 Then
Call Send_Mail_Automatically
End If
End Sub``````

• Then, use the following code in your Module.

``````Sub Send_Mail_Automatically()
Dim ob1 As Object
Dim ob2 As Object
Dim str As String
Set ob1 = CreateObject("Outlook.Application")
Set ob2 = ob1.CreateItem(0)
str = "Hello!" & vbNewLine & vbNewLine & "To prevent further costs," & vbNewLine & "please pay before the deadline."
On Error Resume Next
With ob2
.To = Range("C5").Value
.cc = ""
.BCC = ""
.Subject = "Request to Pay Bill"
.Body = str
.Send
End With
End Sub``````

We hope this will solve your problem. Please let us know if you face any further problems.

Regards,
Arin Islam,
ExcelDemy

7. Hi KARL,
Thanks for your comment.
To always return 8 digits with a fill of 0 on the left side of the data you can use VBA code. Follow the steps given below to do that.
Steps:
• Firstly, go to the Developer tab >> click on Visual Basic.

• Then, it will open Microsoft Visual Basic for Applications.
• Now, open Insert >> select Module.

• Next, a Module will open then type the following code in the opened Module.

``````Sub Alphanumeric()
For Each cell In Selection
If Len(cell.Value) < 8 And Len(cell.Value) <> "" Then
cell.Value = WorksheetFunction.Rept("0", 8 - Len(cell.Value)) & cell.Value
End If
Next
End Sub``````

• Finally, Save the code and go back to the worksheet.

• Then, select the cell or cell range to apply the VBA.
• Here, we selected the range B5:B7.
• Next, open the Developer tab >> select Macros.

• After that, select Alphanumeric and click on Run.

• Thus, Excel will always return 8 Alphanumerics with a fill of 0 on the left side of the data string.

We hope this will solve your problem. Please let us know if you face any further problems.

Regards,
Arin Islam,
ExcelDemy

8. Hi MAHESWARI,
Thank you for your comment.
To create a leave record for 2023 in Excel you can follow the steps given in the article with some little changes.
• First of all, insert 1-Jan-2023 and 1-Feb-2023 in Cell E5 and E6.
• Then, drag the icon until it reaches the desired month. Here, we will drag until 1-Dec-23 for illustration.

• Next, you will get the following result.

• After that, follow the same steps shown in the article and you will be able to create a leave record for 2023.

We hope this will solve your problem. Please let us know if you face any further problems.

Regards,
Arin Islam,
ExcelDemy

9. Hello MRRRR,
Thank you for your comment. If you follow the first method, we have shown you will get the week number from a date according to the calendar.
• Here, to find the week number of 4th September 2021 we used the following formula and got 1 as the week number.

`=WEEKNUM(B3,1)-WEEKNUM(DATE(YEAR(B3),MONTH(B3),1),1)+1`

• On the other hand, using the same formula we got 2 as the week number for 5th September 2021.

Hope you have found your solution. If you face any further problems, please share your Excel file with us at [email protected].
Regards
Arin Islam,
Exceldemy.

10. Hello ABC,
Thanks for your comment. No, there is no such limit to merging data. This code should perfectly work for the 5th sheet too. However, there are a limit for row (1,048,576) & column (16,384) numbers in Excel. If after merging the 5th sheet your data crosses this limit, it may not work.
Hope you have found your solution. If you face any further problems, please share your Excel file with us at [email protected].
Regards
Arin Islam,
Exceldemy.

11. Hello RALF,
Thanks for your comment. I suppose you are mentioning the first method. Here, we have shown you how to sort a single column. We have sorted only the column which contains the Age and the other column values (Name, Date of Birth) remained the same. That’s why after sorting the age changed for Amy Bryne.
If you have any other suggestions or face any problems, please share them with us in the comment section.
Regards,
Arin Islam
Exceldemy.

12. Hello Meni Porat,
Thanks for your kind suggestions.
Your formula may show a #VALUE error for an 8-digit number.

However, removing +0 from the formula will return the correct result.

If you have any other suggestions or face any problems, please share them with us in the comment section.
Regards
Arin Islam,
Exceldemy.

13. Hello, MELVIN MORALES!
Thanks for your comment. You can click here to autoscroll and you’ll find the download links for both pdf and xlsx formats.
Regards
Arin Islam,
Exceldemy.

14. Hi RC GOYAL,
Thanks for your feedback.
In the formula, we used {0,0} in the combination formula to return a two column array. However, you can avoid it for this dataset. It will return the same result.
If you face any further problems, please share your Excel file with us at [email protected].
Regards
Arin Islam,
Exceldemy.

15. Hello HBING,
To solve your issue follow the steps given below.
• Firstly, go to the Page Layout tab >> click on Print Titles.

• After that, type 5:5 as Print Area and \$2:\$2 as Rows to repeat at top.
• Then, click on OK.

• Now, write the following code in your module.
Sub Print_Each_Data()
`Dim iRng As Range`
`Dim iWorkRng As Range`
`Dim ixWs As Worksheet`
`On Error Resume Next`
`xTitleId = "Microsoft Excel"`
`Set iWorkRng = Application.Selection`
`Set iWorkRng = Application.InputBox("Range", xTitleId, iWorkRng.Address, Type:=8)`
`Set ixWs = iWorkRng.Parent`
`For Each iRng In iWorkRng`
`ixWs.PageSetup.PrintArea = iRng.EntireRow.Address`
`ixWs.PrintPreview`
`Next`
`End Sub`

• Next, click on Macros from the Developer tab.
• Select the macro named Print_Each_Data.
• Lastly, click on Run.

• Now, a box will open.
• Then, select the range which you want to print. Here, we selected cell range B2:E3.
• Finally, click on OK.

• Thus, you can print each student’s data automatically in the same format.

If you face any further problems, please share your Excel file with us in the comment section.
Regards
Arin Islam,
Exceldemy.

16. Hello AMGHAR,
Thanks for your feedback.
If you face any further problems, please share your Excel file with us in the comment section.
Regards
Arin Islam,
Exceldemy.

17. Hello Lodewijk,
I suppose you want to know more about the Power Query Editor and how it can add sheets to get unique values.
Power Query Editor is very useful in the case of data preparation.
To use this editor, you have to use the Get Data feature from the Data tab. You can get data from different kinds of files such as Excel workbooks, PDFs, Text, etc. Then, you can transform those datasets using the operator available. Here, we removed rows from the tables. You can also combine different tables from those files by the Append or Merge operator. The Append operator is used to create a new query having all the rows from the datasets and the Merge operator is used to have a query with all the columns. You have to use the Append operator to get the unique values. Finally, you can load the query in the existing worksheet or a new worksheet.
If you face any further problems, please share your Excel file with us in the comment section.
Regards
Arin Islam,
Exceldemy.

18. Hello ANANDA,
#NAME error mostly occurs when you misspell the function name. Please check if you have used the correct spelling of the function.
There can be another reason behind this. If you notice you will see that W had fixed the Cell value in the COUNTIF function which is used as the range. Try to use only Cell J2 as the range without making it a fixed range.
If you are using Excel 365 version you only need to press Enter after inserting this array formula. But, for previous versions press Ctrl+Shift+Enter.
I hope that your problem will be solved now.
If you face any further problems, please share your Excel file with us in the comment section.
Regards
Arin Islam

19. Hi Mohammed Shahid,
You can pull text from multiple sheets and ignore blank or space by using the TRIM function. This function will help you to remove space automatically.
To solve your problem, use the following formula in Cell B2 of Sheet 3 in your Excel worksheet.
`=TRIM(Sheet1!B2&" "&Sheet2!B2)`

Hope this will solve your problem. Feel free to comment if you have further inquiries.
Regards,
Arin Islam.

20. Greetings LIBBY,
Thank you for letting us know. We’ve updated it.
Feel free to comment if you have further inquiries. We are here to help.
Regards
Arin Islam (Exceldemy Team)

21. Hi Sue,
Hope you are doing well.
You can approximately match addresses on 2 sheets and find a job associated with that address.
Here, we created a dataset in Sheet1 according to your description.

Again, this is Sheet2 containing the exact Address and Job record.

Now, to approximately match addresses on 2 sheets and find a job associated with that address use the formula given below in Sheet1 Cell C5.
`=VLOOKUP(B5,Sheet2!\$B\$5:\$C\$11,1,TRUE)`

Thanks.

Regards,
Arin Islam

22. Hi Colin Kinsella,
Hope you are doing well.

You can select multiple columns from A to Z having different lengths.
Here, we created a dataset in Cell range A4:Z6. Then, we selected Cell B4:E4 similar to your dataset.

After selecting Cell range B4:E4 or any other cells, press CTRL+A on your keyboard to select all remaining rows with data.

Thanks.

Regards,
Arin Islam

23. Hi J,
Hope you are doing well.
You can get the actual numerical difference between two cells by using subtraction (-) in the formula. In case of, percentage value use the formula given below.
`=IF(AND(0<D5,D5<\$D\$10),(D5/\$D\$10)*100&"% Less Than 10",(-D5/\$D\$10)*100&"% Greater Than 10")`

If the condition is True then the formula will return the result as follows.

On the other hand, if the condition is False then the formula will return the result as follows.

Here, the AND function will return True if both the conditions are true else it will return False.
Thanks.

Regards,
Arin Islam

Advanced Excel Exercises with Solutions PDF