Annyca Tabassum

About author

This is Annyca Tabassum. I have completed my graduation and post graduation from SUST. Now I am working as a technical writer in SOFTEKO. I love myself and my work very much!

Latest Posts From Annyca Tabassum

How to Insert Excel Table from Image

In this article, we will explore the process of extracting an Excel Table from image. The table is an important feature of Excel. Tables are used to analyze ...

How to Make Slicer Horizontal in Excel

Excel slicer is a vital tool that gives users easy access to data filtering and interaction. Slicers are often shown vertically, although a horizontal ...

Excel Slicer Multiple Columns (3 Examples)

Microsoft Excel is a powerful application that contains robust features to improve data analysis and visualization. The Excel slicer is one such feature that ...

Sum If Greater Than and Less Than Cell Value in Excel

In Excel, you may apply multiple conditions to sum values. From them, the greater than and less than condition is mostly used. You can use both conditions at a ...

How to Make Graph Paper in Excel

In this tutorial, we will guide you through the step-by-step process of how to make graph paper in Excel. Microsoft Excel provides the flexibility to create ...

How to Ungroup Sparklines in Excel (3 Suitable Ways)

The sparklines are very important and handy tools of Excel if you need to show a data trend analysis. A dataset sparklines always appear as a group. By ...

Browsing All Comments By: Annyca Tabassum
    Thank you for giving your time to read this article. You want to know the formula to calculate the ranks and denote “Fail” if a student is absent in any of the exams. Read the following section for details.
    Assuming the given data is placed in columns B to G, and the student rank will be shown in column H.
    In cell H5, enter the following formula:
    =IF(COUNTIF(C5:F5,"Absent")>0, "Fail",RANK(G5,$G$5:$G$10,0))

    Drag the formula down to apply it to the rest of the cells in column H.


    The overall formula checks if there are any cells with the value “Absent” in range C5:F5. If there exists, it returns “Fail“. Otherwise, it calculates the rank of the value in G5 within the range G5:G10 in ascending order.
    The student’s total score and rank are displayed in column G, and column H respectively. If a student is “Absent” in any of the exams, their rank will be denoted as “Fail.”
    If you have any more queries, please let us know in the comments.

    Annyca Tabassum
    Team ExcelDemy

Advanced Excel Exercises with Solutions PDF