marks

<tbody> Given below is the list of 6 marks with various grades. Now how can I sum top 5 marks excluding that marked "F" in excel? 51 B 45 C 63 B+ 46 C 52 B 59 F </tbody>

Hello all, I am looking for some advice on how to set up a formula to allow me enter student marks for answering parts of a question The question 3 parts (each part of the question has 5 marks each) and a student may answer any two parts. their marks are capped 10 marks so the maximum that can...

I have data in notepad .csb format that looks like the sample I've pasted at the bottom of this post. However when I paste it into excel it looks like this picture ie the first set of quote marks is missing. I think because the first "column" is a date excel is cutting out the quote marks...

I am on Excel on Mackbook 2011. I know there is an option on microsoft excel on the graphs to position the axis on the ticks marks instead of in between. On Mac I can't seem to find this option and my X axis is in between when I need it to be on the tick marks. Can anyone help me out? Is this...

we have six subject marks internal and external need formula to sum best of five subject external marks and sum of internal marks which correlate with best of five external marks External Marks ENGLISH HINDI MATHEMATICS SCIENCE SOCIAL SCIENCE COMPUTER SCIENCE (Internal marks )ENGLISH HINDI...

<small style="box-sizing: border-box; -webkit-font-smoothing: antialiased; font-size: 11.04px; text-transform: uppercase; display: block; color: rgb(105, 109, 111); font-family: "Helvetica Neue", roboto, Arial, sans-serif; background-color: rgb(238, 242, 244); outline: none !important...

My current formula is not consistent enough. There is variation so my 118 digits varies. The consistency is that it is always the last "" marks, is there a formula that only displays the text within the last "" marks. Below is the common text string and the data need would be the last ""...

Hello Excel gosu's, I have a pickle with an excel formula, and I can't seem to find an answer anywhere. My data looks vaguely like the data below <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> student class marks A A 10 B A 10 A B...

Hi all, I have 3 column in a spreadsheet as Xth marks, XII marks and graduation marks, With each column, there is one more column about the score, whether the score is in cgpa or in percentage. I need to filter the candidates those having 60 or more percentage throughout or cgpa 6.0 or more...

Hi I've downloaded data from a database There's a whole bunch of question marks in the data examples "XX????", "XAT??????", "??XXADA?"... In other words there's no consistency in the number of question marks, or where the question marks appear. They can't be removed by using the replace or...

I'm using the indirect function with this formula, =INDIRECT($A$3&"$NKW4") $A$3 is a reference to a sheet name and "$NKW4" is a reference to a cell on that sheet. Is there a way that I can put "$NKW4" into the formula without the quotation marks "". I'm looking for this because when I drag...

Hi Everyone, I am having trouble with inserting my formula that has quote marks. My formula below worked well when I manually inserted it in a cell on a worksheet but not in vba. The code I worked with is this: With ActiveCell .Offset(0, 4) = Range("E5:E" &...

Hi Guys, In excel I save the file type as "Test". Putting quotation marks around Test allows me to save the file type as a basic file. Through VBA i'm unable to get this to work correctly Example save path C:\Temp\Testing"Test" This gives me an error and i believe in may have something to...

Hi all, I currently have: =VLOOKUP($A3,'9X'!$A$5:$Q$35,11,FALSE) Where the sheet name is [9x]. I would like to change this to the contents of a cell - logically (or not as it seems) I thought I would try: =VLOOKUP($A3,'(D3)'!$A$5:$Q$35,11,FALSE) where it should pull the contents of D3 to fill...

Part A: Data Collection (4 marks) You need to attach a sample of GOOGLE FORMS used in your survey which consist the following information. (2 marks) Gender: Race: Age: Number of siblings: Height (centimeters): Weight (kilograms): Father’s Age: Height (centimeters): Weight (kilograms)...

Hello, I'm using excel 2016. Trying to save tables as .csv so I can load them into a GIS program, but in one column (containing multiple digit unique identifiers) question marks are showing up in seemingly random cells, usually at the start of the cell. For example, 4242656 in my excel table...

I want to make an Excel graph of quarterly data where the X axis has four tick marks for each year, and the major tick mark is labelled with the year, but no labels on the other quarterly tick marks.

Hello, I have data in the below format in excel with Name and Marks as Row Names : Name Hetal Marks 60 Name Jimy Marks 40 Name Lilly Marks 70 I want above data as below : Name Marks Hetal 60 Jimy 40 Lilly 70 Appreciate your help! Thanks, Hetal

Hi ! My Worksheet image is in Below Link. Capture2.JPG - Google Drive Information About Worksheet and Competitions situation: I am a school teacher. The worksheet is about to practical "Yogaasana" test of students'. In this practical exam there are four member of Judges Panel. The First...

What would I have to do if B9=B14 are both equal but not with blank cells in each cell. If they both show nothing it returns "Paid" because the two blank cells match but I need it to have two matching numbers and then return "Paid"...