Adnan Masruf

About author

Adnan Masruf, holding a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, plays a pivotal role as an Excel & VBA Content Developer at ExcelDemy. His deep passion for research and innovation seamlessly aligns with his dedication to Excel. In this capacity, Masruf not only skillfully addresses challenging issues but also exhibits enthusiasm and expertise in gracefully navigating intricate situations, underscoring his steadfast commitment to consistently delivering exceptional content. His interests are Advanced Excel, Data Analysis, Charts & Dashboards, Power Query, and Excel VBA.

Designation

Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.

Education

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

Expertise

C++, Python, Microsoft Suite, AutoCAD, Adobe Illustrator, ANSYS

Experience

  • Technical Content Writing
  • Undergraduate Projects
    • Design of a Stern Trawler for the Coastal Region of Bangladesh
    • A Comparative Linear Buckling Analysis of Different Isotropic Plates with and without Stiffeners for Different Boundary Conditions.

Achievement

  • “The Science Behind Swing and Reverse swing” at annual magazine of ASME Student Regional Board, Asia Pacific Region

Latest Posts From Adnan Masruf

0
Excel VBA to Check If String Contains Letters

In this article, we will discuss VBA codes to check if a string contains letters. Excel users often need to look for letters in a string. Excel does not have ...

0
Excel VBA to Select Last Row

In this article, we will discuss Excel VBA to select the last row. If users want to append a large dataset, they have to add a new row after the last row. In ...

0
[Fixed!] Run Time Error 1004: Select Method of Range Class Failed 

In this article, we are going to learn about Run Time Error 1004: Select Method of Range Class Failed. This is one of the most common errors that users ...

0
Excel VBA DoEvents and Wait Properties

In this article, we are going to discuss Excel VBA DoEvents and Wait property. These two property allows users to interact with the Excel GUI while any ...

0
Excel VBA to Set Column Width (Customizing with 6 Ways)

In this article, we will learn how to use Excel VBA to set the column width. The width of a column in an Excel Sheet is a crucial factor in displaying the ...

0
Excel VBA to Find Multiple Values in Range (4 Examples)

In this article, we will discuss how to use Excel VBA to find multiple values in range. In a large dataset, it becomes difficult to find all the required ...

0
Excel VBA to Hide Multiple Sheets (9 Suitable Ways)

In this article, we will discuss some examples of using Excel VBA to hide multiple Sheets. In a Workbook with multiple Sheets, we often don’t use each Sheet. ...

0
How to Fix Excel Runtime Error 13 Type Mismatch in VBA

In this article, we are going to discuss how to fix Excel Runtime Error 13 Type Mismatch in VBA. This is one of the most common types of errors while using ...

0
Excel SUMIFS with Not Equal to Text Criteria (4 Examples)

In this article, we are going to discuss how to use the Excel SUMIFS function with Not Equal to Text criteria. Excel users often need to sum specific values ...

0
Excel VBA Input Box with Drop Down List (2 Examples)

In this article, we will discuss how to get an Excel VBA input box with drop down list. Users often need to insert input from multiple options. In that case, a ...

0
How to Use Combined MIN and IF Function in Excel (2 Easy Ways)

Today, we are going to discuss the use of the MIN and IF function in Excel. We will use the MIN and IF functions together to find the minimum value from a list ...

0
How to Create Bar Chart with Target Line in Excel (3 Easy Ways)

Today, we are going to show you how to create a Bar Chart with a target line in Excel. A target line is a line depicting the goal of a project. By inserting a ...

0
How to Create Pipeline Chart in Excel (2 Easy Ways)

Today, we are going to show two ways to create a Pipeline chart in Excel. Pipeline charts depict the values of a certain parameter or process in a decreasing ...

0
How to Perform Tab Navigation in Excel (8 Easy Ways)

Here are two simple ways to navigate worksheet tabs in Excel: To move to the adjacent sheet tabs, press Ctrl+PgDn to move to the next sheet, and press ...

0
How to Create Analog Clock in Excel (with Easy Steps)

Today we will show how to create an Analog Clock in Excel. Analog Clocks are clocks that contain hour, minute and second hands and give time in a 12-hour ...

Browsing All Comments By: Adnan Masruf
  1. Dear Nirmal,
    Could you please provide me with your Excel file that you have mentioned or some screen shots from your dataset? That would help me to understand your dataset and answer your query accordingly.
    Thanks for your query.
    Regards,
    Adnan
    Team ExcelDemy

  2. Dear Raman,
    1. First, make sure you are using MS Office 365 as they are only available in that version.
    2. Secondly, make sure you are logged into your MS Excel account.
    3. Thirdly, make sure to have the English, French, German, Italian, Spanish, or Portuguese editing language added to Office Language Preferences.
    If these do not work then,
    -Go to File > Options > Trust Center > Trust center Settings > External Content > Security settings for “Linked data types” > Activate “Enable all Linked Data Types”
    or
    – Go to Options>Customize Ribbon> All Commands
    – Then, choose the Datatype Command
    -Add the command to a “New Group”
    -Finally, restart your Excel Application.

    *Also, make sure to keep your internet connection ON; as this data type is linked datatype.
    *You should also see if this datatype is available in your geopolitical locaton.

  3. Dear K,
    Thanks for your query. If we add replies to the comments (Like the first picture), we can find the replies by simply looking at the initials without changing the macros (Like the second picture)

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo