User Posts: Siam Hasan Khan
0

## Excel Dynamic Range Based on Cell Value

In this article, we will be discussing the "Excel Dynamic range Based on Cell Value". Here, we will be creating dynamic ranges without selecting them based on ...

0

## Excel IF Function with 3 Conditions (5 Logical Tests)

When you are performing complicated and powerful data analysis, you need to justify various conditions at a single point in time. In Microsoft Excel, the IF ...

0

## Apply Conditional Formatting Based on Another Text Cell in Excel

In this article, we will be familiarized with an interesting topic which is conditional formatting based on another text cell in Excel. Conditional Formatting ...

0

## How to Find Duplicate Values Using VLOOKUP in Excel

In this article, we will see the process on how to find duplicate values in Excel using VLOOKUP. We will also see the processes on how to use VLOOKUP to check ...

0

## How to Reference Cell in Another Sheet Dynamically in Excel

Tired of manually referencing cells in a different worksheet? Then I have some great news for you because in this article we’ll show you how to dynamically ...

0

## Solving Equations in Excel (5 Useful Examples)

Excel has many features that can perform different tasks. Besides performing different statistical, and financial analyses, we can solve equations in Excel. In ...

0

## How to Compare Two Columns Using VLOOKUP Function in Excel

There are a lot of ways to compare two lists or columns in Excel. In this article, I am going to compare/find matches in two columns in excel using VLOOKUP. In ...

0

0

## How to Calculate Mean and Standard Deviation in Excel

In Excel, Deviation is a measure of how spread out your data is. A large deviation means that your data is more spread out; a small deviation means it's more ...

0

## How to Calculate Variance in Excel (3 Handy Approaches)

In this article, we shall show you how to calculate variance in Excel. Variance is one of the most useful concepts in statistics. It gives the measurement of ...

0

## How to Use Compound Interest Formula in Excel (4 Easy Ways)

Compound interest is the interest that’s calculated both on the initial principal of a deposit or loan and on all previously accumulated interest. Professor ...

0

## How to Convert Text to Numbers in Excel (8 Easy Ways)

Sometimes the numbers on your worksheet behave strangely; they don't carry out arithmetic operations as they ought to. This is because, despite their ...

0

## How to Highlight Every Other Row in Excel (3 Easy Methods)

In this article, we will see how to highlight every other row in Excel. Some available techniques are applying conditional formatting, using different table ...

0

## How to Generate Random Numbers in Excel (4 Unique Methods)

Random numbers are those numbers that are generated by a process in which the outcome is not predictable and in a defined interval/set, the values are ...

0

## How to Delete Blank Rows in Excel (6 Ways)

While working with a big spreadsheet you often insert blank rows intentionally to read and understand it properly. Although inserting blank rows are liked by ...

Browsing All Comments By: Siam Hasan Khan
1. Reply Siam Hasan Khan Jul 30, 2018 at 2:53 PM

Thanks Lakisha

2. Reply Siam Hasan Khan Jul 5, 2018 at 10:40 AM

Yes, it is possible. I insert the grades, grade points and number as most people want to see all of these 3 data. Here the students’ performance is calculated by differencing the Achieved grade and Targeted grade. You can insert the students targeted grade point instead of his targeted grade and calculate the differences between achieved grade point and targeted grade point to calculate the student`s performance.

3. Reply Siam Hasan Khan Jun 28, 2018 at 12:33 PM

Thanks for the feedback.

4. Reply Siam Hasan Khan Jun 28, 2018 at 12:32 PM

Thanks for your feedback. It means a lot to us. Keep following our website for more useful articles.

5. Reply Siam Hasan Khan Jun 20, 2018 at 11:32 AM

6. Reply Siam Hasan Khan Jun 12, 2018 at 4:09 PM

7. Reply Thanks for your comment, Mr. Surya. Stay tuned for more useful articles.

8. Reply Thanks for the comment Mr. JAN. Well, I didn’t test the code. I found accurate results that I was looking for. The other codes that I found out weren`t that much helpful. There were too many errors.

9. Reply Thanks for identifying the typing mistake. I have solved it already. It`s good to know that you find this article useful.

Cheers!!! Advanced Excel Exercises with Solutions PDF  