marks

  1. A

    Days between two dates the hard way

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

    Filtering with multiple criteria

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

    Question about x axis on graphs

    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?
  4. B

    sumifs / speech mark question.

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

    Want to find sum of Top 70% students' marks

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

    IF conditions for Graph

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

    Quotation Marks in Formula

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

    Averaging Letters for Marksbook

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

    Dynamic List Based on 'X' Marks in Table

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

    Excel 2007 Won't Allow Major and Minor Chart Gridlines

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

    Macro to Insert Multiple Columns and Multiple Formulas

    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" &...
  12. A

    Use of VLOOKUP for multivalue cells

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

    Excel formula to look for '??' or 2 seperate '?' characters

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

    How to Nest =MID(A1,2,LEN(A1)-2) To Eliminate Quotation Marks

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

    Tally marks in excel

    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?
  16. E

    Quotation Marks Causing Error

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

    Function to get maximum marks

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

    formula to compile the summary

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

    Creating another view of the same data without copy-paste

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

    Splitting text in cells.

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

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