Annyca Tabassum

About author

Annyca Tabassum holds a BSc degree in Geography and Environment from Shahjalal University of Science and Technology, Bangladesh. She has a deep passion for Excel. As an Excel & VBA Content Developer for ExcelDemy, she not only provides solutions to complex issues but also demonstrates an enthusiastic mindset and adeptness in managing critical situations with finesse, showcasing his commitment to excellence. Apart from creating Excel tutorials, she is interested in Data Analysis with MS Excel, SPSS, Python Web Scraping, and Report Writing.


Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.


B.Sc. in Geography and Environment, Shahjalal University of Science and Technology


Microsoft Office, SPSS, STATA, SAS, Arc GIS, Erdas Imagine 9.1


  • Technical Content Writing
  • Undergraduate Thesis
    • Hydrologic and Land Cover Change Consequences of Teesta River and Its Socio-Economic Impact Due to Teesta Barrage: A study on Hatibandha Upazila.
  • Postgraduate Thesis
    • An analysis on changing trend relationship between land use/ land cover and land surface temperature around Barapukuria coal mine and thermal power plant, Dinajpur.

Latest Posts From Annyca Tabassum

Show Gridlines in Excel 

In this article, you will learn the ins and outs of how to show gridlines in Excel. We will also discuss how to hide and change gridline's color, how to print ...

Nested Formula in Excel (All You Need to Know)

In this article, you will learn about nested formula in Excel and their application with different functions. You will get to know about the use of the most ...

Indentation in Excel (5 Effective Ways)

In this article, you will learn about the indentation in Excel. You get to know how to indent by using ribbon, shortcut and many more methods. We will also ...

How to Insert an Excel Table from an Image

We will add a table from the below image for the methods below. Method 1 – Using an Image Saved in File Explorer Steps: Select a cell of the ...

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 ...

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