Maruf Hasan

Maruf Hasan, a BSc Electrical & Electronic Engineering graduate from Ahsanullah University of Science & Technology, boasts over a year of service as an Excel & VBA Content Developer at Exceldemy. He authored 30+ insightful articles and offers solutions to diverse Excel challenges. Maruf's exceptional content reflects his passion for Microsoft Office, problem-solving, and writing. Committed to simplifying complex processes, he significantly contributes to Exceldemy and is deeply enthusiastic about continuous learning in Microsoft Office Suite and data analysis.

Designation

Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

Education

BSc in Electrical & Electronic Engineering from Ahsanullah University of Science & Technology

Expertise

Content Writing, Microsoft Office, Data Analysis.

Experience

• Technical Content Writing
• Team Work

Summary

• Currently working as an Excel & VBA Content Developer.
• Started technical content writing of Excel & VBA in November 2022.

Treemap in Excel: All Things to Know

Introduction to Treemap Chart A Treemap chart represents hierarchical data as nested rectangles, with size and color indicating attributes providing a compact ...

All About Excel Files (Types, Extensions, Open, Merge, Etc. )

What Are the Available File Types That Are Supported in Excel? Excel supports 3 file formats. Their names, extensions, and details are in separate lists ...

Distance Formula in Excel (4 Examples to Calculate)

In this article, we will learn how to find distance using formulas in Excel. We will apply the basic arithmetic formula, the Euclidean formula, the Haversine ...

How to Enable and Exit Full Screen in Excel (Complete Guide)

Why Use Full Screen in Excel? Enabling full-screen mode expands the viewable area, allowing you to see more columns and rows simultaneously. When you use Full ...

Logical Functions in Excel

Logical Functions in Excel IF AND OR NOT IFERROR IFNA XOR << Go Back to Excel Function Categories | Excel Functions | ...

How to Copy a Formula in Excel (Column, Rows, Copy as Formulas)

The following image shows a dataset containing products from different sellers. Each product has a discount. The formula to calculate the discounted price is ...

Guide To Excel VBA to Open Workbook from Path in Cell

How to Launch VBA Macro Editor in Excel Steps: Open the Developer tab. Select the Visual Basic command. The Visual Basic window will open. ...

3 Easy Ways to Press Enter Without Changing Cells

We can change in Excel’s settings for the Enter key to keep the selection from moving. There is also another shortcut- Ctrl+Enter to keep the selection in ...

Excel VBA to Loop Through Named Range (6 Suitable Examples)

Looping through a named range is just like looping through a regular range.  The advantage is you can run a loop without having to explicitly reference each ...

Browsing All Comments By: Maruf Hasan
1. Hello Nathalie,

I tried to sort it according to your comment. But, later, I discovered that Excel’s built-in sunburst chart does not natively support nested sorting. The sunburst chart in Excel is designed to represent hierarchical data with a radial layout, but it does not provide options for specifying the order of data within each level.
The “Treemap” chart better represents hierarchical data with nested sorting.

Regards,
Maruf Hasan
Exceldemy Team.

2. Hello Jasmina,
I checked the code in Method 2. It is working fine. I presume you forgot to add a ‘backslash(\)’ after the path. The editor can not detect the path without backslash. Copy the following line and paste in your code. Hope it will work!

`mPath = "E:\Jasmina\Excell-tips\TestVAB\Kupci-upl-test\"`

Regards
Maruf Hasan
ExcelDemy

3. Hello Hannah!

Thanks for reaching out! You are correct. The direction (East or West) of the bearing is crucial, and it needs to be accounted for in the calculation of radians.

In navigation and mapping, the convention is usually to measure bearings clockwise from north, meaning that eastward directions are considered positive, and westward directions are considered negative. Bearings can be given in degrees, minutes, and seconds or in radians. To account for this, you should modify the formula for converting bearings to radians as follows:

For East Bearings: Simply convert degrees, minutes, and seconds to radians as previously described, and the result will be positive.
=RADIANS(Degrees + (Minutes / 60) + (Seconds / 3600))

For West Bearings: Convert degrees, minutes, and seconds to radians as previously described, but make the result negative.
=-RADIANS(Degrees + (Minutes / 60) + (Seconds / 3600))

By introducing the negative sign for West bearings, you account for the direction correctly. Positive radians represent East bearings, and negative radians represent West bearings.

Bearings measured clockwise from true north: East is positive. West is negative.
Bearings measured in radians: Counterclockwise is positive. Clockwise is negative.

If you have any further queries, please inform us in the reply section. Thanks.

Best Regards,
ExcelDemy Team

4. Hello Vera,
Thanks for reaching out! Here, in your formula I can see few issues. First, your formula has double quotes around the table references in conditions. These quotes are not necessary; you should directly compare the values. Please check that the cell references in your conditions (C3, C4, C5, C6) contain the correct values that you’re searching for in the specified ranges in the TABLES sheet. Also make sure that the data types match. If one of the values is a text string, the comparison should be done with text.
Here, I am adding the modified formula, try this. If it doesn’t work, please share the Excel file with us!

=INDEX(TABLES!E98:T189, MATCH(1, (TABLES!\$D\$97:\$S\$97=\$C\$3) * (TABLES!\$C\$98:\$C\$189=\$C\$4) * (TABLES!\$B\$98:\$B\$189=\$C\$5) * (TABLES!\$A\$99:\$A\$189=\$C\$6), 0))

5. Hello Adam! I checked the excel file and followed the steps mentioned in the article. It seems to work fine. Here, I am attaching a video for you, please follow this video and try again. If you face difficulties again, please send your excel file to [email protected].