Latest Posts From Maruf Hasan
0
Excel VBA is a powerful programming language that allows you to automate tasks in Excel. We can format cells and ranges, and add borders to cells or ranges. ...
Maruf Hasan
Browsing All Comments By: Maruf Hasan
About ExcelDemy.com
See Our Reviews at
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!