Latest Posts From Adnan Masruf
Method 1 - Using TREND Function Steps: Select the D10 cell and write the following formula, =TREND(D5:D9,C5:C9,C10) Hit Enter. ...
Adnan Masruf
Consider the following dataset, which contains sales and salary information for several salespeople. We'll use it to demonstrate how to create an Excel chart ...
Users often need to merge data from two columns in Excel. Often they merge data without space. That creates obscurity in the presentation of the data. So, in ...
We'll use the following sample dataset to check how to go the last non-empty cell. Method 1 - Using the XMATCH Function The XMATCH function locates ...
This is the sample dataset. Method 1 - Using the Sort Command 1.1 Pasting in Reverse Order Vertically Steps: Select D5 and enter 1. ...
The default column name in Excel, denoted by the alphabet, does not represent the actual data that the column contains. So we need to change the column name ...
Let's use the following sample dataset to illustrate the methods for checking missing values. Method 1 - Using Combination of IF and COUNTIF ...
In analyzing datasets in Excel, we often need to find the square roots of the numerical data. The square root of any number is nothing but the application of ...
This is the sample dataset. Method 1- Using the Relationships Tool to Create a Data Model in Excel Steps: Select a value in the dataset. ...
We often need a distinct name to save our Excel files. This allows us to find our desired file among many other files. What could be more distinct than a ...
In Excel, the term “hierarchy” has two distinct meanings. The first definition refers to a chart that aids in visualizing a hierarchical structure, such as an ...
We often need to randomly select data from our Excel sheet, especially text data. Microsoft Excel does not offer any dedicated function to select random data. ...
Method 1 - Hidden Excel Sheets Not Visible When Opened Steps: Go to the View tab in the ribbon. From the Window group select the Unhide command. A ...
Let's use the following dataset to illustrate the methods of inserting a tab in a cell. Method 1 - Adding Spaces Manually Steps: Double-click ...
The following is the sample dataset. Method 1 - Using the SUM Function Step 1: Select the cell in which you want to see the total ...
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)