Mukesh Dipto

About author

Mukesh Dipto is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a superhero tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including Rhino3D, Maxsurf C++, AutoCAD, HTML, CSS, JavaScript, and WordPress. He got his B.Sc in Naval Architecture & Marine Engineering from BUET, and now he's switched gears, working as a content developer. In this role, he creates techy content all about Excel and VBA. You'll find him reading books, travelling, and enjoying movies and TV series outside work.


Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.


B.Sc in Naval Architecture & Marine Engineering, BUET.


Microsoft Word, Excel & VBA, PowerPoint, Microsoft Power BI, AutoCAD, Rhinoceros, HTML, CSS, JavaScript, WordPress


  • Resource Person at Directorate of Primary Education, Bangladesh, Dhaka.


  • Maritime risk assessment of LNG carrier in Bangladesh using Fuzzy Logic Approach.

Latest Posts From Mukesh Dipto

Lock a Cell after Data Entry Using Excel VBA with Message Box Notification Before Locking

This tutorial will demonstrate how to lock a cell after data entry using Excel VBA with a message box notification before locking. So users will not be able to ...

How to Create a Project Timeline in Excel (3 Simple Methods)

This tutorial will demonstrate how to create a project timeline in Excel. Suppose, we are managing a small project. To manage the project we want to create a ...

Excel Macro to Send Email Automatically (3 Suitable Examples)

This tutorial will illustrate how to use Excel macro to send an email automatically. We can configure our mailing feature using VBA macros. So, using the VBA ...

How to Unprotect Excel Sheet If Forgot Password (4 Effective Methods)

This tutorial illustrates how to unprotect an Excel sheet if we forgot the password. To keep our worksheet or workbook confidential, we set a password. The ...

Calculate Conditional Weighted Average with Multiple Conditions in Excel

This tutorial will demonstrate the methods to calculate conditional weighted average with multiple conditions in Excel. While calculating the weighted average ...

Excel VBA to Import CSV File without Opening (3 Suitable Examples)

In this article, we will demonstrate different examples of using Excel VBA code to import a CSV file without opening it. Sometimes, we get our dataset in CSV ...

How to Split Text by Number of Characters in Excel (8 Ways)

This tutorial demonstrates how to split text by a number of characters in excel. When working with a dataset in Excel, the format can vary depending on the ...

How to Split Excel Sheet into Multiple Files (3 Quick Methods)

  Method 1 - Manual Approach to Split Excel Sheet into Multiple Files Method 1.1 Using Copy and Paste Options In the following dataset, we have sales ...

How to Extract Numbers after a Specific Text in Excel (2 Suitable Ways)

In this tutorial, we will demonstrate how to extract numbers after a specific text in Excel. In many instances, we need to extract a specific part of a string ...

How to Remove Space after Number in Excel (6 Easy Ways)

In this tutorial, we will demonstrate how to remove space after a number in Excel. While working on Microsoft Excel we are very likely to have additional ...

Generate Random Number with Mean and Standard Deviation in Excel

In this tutorial, we are going to explain how to generate a random number with mean and standard deviation in Excel. However, you might want to generate a ...

How to Use Multiple IF Condition in Excel (3 Examples)

In this tutorial, we will demonstrate different examples of how to use multiple IF condition in excel. However, we may need to analyze multiple conditions at ...

Insert Column with Name in Excel VBA (5 Examples)

In this tutorial, we demonstrate how to use VBA to insert a column with a name in Excel. While working in Microsoft Excel, we may sometimes need to add a ...

How to Generate Random 10 Digit Number in Excel (6 Methods)

In this tutorial, we will explain different methods to generate a random 10 digit number in Excel. While working on a project in Microsoft Excel sometimes we ...

Excel VBA to Filter in Same Column by Multiple Criteria (6 Examples)

In this tutorial, we will demonstrate the use of Excel VBA to filter in the same column by multiple criteria. In Microsoft Excel using VBA to filter a dataset ...

Browsing All Comments By: Mukesh Dipto
  1. Hello Ruby,
    Thanks for your query. If you do not want to see the formula for a blink then you have to do it by protecting the worksheet. You can try the following code:
    Sub HideFormulasDisplayValues()
    With ActiveSheet
    .Cells.Locked = False
    .Cells.SpecialCells(xlCellTypeFormulas).Locked = True
    .Cells.SpecialCells(xlCellTypeFormulas).FormulaHidden = True
    .Protect AllowDeletingRows:=True
    End With
    End Sub

  2. Thanks for your feedback sir.
    The range is (>=50 and <=80). In Excel COUNTIF function by default omit the upper end value.
    So, the formula is basically showing the result for the values less than 80.

Advanced Excel Exercises with Solutions PDF