Abrar-ur-Rahman Niloy

About author

Abrar-ur-Rahman Niloy, holding a B.Sc. in Naval Architecture and Marine Engineering, has contributed to Exceldemy for nearly 1.5 years. As a leader in Excel, VBA, and Content Development teams, he authored 114+ articles and assisted the Exceldemy forum. Presently, as a project writer, he prioritizes stepping out of his comfort zone, aiming for constant technical improvement. Niloy's interests encompass Excel & VBA, Pivot Table, Power Query, Python, Data Analysis, and Machine Learning libraries, showcasing his commitment to diverse technical domains.


Team Leader at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.


B.sc in Naval Architecture and Marine Engineering (NAME), Bangladesh University of Engineering and Technology (BUET).


Content Writing, Python 3, VBA, Microsoft Office, AutoCAD, Rhinoceros 3D


    • Technical Content Writing
    • Team Management
    • User Problem Solving
  • Industrial trainee of shipyard training program in Chittagong Dry Dock Ltd
    • Data analysis and report writing
    • Presentation of weekly reports

Latest Posts From Abrar-ur-Rahman Niloy

Text Box in Excel – A Complete Overview

The sample dataset contains sales of different accessories in different locations. The text box below showcases a summary of the dataset,  displaying the ...

Pivot Table in Excel: Create and Explore

What Is a Pivot Table in Excel? A Pivot Table is a data analysis tool in Excel. Its main purpose is to summarize and analyze a large amount of data and ...

How to Use Fill Handle in Excel (All You Need to Know)

The Fill Handle tool is used to fill or extend data or series in Excel. It is a plus-sign cursor (+). For example, in the following GIF, we have an Excel ...

Excel Limits:  Specifications and Limitations

Excel limits are the predefined constraints and boundaries that Microsoft Excel imposes on workbooks, worksheets, calculations, and data models. Understanding ...

How to Insert and Remove Carriage Return in Excel

A carriage return is also known as a line break in an Excel cell. While they are technically different, the traditional meaning of carriage return from ...

How to Count Number of Columns in Excel: 5 Methods

Method 1 - Using Status Bar to Count Number of Columns in Excel Select the headers of the chart or dataset (or a particular row, which doesn’t have any ...

VLOOKUP Not Picking up Table Array in Another Spreadsheet

Solution 1 - Close One if Separate Instances are Open A worksheet being open in multiple instances is one of the main reasons why the VLOOKUP function does ...

How to Copy and Paste an Excel Table into Outlook Email (3 Methods)

Method 1 – Copying and Pasting an Excel Table Directly from Clipboard Command Steps: Select the table on your Excel spreadsheet. Press Ctrl+C. ...

How to Convert Text Filter to Date Filter in Excel (3 Examples)

The basic method to convert a text filter to a date filter in Excel is simple - just disable the text filter first, then move on to work with the date filter. ...

How to Open Large CSV Files in Excel – 2 Methods

  Method 1 - Using the Excel Power Query Editor Steps: Go to the Data tab. Select Get Data. Hover your mouse cursor over From File and select ...

How to Concatenate Cells with If Condition in Excel (5 Examples)

  Method 1 - Concatenate with Ampersand and IF Condition We can see some blank cells in the “middle name” column. In the fourth column, we want to ...

How to AutoFit All Columns in Excel (3 Methods)

  Method 1 - Double-Clicking Column Headers   To autofit all columns using double-click, follow these steps. Select the triangle icon where ...

How to Clear Cache in Excel (7 Ways)

  Method 1 - Disabling a Recent Document List Steps: Select the File tab on your Excel ribbon. Select Options from the left side of the ...

How to Create an Option Probability Calculator in Excel

Overview of Option Probability Probability represents the likelihood of an event occurring among all possible outcomes. In the context of options, probability ...

How to Calculate Total Time in Excel (6 Suitable Examples)

  We'll use a simple dataset with check in and check out times to calculate the duration. The Excel formula to calculate the time duration is a ...

Browsing All Comments By: Abrar-ur-Rahman Niloy
  1. Reply Abrar-ur-Rahman Niloy
    Abrar-ur-Rahman Niloy Jan 21, 2024 at 12:38 PM

    Hello Richard!

    You need to replace 0s in the format type with 0.00s.
    For example, instead of #,##0_) ;(#,##0) for center alignment, use #,##0.00_) ;(#,##0.00).

    Team Exceldemy

  2. Reply Abrar-ur-Rahman Niloy
    Abrar-ur-Rahman Niloy Jan 16, 2024 at 4:11 PM

    Hello Mahmoud,

    Looks like there were several inconsistencies in your code. This is the modified version of your code:

    Sub InsertStamp()
    Dim fNameAndPath As Variant
    Dim img As Picture
    Dim ws As Worksheet
    Dim Location As Range
    fNameAndPath = Application.GetOpenFilename(Title:="Select Picture To Be Imported")
    If fNameAndPath = False Then Exit Sub
    Set Location = Application.InputBox("Please select the stamp location", "Insert Stamp", "Enter the cell HERE", Type:=8)
    'If Location = "Enter the cell HERE" Or Location = "" Then
    'Exit Sub
    'End If
    For Each ws In ActiveWorkbook.Worksheets
    Set img = ActiveSheet.Pictures.Insert(fNameAndPath)
    With img
    'Resize Picture to fit in the range….
    .Left = Location.Left
    .Top = Location.Top
    .ShapeRange.IncrementLeft -20.25
    .ShapeRange.IncrementTop -9.75
    .Placement = 1
    .Name = "Stamp"
    .PrintObject = True
    End With
    Next ws
    End Sub

    Try out this one. It should work fine.

  3. Reply Abrar-ur-Rahman Niloy
    Abrar-ur-Rahman Niloy Oct 26, 2023 at 9:58 AM

    Hello again, Jessica! In the previous reply, I have mentioned exactly how you can do this. If you go through the second step, you will find the item number of your second Outlook mail (generally is 2. can also be 1 depending on how you had logged in to your accounts).
    If it isn’t, take note of the number. Replace the 2 in .SendUsingAccount = mApp.Session.Accounts(2) with the number Excel shows. You will find this line in the With statement at the end.
    In case if you are having trouble understanding any of the part, let us know about that.

  4. Reply Abrar-ur-Rahman Niloy
    Abrar-ur-Rahman Niloy Oct 25, 2023 at 6:36 PM

    Hello, Khurram Javed!

    As of the latest version of Excel, the SUMIFS function doesn’t support partial matches with numbers directly. If your codes contain alphanumeric characters then the formula works perfectly. Because Excel doesn’t recognize them as “number” format.
    partial match with alphanumerics
    If the range B5:B14 contains numeric values only (i.e. 102054), the function will return a #VALUE! error saying wrong data type.
    However, if you are only concerned with the result and not with the formula, there is a workaround for that.
    using sumproduct for partial number match

  5. Reply Abrar-ur-Rahman Niloy
    Abrar-ur-Rahman Niloy Oct 25, 2023 at 12:27 PM

    Hi, Jessica!

    Yes, it is possible. In short, Outlook assigns every email of yours to a number. You can call a specific mail using the Accounts.Item(x) method, x is the number assigned to the mail. Mention this account in the MailItem.SendUsingAccount property and the code will send the mail from that specific account. Keep in mind, the process works for Excel 2007 and later versions.

    Here is the details of the process:

    1. First, check the Microsoft Outlook 15.0 Object Library in VBA editor from the Tools>References>Available References.
      (This is to enable the Outlook library in your Excel workbook)
    2. If you want to find out the numbers associated with each mail, use a code utilizing the Accounts.Item method like the following.
      Sub EmailAccountsList()
          Dim OutMail As Outlook.Application
          Dim i As Long
          Dim MailRow As Long
          MailRow = Sheet1.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
          Set OutMail = CreateObject("Outlook.Application")
          For i = 1 To OutMail.Session.Accounts.Count
              Sheet1.Cells(MailRow, 1) = OutMail.Session.Accounts.Item(i)
              Sheet1.Cells(MailRow, 2) = i
              MailRow = MailRow + 1
          Next i
      End Sub

      This code will give you the list containing your outlook mails and their numbers on your spreadsheet.

    3. Now, use this number in the SendUsingAccount property. Take the first code in this article, for example. In the With statement of mMail, you can modify it like this:
      Sub ExcelToOutlookSR()
      Dim mApp As Object
      Dim mMail As Object
      Dim SendToMail As String
      Dim MailSubject As String
      Dim mMailBody As String
      For Each r In Selection
          SendToMail = Range("C" & r.Row)
          MailSubject = Range("F" & r.Row)
          mMailBody = Range("G" & r.Row)
      Set mApp = CreateObject("Outlook.Application")
      Set mMail = mApp.CreateItem(0)
      With mMail
          .To = SendToMail
          .Subject = MailSubject
          .Body = mMailBody
          .SendUsingAccount = mApp.Session.Accounts(2)   'Replace the number in the bracket with your mail number from the previous code's list
          End With
      Next r
      End Sub

    Hope this helped. If you still have inquiries, let us know.

  6. Reply Abrar-ur-Rahman Niloy
    Abrar-ur-Rahman Niloy Sep 24, 2023 at 2:47 PM

    Hi, Icide. M. O.

    VLOOKUP or XLOOKUP is specifically for finding a value from a table/range. If you have the CGPA already calculated, you can use these functions to find it like this.
    vlookup finding cgpa
    Similarly, you can use the XLOOKUP function too.
    xlookup finding cgpa
    Assuming you don’t have the CGPAs already calculated, you want to do that from grades within Excel, you need all the grades for a certain person. If you have multiple values matching in a range, the VLOOKUP/XLOOKUP only returns the first match.
    vlookup problem
    However, there are other workarounds for this. For example, the FILTER function can extract all the matching values. You can use them to your calculation’s advantage after that.
    Here, I have used the Σfixi/Σfi formula to calculate the CGPA assuming it has a credit system. I have also used the absolute referencing as you have mentioned replicating the formula for a group of students. Hopefully, this answered your question.
    If you are still struggling with your particular dataset, feel free to let me know. I will try to get back to you.

    Niloy, Team Exceldemy

  7. Reply Abrar-ur-Rahman Niloy
    Abrar-ur-Rahman Niloy May 18, 2023 at 11:40 AM

    Hi Nawaf, thanks for the appreciation!

    We focused more on the checklist side of the task tracker- whether or not the task is done or yet to be done (or not) was our main focus here. Also, we wanted to rearrange and prioritize our tasks based on a criteria. So we skipped the timestamps in this article. If that is your priority, you can easily do so too by adding an extra column and including it within the dataset too.
    You can also add an assigned time and current time and compare them to find the status of the task in the main dataset. If you face any problem regarding the timestamps or want to do something particular with them, let us know. We are always here to assist.

  8. Reply Abrar-ur-Rahman Niloy
    Abrar-ur-Rahman Niloy May 8, 2023 at 4:34 PM

    Thanks again, there seems to be some cache from the recently opened office files in the location. Deleting them would certainly help.

  9. Reply Abrar-ur-Rahman Niloy
    Abrar-ur-Rahman Niloy May 8, 2023 at 4:28 PM

    Thank you for pointing this out. There are some cache files in the location and the article has been updated for later uses.

  10. Hello Aniket!

    As of now, we are only focusing on Microsoft Excel for Windows. But in case of other versions, there are some shortcut keys that do not work for iPad yet. It is constantly getting updated. If only some of the shortcuts aren’t working for you, then that may be the case. One solution would be to stay up to date with their updates.

  11. Hi Elly,

    For your data, plotting a stacked bar chart would not be possible. Excel needs a dataset of the following sort to plot a stacked bar chart.

    1st Week 2nd Week 3rd Week 4th Week
    1st Task 44 41 61 58
    2nd Task 38 52 53 64
    3rd Task 42 48 50 56
    4th Task 37 59 44 46

    Even in that case, creating a Gantt chart would not be appropriate, as one bar will start where the previous one ended. This will ultimately result in the same bar plot. But if you have a gap between each work period, you can put them in between these values and follow the steps of the article.

  12. Hi, Patrick James O’Connell.

    It is pretty “suite” you found it amazing. But unfortunately, there is no way to keep formats while joining strings together up until the latest version till date. Excel doesn’t even keep the formats of dates and times, so we have to go through these TEXT functions to keep that format.

  13. Glad that it was helpful to you, Troy. Stay with us for more of these stuffs in the future.

  14. Hi, sbellmore

    This happens because of the .UsedRange method in the 13th line in the code.
    Set Rng = Worksheets(Work_Sheets(i)).UsedRange
    You can replace .UsedRange with .Range method to put one dataset or a particular portion of the dataset (eg without headers). For example, with our dataset, you can use the following.
    Set Rng = Worksheets(Work_Sheets(i)).Range(“B4:C7”)
    Set Rng = Worksheets(Work_Sheets(i)).Range(“B4”).End(xlDown).End(xlToRight)

    The downside of using such lines of code is, if you have any dataset without headers, it may ignore the part or whole dataset in some cases. As some of your sheets may not contain a dataset starting from cell B7. For automation, unfortunately, using .UsedRange is the most efficient method.

  15. Sorry for the inconvenience. It has been fixed.

  16. Hi Scott. Unfortunately, no, there isn’t. If you pass your password to a client and if he chooses to share it with anyone else they will be able to access the file too. It’s a limitation like any other login service.

  17. Hi Kheiy. Yes, there is an easy way to do that. Go to the Mailings tab on the word file and select Finish & Merge. Then select Print Documents from the drop-down. After that, you can find the option to print all pages or a particular range if you want.

  18. Hi Raj,

    Do you want to put all the row values in a single cell? You can try out the following formula to concatenate them. But it will be converted into a string.

    If you want to know something else entirely, kindly elaborate on your problem. We will try to help the best we can.

  19. Glad it had been helpful for you.

  20. Hi Gerald,

    You can create certain data tables consisting of probability. Provide us with more details, we will be able to help with the detailed procedures.

  21. Click on “Enable Editing” in the message that appears above the formula box.

  22. Hi Brian,

    The article mainly focuses on the mortgage calculator between two parties. For an escrow, if there are no conditions involved, it will look almost the same.

  23. We are glad that this helped.

  24. Hi Romesh.

    IRR is not the sole measure of comparing profitability. It is just one of the many parameters you can use to compare two paths of investment.

  25. Hi Colvis.

    We are very sorry for not reaching out to you promptly. But the annual IRR is calculated by multiplying the monthly IRR by 12. In that case, we get an annual IRR value of 6.504%. The value of IRR from the IRR formula and the XIRR formula should not be the same for irregular cash flows. And these values reflect that.

  26. Hi Temitope,

    Our website currently focuses on providing articles and solutions for Microsoft Excel only. If you have the same problem in Excel, please provide us with a little bit more information. We will try to assist you as much as possible.

  27. Hi SteelWolf,

    I am not sure what you meant exactly by that. But assuming you want to put in a date in cells F6, H6, J6, L6, N6, P6, and R6 that match with cell J1, you can use formulas in those cells with reference to cell J1. For example, let’s assume you want the previous date, exact date, and the following date of cell J1 in cells F6, H6, and J6.
    You can write =J6 in cell H6. Write =EDATE(J6,-1) in cell F6 and =EDATE(J6,1) in J6.

    You can modify/ use different formula according to your needs in this way.
    But if you want you use the “autofill” in those scattering cells, it is not possible yet as of the latest version of Excel.

    Hope that helps. If you meant something else entirely, please let us know.

  28. Hi Cris,

    I am so sorry for your situation. But we haven’t worked with the iPhone platform yet. So our solutions are only limited to windows for now.

  29. Hi Elona,

    I am not sure I understand your problem quite clearly. But if you are having problems importing data from different sheets, then put the sheet name before the range in single quotes followed by an exclamation sign.

    For example, you should add ‘Sheet 2’! before the range G3:G123 or any other range while using them as the source to use formulas in the first sheet.

  30. Hi Debbie,

    Yes, you can use multiple criteria for the MATCH function. Try it like this:
    MATCH(1,(first criteria)*(second criteria)*(third criteria),0)
    in place of the match function used for a single criterion.

  31. hi Willy,

    Make sure the file names are correctly spelled in the line. Check if both the source file and target file name are correct as well as if the directory of the workbook file is correct too.

    If the problem still persists, please provide us with a bit of more information, like what is the error message or perhaps a screenshot.

  32. Hi Eric, the COUNTA function counts all the cells including empty strings. It ignores a cell only if there was no value entered or you have deleted it completely (pressing delete or erasing the entire cell value).

    But if you use the COUNTBLANK function to count the same range, you will find that the empty strings will indeed are being counted as blank values.

  33. Hi Jeff, so sorry for your unfortunate situation. But the formulas are structured in such ways that it returns empty strings if only certain criteria are met. It won’t result in entire rows or columns being empty.

  34. Hi Akhil,

    Unfortunately, there are no direct ways or simple formulas to do that. One way to work around this is to remove the columns as the entirety of them is empty. And then try transposing. Or you can try out VBA to remove the empty columns/rows then try using transpose commands.

  35. Hi Esayas,

    You can count that if you mix the formulas with the COUNTIF function. You have to be a bit creative while using it in VBAs. For example, take the first method. You can use =TEXTJOIN(“, “,TRUE,IF(C14=B5:B12,C5:C12&”:”&COUNTIF(C5:C12,IF(B5:B12=C14,C5:C12)),””)) formula instead of the given one to find the count of each one in the dataset along with the models.

  36. Hi Vikas,

    Seems like your first problem meets the criteria for this article . In the ending date cell, try using the TODAY function, and at the starting date put in the formula =EDATE(TODAY(),-5).

    As for your second criteria, use the formula =EDATE(TODAY(),-5) of this article’s current cell value instead of today’s date and that should do the trick.

    Hope that helped. If you are still facing issues, or you wanted a different result let us know.

  37. Hi Jose,

    You can choose any of the three methods given above to remove the “↑” sign. All of them work for any non-numeric character, including the one you are asking.
    Hope that helped. If you are still facing problems, let us know.

  38. Hello, SAF. I am glad it was helpful to you. As for your problem, you don’t need to reupload every time you enter new patient names in Excel.

    You can select “Edit Recipient List”> select the file name in the “Data Source” section and hit refresh. It will automatically update the recipients’ list up to the latest entry.

Advanced Excel Exercises with Solutions PDF