Скачать или смотреть How to Make Result Sheet in Ms Excel With Merit Position. রেজাল্ট শীটে মেধাস্থান নির্ণয় করুন।

#Ms Excel #tc_computer #Result_Sheet
Hi, thanks for watching our video about Make Result Sheet in Ms Excel With Merit Position.
Certainly! Creating a result sheet with merit position in Microsoft Excel involves a few steps. Below is a step-by-step guide along with a sample data set.

Step 1: Open Microsoft Excel
Open Microsoft Excel on your computer.

Step 2: Enter Student Data
In the Excel sheet, enter the student data in the following columns:

Column A: Student ID
Column B: Student Name
Column C: Subject 1 (e.g., Math)
Column D: Subject 2 (e.g., English)
Column E: Subject 3 (e.g., Science)
Column F: Total Marks
Column G: Merit Position
Step 3: Enter Sample Data
Enter some sample data in the respective columns. Here's an example:

Step 4: Calculate Total Marks
In the "Total Marks" column (Column F), use the SUM function to calculate the total marks for each student. For example, in cell F2, you can enter the formula =SUM(C2:E2) and then drag the formula down for other rows.

Step 5: Calculate Merit Position
In the "Merit Position" column (Column G), use the RANK.EQ function to calculate the merit position based on total marks. For example, in cell G2, you can enter the formula =RANK.EQ(F2,$F$2:$F$100,0) to rank the total marks in descending order. Adjust the range to match the number of rows in your sheet.

Step 6: Sort the Data
Sort the data based on the "Merit Position" column to display the students in order of merit. You can do this by selecting the entire data set and using the "Sort" feature in Excel.

Step 7: Format as Needed
Format the cells, columns, and rows as needed for a clean and presentable result sheet. You can add borders, colors, and other formatting options.

That's it! You now have a result sheet in Excel with a merit position. Adjust the formulas and formatting based on your specific requirements and data set size.