Latest Posts From Adnan Masruf
Step 1 - Calculating Total Quantities Sold Select the C11 cell and use the following formula: =SUM(C5:C10) Hit Enter. We ...
Adnan Masruf
Method 1 - Calculating Basic Salary Select the B15 cell and write down the following formula, =VLOOKUP(B7,Structure!$B$5:$D$8,3,0)/D7*E7 Hit ...
Method 1 - Using the NORM.DIST Function Steps: Select cell F4 and enter the following formula: =AVERAGE(C5:C11) Press ...
We have the data of an owner with 5 shops rented by different renters. We will calculate the rents for October 2022 from the shops. Below is the ...
Method 1 - Creating a Graph Without Gaps Between Bars In this scenario, we want to display the Y-axis values to the left of the graph. To achieve this, follow ...
What Is a Three-Column Cash Book? A three-column cash book is a table with Debit and Credit on each side and each side has three columns. The first column ...
The balance sheet is a crucial accounting tool. This allows businesses to keep track of their assets and liabilities. But often a balance sheet is presented ...
Military time is a 24-hour time. This timing system is quite different from the standard timing system. There is no AM or PM in military time. The day begins ...
Cosine is a trigonometric operator. It is related to the angles created by a right-angle triangle. Excel offers a dedicated function named the COS function to ...
While working with data in Excel, we often need to do conditional averaging. Conditional averaging allows us to find the average of datasets that satisfy ...
What Is the Weighted Average? The weighted average is a neat way to calculate the average of the items that have different quantities as well as ...
Method 1 - Using a Combination of CELL, INDEX, and MATCH Functions Steps Select cell E5. Enter the following formula: ...
Method 1 - Applying Cell Formatting Steps: Choose the cell range containing text data. Here, C5:C10. Go to the Home tab and, select Number. Choose ...
In MS Excel, users often need to enter a lot of data. Entering each data manually is a laborious task. The autocomplete feature of Excel lessens their labor. ...
India introduced the GST system to replace some of its messy indirect tax systems. This article will discuss the components of the GST system and provide a ...
- « Previous Page
- 1
- …
- 3
- 4
- 5
- 6
- 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)