User Posts: Abrar Niloy
Calculate Absolute Percentage Error with Excel Function

The absolute percentage error function and the mean absolute percentage error function (MAPE) are the most valuable functions for calculating the accuracy of ...

How to Create Daily Bank Balance Report Format in Excel

Financial statements are important for any organization, both for them and individuals. Excel, being the excellent data storing and analysis software it is, we ...

Excel COUNTIFS with Multiple Criteria Including Not Blank

Like the COUNTIF function, the COUNTIFS function counts the number where specified conditions are true. The difference between them is mainly that the former ...

How to Clear Contents of a Sheet with Excel VBA (5 Examples)

One of the advantages of using spreadsheet software like Microsoft Excel instead of a handwritten one is the reusability. Sometimes you need to clear cell ...

Making Same Change to Multiple Worksheets (9 Examples)

Sometimes it is necessary to make changes to multiple worksheets in a workbook at a time. For example, you may need to move or format particular cells in a ...

How to Use Range with Variable Row Number in Excel

In our everyday Excel usage, it is very common to perform different operations on different rows in a dataset or a part of a dataset. Of course, you can ...

How to Calculate Confidence Interval for Population Mean in Excel

Confidence interval or CI is the measurement of the range of estimates for a particular parameter. This is an important concept in data analysis. As one of the ...

[Fixed!] Paste Visible Cells Only Not Working (4 Possible Solutions)

With Microsoft Excel’s filtering feature we can hide irrelevant rows and make particular rows visible. It is a handy feature to sort out and work with ...

Excel VBA: Select Visible Cells After Autofilter (4 Examples)

You can easily apply the auto filter in Excel except using a VBA code. You can also select them too manually which you can also use to perform different tasks ...

Excel If Time Is Between Range Then Return Value

Microsoft Excel offers ways to work with dates and times as data points. While analyzing data, we often need to distinguish data points from the rest based on ...

[Fixed!] Excel Update Links Manually Greyed Out

In our everyday usage of Excel, it is very common to use multiple ones at a time. It is also very common to link them together and update them on a regular ...

How to Fix Broken Hyperlinks in Excel (5 Ways)

The hyperlink is a very useful feature to follow through any data or resource by simply clicking or tapping. Like many other Office software, Microsoft Excel ...

[Fixed!] Selected Cells Not Highlighted in Excel (8 Solutions)

Some report issues about cells not being highlighted after selection in Excel spreadsheets. This can happen for many different reasons ranging from minor ...

How to Reverse Order of Columns Vertically in Excel (3 Ways)

You may sometime need to flip or reverse the order of columns vertically or horizontally while working with datasets in Excel. This can be necessary to take a ...

How to Do What-If Analysis Using Goal Seek in Excel

The goal seek is a handy feature in Microsoft Excel that helps us measure an input based on the desired output. It can be very useful in financing and ...

Browsing All Comments By: Abrar Niloy
  1. Sorry for the inconvenience. It has been fixed.

  2. 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.

  3. 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.

  4. 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.

  5. Glad it had been helpful for you.

  6. 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.

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

  8. 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.

  9. We are glad that this helped.

  10. 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.

  11. 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.

  12. 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.

  13. 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.

  14. 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.

  15. 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.

  16. 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.

  17. 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.

  18. 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.

  19. 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.

  20. 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.

  21. 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.

  22. 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.

  23. 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.

  24. 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.