subjects

  1. M

    Marksheet formula

    Excel 2007 Reg: Marksheet formula Columns B to J are in numerical format containing marks obtained. Helper Cell K1 contains 50 in numerical format, minimum required marks for a "Pass". Columns B,C & D are category 1 and student should pass at least 2 subjects (out of 3) Columns...
  2. K

    Calculating students marks and results

    Hello, Last time I had somewhat same query and helpful tips from this forum, so I am here again, This time bit complex (at least to me). Here is the file with required format: https://drive.google.com/open?id=1jSG-azrx4r_zobaLUZwFijd9Rm8qcbB9 there are total 28 subjects a student can either...
  3. A

    Specific range date on a code with counting subjects

    Hi I have a code with counting specific subjects emails from outlook and copy to excel. I need to copy the same specific subject emails but with specific date range for example before 7 days I would appreciate any help Thank you
  4. D

    Filter by multiple subjects in single cell

    Hi Guys, Apologies in advance if my post is not formatted correctly as this is my first question - this is a simple question that seems to have a complicated solution. In my spreadsheet I have 1540 book titles for each book title I have multiple subjects, e.g animals, children etc. I want...
  5. S

    Deleting rows in one sheet based on values from another

    Hi, I am an absolute excel newbie and desperately need your help. I have a dataset with 2 sheets. Sheet A contains information on 2000 subjects, but Sheet B provides additional info on 500 of those 2000. In both sheets, column A provides the identification number for each subject. Now, I want...
  6. O

    combining 18 columns into 5 columns

    hi I am devising a school marksheet in excel I have 21 subjects including maths French and english which are mandatory subjects. all tudents do maths English and French . hence 18 columns with different subjects left .only 5columns out of the 18 are filled as there are many options and a...
  7. L

    advanced excel pdf/website

    Hi Do you recommend any online pdf book or website dealing with advanced functions/excel subjects? Thank you very much.
  8. B

    Countif formula

    I am having a student data to calculate the number of subjects failed by a student. ABSENT is also considered as fail and those who have scored below 50 marks is considered as Fail. The excel sheet designed is as follows: Roll No Name Subject 1 Subject 2 Subject 3 Subject 4 Subject 5...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top