Latest Posts From Adnan Masruf
Method 1 - Using the Uncertainty Formula We have a set of readings of a certain parameter. We are going to determine the uncertainty of the readings. ...
Adnan Masruf
Today we will talk about ways to add Tooltip to UDF or User Defined Function in Excel. Tooltips are small descriptions of functions when we enter the function ...
Today, we will show how to draw a Mohr Circle in Excel. The Mohr’s Circle is a powerful engineering visualization tool. It is a sophisticated way to visualize ...
In this article, we will show how to reset ComboBox to the default value using the VBA code. ComboBoxes are a great tool to store a list and then select from ...
In this article, we will show how to hard code in Excel. Hard Code means stating a specific value into a formula or cell rather than referencing the cell ...
In this article, we will show how to find External Data Connections in Excel. External Data Connections are the reference to the data in another workbook from ...
In this article, we will show how to use Conditional Formatting on a Text Box in Excel. We often need text boxes to display a certain text or link the text box ...
Method 1 - Using Excel Power Query Editor to Combine 2 Columns Steps: Select cell B5 in the Gender column. Go to the Insert tab. Select Table. A ...
In this article, we will discuss how to use the VLOOKUP function to find state abbreviations. We often need not the full names but the abbreviations of a state ...
![[Solved!] Name Error of PI Function in Excel](https://www.exceldemy.com/wp-content/uploads/2022/12/pi-in-excel-name-error.png?v=1697452681)
In this article, we will discuss the Name Error of the PI Function in Excel. The Name Error is a common error in Excel. There are many reasons for that error, ...
What Is UTF-8 Encoding? The UTF-8 encoding is the most used character encoding for the internet. It is used in emails and web pages. It allows access to both ...
This is an overview. Method 1 - Using the Get Data Feature of Excel Steps: Go to the Data tab. Select Get Data. Select From File. ...
In this article, we will discuss the calculation process of Double Declining Depreciation in Excel. The Double Declining Depreciation is one of the accelerated ...
Example 1 - Using a PivotTable to Create a Data Table with 3 Variables Enter Principle, Months, and Rates in B5:D12. Click E5 and enter the ...
In this article, we will demonstrate how to use conditional formatting in data labels to present data in charts more eloquently. Download the workbook at the ...
- « Previous Page
- 1
- 2
- 3
- 4
- 5
- …
- 7
- Next Page »
See Our Reviews at
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
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.
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)