# 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 Date to the Week Number of the Month in Excel (5 Methods)

Dataset Overview Suppose we have a dataset containing sales records for a shop, including the date of each transaction. Our goal is to convert these dates ...

## How to Title a Column in Excel – 5 Methods

The dataset showcases Sales Person, Product, and Sales. Method 1 - Title a Column using the Cell in Excel There are blank cells in B4:D4. ...

## How to Make Multiple Pie Charts from One Table (3 Easy Ways)

Here, we have a dataset containing the sales data of 5 shops for three consecutive months: January, February, and March. We will use this dataset to show you ...

## How to Filter a Pivot Chart in Excel (5 Ways)

We have a dataset containing a shop's Month, Fruits, Sales, and Profit. We will use this dataset to show you how to filter a pivot chart in Excel. ...

## How to Make Excel Move Automatically to the Next Cell: 4 Suitable Methods

Method 1 - Using VBA to Make Excel Move Automatically to Next Cell Steps: Go to the Developer tab >> click on Visual Basic. The Microsoft ...

## How to Calculate Bond Payments in Excel (2 Easy Methods)

Method 1 - Using the PMT Function to Calculate Bond Payments Per Month in Excel We have a dataset containing the data on Bond Amount, Annual Interest, and ...

## How to Get and Transform Data in Excel – 4 Examples

Example 1- Get and Transform Data from an Excel Workbook Steps: Go to the Data tab >> click Get Data >> click From File >> select From ...

## How to Tally Votes in Excel: 4 Suitable Methods

Method 1 - Using COUNTIF Function to Tally Votes in Excel Steps: Select Cell G5. Insert the following formula =COUNTIF(\$D\$5:\$D\$14,F5) ...

## How to Calculate Age in Excel in Years and Months (5 Ways)

We have the following dataset containing some workers' names and dates of Birth (DOB). We will show some step-by-step methods to calculate their age in Excel ...

## How to Enable Editing in Excel (5 Scenarios)

Why Enable Editing? Enabling editing allows you to modify the workbook, even if it was initially set to prevent further changes. Creators or users may lock ...

## How to Convert Percentage to Ratio in Excel (4 Easy Ways)

We have the following dataset containing the mark sheets of some students. Scores are given in percentages. We will convert these percentage values to Ratios. ...

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.

Regards,
Arin Islam
ExcelDemy.

3. Dear Eugenia,
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

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,
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,
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,
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,
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!
Regards
Arin Islam,
Exceldemy.

14. Hi RC GOYAL,
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,
• 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.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,
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