# 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

In this article, we have described guidelines to create a Treemap chart and how to customize the chart. We will also discuss the pros and cons of using this ...

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

Excel files are digital spreadsheets that organize data in rows and columns, offering a versatile tool for tasks like calculations, data analysis, and ...

## 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 Guideline)

In this Excel tutorial, you will learn how to enable or exit the full screen view in Excel. You can enable full screen by applying a Keyboard Shortcut, using ...

## 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 Formula in Excel (Column, Rows, Copy as Formulas, etc.)

Copy a formula in Excel means to replicate a formula from one cell to another or multiple cells. It allows you to use the same formula for other cells or ...

## Excel VBA to Open Workbook from Path in Cell

We can access a workbook in Excel from a path specified in a cell. This is useful when we want to dynamically refer to a file path that may change over time. ...

## How to Press Enter in Excel Without Changing Cells (2 Easy Ways)

Pressing the Enter key indicates the inserted data is accepted. The selection then moves into the cell below usually. This process ensures a quick workflow for ...

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

You can loop through a named range in Excel VBA very easily. Looping through a named range is just like looping through a regular range.Â  The advantage is you ...

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