Latest Posts From Maruf Hasan
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 ...
Maruf Hasan
Excel files are digital spreadsheets that organize data in rows and columns, offering a versatile tool for tasks like calculations, data analysis, and ...
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 ...
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 IF AND OR NOT IFERROR IFNA XOR << Go Back to Excel Function Categories | Excel Functions | ...
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 ...
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. ...
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 ...
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 ...
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.
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
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.
Please keep in mind,
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
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))
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].
https://www.exceldemy.com/wp-content/uploads/2023/08/Create-Tabs-Using-VBA.mp4
You can also read the article below to know more about VBA inputbox.
https://www.exceldemy.com/vba-inputbox-example/
Have a nice day!