marks

I have dates in A6:A41. In column B6:B41 I have some check marks. I am trying to find the days between the last two check marks in column B. There will be blank cells between the check marks. I have googled and googled and can't come up with an answer any where. You have been a big help in...

Hi All, I have to extract some data's from large number of Dump data with multiple filtering.Which should to shown in summary sheet while updating the dump data for next frequency.Here below a sample data. Summary sheet : -------------------- July Aug Total Marks by 1...

I have a graph that I want to go from 0 to 80000 in 10000 unit increments on my x axis. I want my data to fall not on the major tick marks (ie: a 25000, 45000, etc). How do I set this up?

Hi all, Question for you, why is it that I have to put a 0 betweenthe speech marks to get this formula to return a value? If I take the “0” out of the speech marks I get nothingback? What am I doing wrong. =SUMIFS(V5:V2247,T5:T2247,"",X5:X2247,"0",Y5:Y2247,"EME") Steve

Hi All, I have an unusual yet important question. My question is: I obtained the marks of about 150 students, in 4 different subjects. I have them in the list with 3 columns; first column is "Subject", 2nd is Student ID and 3rd is respective marks in the particular subject. Issue here is I...

Hi there! I have three columns of data ( 'Name', 'Year' and 'Marks') I want to build Year vs Marks graph, however I need it to only plot for specific names like John for example. Is it possible? =Sheet1!$C$1:$C$6844,Sheet1!$E$1:$E$6844 This is the current formula I'm using, but it does not...

Hi, This formula works when it is in the worksheet but when I try to transfer it to VBA I am missing something with the quotation marks etc. Any assistance appreciated. I'm sure it is a quick fix for the right person. Thanks Ryan "=IF(RC22="""","""",IF(HLOOKUP(RC22,INDIRECT("'CATEGORY...

Hi there, I realise it has been asked before but I could not wrap my head around how to average out letters for a marks book. My spreadsheet is for athletics and each grade cell is reliant on an IF function eg. =IF(C2<15,"A",IF(C2<17,"B",IF(C2<21,"C",IF(C2>21,"D")))). I am hoping that I can...

Hi, Can someone help me with a formula to get this subset of letters: 1 2 3 4 5 6 7 A x x x x x B...

It seems like whenever I add major gridlines to a chart in Excel 2007, the minor gridlines turn into tick marks. And whenever I add minor gridlines, the major gridlines turn into tick marks. I've even tried clicking "Major and Minor Gridlines" in the chart layout menu. But all this does is give...

I am using this macro to insert one column and then to paste a formula in each row of the column. It works except that I want to do it for two columns and two different formulas. Sub Insert_Col_Form () ' ' Dim Rng As Range Columns("F:F").Insert Set Rng = Range("F2:F" &...

Hi, Following is the list of students & marks they've got in exam. This is sample. We are having groups like A&B, C&D, E&F. We can allow only one from each group who is having more marks for next test. Kindly suggest, how the formula should be using vlookup? Thanks in advance <colgroup><col...

Hi guys, anyone who knows a formula to give a true/false output if cells countain double question marks or two seperate questions marks? This should be the result: <tbody> H?eLlo? True Good?night False Goodmorning?? True ?Goodevening False B??ye True </tbody>

I am trying to remove the double quotation marks from the front and back of the result of this API call: =IF(A1="","",IFERROR(WEBSERVICE("https://api.iextrading.com/1.0/stock/"&A1&"/quote/companyName"),"")) Where the contents of A1 are any stock symbol, like AMZN The API call works perfectly...

Hi, Can we count number of tally marks in excel a row or column and display the sum of all? <colgroup><col><col span="4"></colgroup><tbody> total Strongly agree <strike>||||</strike> <strike>||||</strike> ||| =???? </tbody> How to calculate the total?

I'm trying to get excel to put a formula into a cell. This works fine with text and simple formulas. Sheets("Sheet1").Range("D11").Formula = "=SUM(A1:A20)" However I need it to print the following into the cell ad the quotation marks are giving me errors. Sheets("Sheet1").Range("D11").Formula...

Greetings I am preparing a mark sheet for 5 subjects 10 marks each. Total 50 marks On entering the subject marks range from 0-10 total marks I am using SUM function Last column I have max marks attempted. How to get the total for it on entering marks from 0-!0 Sub 1 sub2 sub3...

Hi!, In my Data Sheet, I am having below data. <colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> Rejection Details Jul-2018 22 34 31 22 24 22 36 36 23 Date Model Part Production Qty. M.Cap Miss M.Dent Mark M.Fin M.Flow Mark M.Scratch M.Shrinkage...

In Sheet 1 I have columns: Roll Num Name Marks In Sheet 2, I need the same details to appear, but with the records in descending order of Marks. In future, when more records are added in Sheet 1 or any records are modified or deleted, I want the table in Sheet 2 to be automatically updated...

Hi, I need a script that would break up a block of text in a cell at full stops, question marks, and exclamation marks, and create additional cells (not rows) shifting bottom cells down and inserting split sentences consecutively into created cells. So, for example, A1 Sentence 1. Sentence...