Show The Headings Of The Four Highest Marks In Each Row

Nov 7, 2009

I have tried to construct a formula for columns M N O and P to extract the names of the four best marks for each student. I have used the 'Large' formula but it does work when there are equal marks in the list.

Has anyone used a formula to order the first four highest marks and show the headings?

Here is a sample of the Spreadsheet I am using.
(Using Excel 2003)

Column headings are:
(ignore the commas - they are just spacers for the data when posting)

,B,,,,,,C,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,M,,,,,N,,,,,,O,,,,,P

Foot, Athl, Base, R.Cl., Rug, Crick, Tram, Bad, TT, Gym, Golf,,,,, 1st,,,2nd,,,3rd,,,4th

,20,,,,,25,,,,21,,,,,19,,,,22,,,,,20,,,,,24 ,,,25,,,,21,,,24,,,,19,,,,,, Athl Bad Tram Gym

,25,,,,,21,,,,19,,,,,22,,,,20,,,,,24,,,,,25,,,,21,,,,24,,,19,,,,25,,,,,, Foot Tram Golf Crick

,20,,,,,26,,,,25,,,,,21,,,,19,,,,,22,,,,,20,,,,24,,,,25,,,21,,,,24,,,,,, Athl Base TT Bad

View 9 Replies


ADVERTISEMENT

Return Highest Value Of Column Headings With Matching Text In Array?

Mar 7, 2013

I have an array of data with multiple codes stored in text...

I want to set a formula in a cell to look for all instances of specific text in an array. Then compare the value of all of the column headings, which are numbered across the top of the array, which contain a match in that column and return the highest value.

Example: 10x10 array, columns 1,3, and 5 contain "text" somewhere in those columns. Formula would return 5.

View 2 Replies View Related

Tab: Show The Marks When I Group The Columns Or Rows

May 14, 2009

I have this tab that won't show the marks when I group the columns or rows.

I know it is grouped becuase if you copy the data to the blank tab the marks appear fine. Copying the data is an easy work around but I would really like to know the root cause of this. The issue was only with this tab. I used to have a ton of other tabs and they grouped fine.

View 3 Replies View Related

Quick Max :: Possible To Show The Next Highest Rather Than The Highest

Jan 15, 2008

If I use =MAX(A1:G1) I get the highest value. Is it possible to show the next highest rather than the highest and if so how?

View 9 Replies View Related

Display/Show Column Headings In ListBox Or ComboBox

Jun 13, 2008

Im trying to add coloumn heads to my listbox but its just not working
i was using rowsource to use the first row of the sheet as the headings however this just set the values in the listbox to the rowsource. Here is my code

If Area = "" Then
Dim c As Range
Zip = "*" + Zip + "*"
Me.ListBox1.Clear
For Each c In Range([e2], [e65000].End(xlUp))
If UCase(c) Like UCase(Zip) Then
With Me.ListBox1
.AddItem c
.List(.ListCount - 1, 0) = c.Offset(0, -4).Value
.List(.ListCount - 1, 1) = c.Offset(0, -3).Value
.List(.ListCount - 1, 2) = c.Offset(0, -2).Value.....................

View 3 Replies View Related

Show Highest And Lowest Figure In A Range

Oct 13, 2008

how can I get excel to show the highest and lowest figures in a range to display in another 2 cells. Can this be done without having to sort the data and remove all of the other rows except highest and lowest. I am using Excel 2003.

View 5 Replies View Related

Using IF Function To Show Highest Value Achieved Across Range Of Cells

Feb 17, 2014

Basically, I have a worksheet that shows test results for 6 separate tests. If an objective is met in a test then it is marked with an "X". If an objective is partially met then it is marked with a "/" and if it is not met then it is marked with a "." . I have now created a combined column where I want to collate whether an objective has been met at all across the 6 tests.

For e.g. if in the range H14:M14 there is an "X" then N14 should show "X". If there is no "X" but there is a "/" then N14 should show "/" and it there are neither values in the range then it will show "." .

I tried

[Code] ....

but it just came back with a formula error.

View 3 Replies View Related

Filter Show The Most Recent (highest Row) Unique Entry

Jul 30, 2008

Is there a way to make Advance Filter show the most recent (highest row)unique entry instead of the first entry (lowest row)?

For instance if a spread sheet has

1 1
1 2
1 3
2 1
2 2
2 3
3 1
3 2
3 3

I want to keep the "1 3", "2 3", and "3 3" entry, not "1 1", "2 1", and "3 1".

View 9 Replies View Related

VBA Extract Highest And Second Highest Values

Nov 27, 2013

I'm attempting to put together a script which in simple terms finds the 'Highest and Second' highest activity and associated FTE for a given sub group.

To be more specific:

On the "Slide 1" sheet look at the values in column J starting at row 7 until blank;For each value, then search the "All Monthly Direct Activities" sheet in column C for the same value, excluding the 'Subtotal' rows;Where a match is found, compare all the values in column E for that sub group;And Find the highest and second highest figure;

Once these are found copy this figure and associated value in column B and paste onto the "slide 1" sheet.

I'm not particularly well versed in writing VB, but I've been working with the code to see if I can get this work, which I have been unable to do.

I have attached a file which may perhaps provide a greater detail than my description of the problem containing the 'Source' and 'Destination' sheets.

View 9 Replies View Related

Hash Marks

May 30, 2007

I have my columns set at a certain width, the cells set to Wrap Text, the Row set to Autofit YET sometimes when I add text, the hashmarks show up as if the cell isnt formatted correctly and Excel cant show all the text. I can resize the cell, change the text whatever, nothing changes. The only way I can fix this is to cut the text out, open a separate worksheet, paste the text into a cell and copy the whole cell BACK into the original spreadsheet, then I have to reformat the text, whereupon it behaves as it is supposed to.

I read about a similiar problem and the reply was that a macro might be causing the error. This is not the case here. This doesnt happen with any regularity so it is very difficult to figure out.

View 14 Replies View Related

Getting Rid Of Tick Marks

Nov 28, 2008

Some sent me a large spreadsheet with random rows throughout the spreadsheet highlighted in diffierent colors. I have a module that will sort the spread sheet by Color - however it doesn't work on this spreadsheet because - for whatever reason - every cell starts with a tick mark.

I tried to do a replace all - and excel just told me I was crazy.

I even tried going through and manually removing the tick marks - still no luck.

If I export the sheet in to txt and then re-import it I will loose all the highlights...

View 9 Replies View Related

Formula To Consolidate Marks

May 22, 2012

I have three worksheets in which the marks are entered.Now i want to consolidate the marks like

1 in sheet1 2 in sheet2 3 in sheet3 now i want to omit the min(1) marks and add/average of remaining two((2+3)/2)*100.

Is there any formula for this!

View 2 Replies View Related

Function To Convert Marks Into Grade

Nov 15, 2013

I am looking for a function that would convert any mark into a grade. For example in cell B4 I want to enter the total score, cell c4 the score that a student gets and in cell d4 the grade. It is like a grade calculator. I do not want to limit cell b4 the total score cell with a specific total score number. It can be 100, 50, 30 or 10. The moment I enter any total score and the mark that a student actually scored, the grade is given. I attached an excel sheet.

Marks and Grades Calculator.xlsx‎

View 12 Replies View Related

Inserting Quotation Marks Into VBA Code

Jul 7, 2014

I'm trying to get the following formula into a cell using VBA code:

=AverageIf(A2:AXX,"HR",H2:HXX)

But it's being a problem.

This is the current code im trying to use:

[Code] ........

I've tried

[Code] .......

too but that didn't work either.

View 7 Replies View Related

Quotation Marks Causing Error

Aug 17, 2009

The IF formula works if placed in a cell, but Vba doesn't seem to like the Quotation Marks in Rc11="".

View 2 Replies View Related

Copy And Paste Without Quotation Marks?

Jul 2, 2014

I have an entry of: "8E4658" How can I copy that entry, into another cell, only with out the quotation marks?

View 1 Replies View Related

To Insert A Variable Between Quotation Marks

Apr 21, 2009

I have the following line of
Selection.AutoFilter Field:=1, Criteria1:="=2009_15", Operator:=xlAnd

The highlighted portion is going to change from week to week. I have never been able to put a variable inside of quotation marks. I am sure it is simple, which explains why it is out of my mental grasp. how I can assign a variable in there?

View 9 Replies View Related

Numerical Treatment Of Quotation Marks

Mar 15, 2007

To prevent the display of values in a worksheet, I have used an If statement in the format: =IF(I67=""",""",I67). This generally works well; however, I have discovered that if the input value for I67 is actually zero, there is no value displayed in the cell. I need the value to be displayed as a numerical zero so that it can be used in subsequent calculations.

View 7 Replies View Related

Find, Replace Quotation Marks In Vba

Jun 20, 2007

I'm trying to find and replace all the quotation marks (basically just deleting them) on a worksheet through VBA. I've tried a number of things and am stumped. The code I'm using is:

Cells.Replace What:="", Replacement:="", LookAt:=xlPart, MatchCase:=False 'Replaces the quotes.

I've tried

Cells.Replace What:=" & chr(34) & ", Replacement:="", LookAt:=xlPart, MatchCase:=False 'Replaces the quotes.

and

Cells.Replace What:=""", Replacement:="", LookAt:=xlPart, MatchCase:=False 'Replaces the quotes.

View 7 Replies View Related

Adjust Interval Between Tick Marks In Graph

Feb 6, 2014

It is impossible to adjust the interval between tick marks when displaying an horizontal axis with 2 categories (years and weeks). The following steps do not change the space between the tick marks.

-Select the graph;
-Chart Tools - Lay Out;
-Current selection - Horizontal (Category) Axis;
-Format selection;
-Axis options;
-Interval between tick marks: 4.

How can I change the interval for the tick marks to display a mark after every four weeks? Is this a bug or by design?

View 5 Replies View Related

Calculate Percentage Of Specific Boundary Of Marks

Aug 24, 2014

If we have marks for students in some grade in all subjects, in each subject if we make the marks bounded in (50<, 50-59, 60-69,70-79,80-89 & 90-100).

How we can find the percentage for each boundary?

View 5 Replies View Related

How To Remove Quotation Marks From Worksheet Output

Jul 16, 2014

I have an excel program that reads a file and prints it to the work sheet, but I can't figure out why it puts quotation marks around the line of text. I would like to remove the quotation marks from column A and column D.

View 5 Replies View Related

VBA Square Option Buttons With Check Marks?

Feb 4, 2014

I try to make option buttons instead of round with a black dot but square box with check mark liked the check box. Box can be filled with color (light blue or other color). When the box is picked the fill change to white background.

I have 5 option boxs, I like to group them in one group because I have other groups using the option boxs. I want the check mak stayed in that group when it is picked.

View 14 Replies View Related

Handle Quotation Marks Within Text VBA Is Working On

Jul 29, 2009

I have a macro that imports xml and then allows the user to update certain fields. The XML contains many quotation marks and inbound I deal with this by replacing " with ' using Find & Replace.

But before exporting the XML again I need to replace the ' with " but am stuck on how to do this.

For instance I'm trying the following with no success:

Cells.Replace What:="'", Replacement:=""", LookAt:=xlPart" _
, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False

View 3 Replies View Related

Find And Delete Quotation Marks At The End Of A String

Feb 24, 2007

I'm using a query that dumps information into Excel. The query automatically creates a formula in each each cell. For instance if the first value in the query showed FUNSTUFF, after dumping it into Excel, the contents of the cell would show ="FUNSTUFF". I can just use a find and replace to get rid of the leading =", but sometimes the values of the cells are supposed to have a quotation mark, so using the same method to remove the trailing quote won't work. I need a way to search each cell, check if the last character in the string is a quote, and if it is, delete it.

View 5 Replies View Related

Plot/Chart Tick/Check Marks

Apr 21, 2008

Is there any way in which I can map the tick mark labels on either the x-axis or the y-axis to different values other than the ones that are being plotted for.

For example, lets say the data is:

1 5
2 6
3 10
4 15
5 8

I want to plot these in a chart but instead of displaying 1,2,3,4,5 on the x-axis, I want to display a different column, say,

5
7
9
11
13

The answer is not as simple as plotting the required x-values with the y-values. I have just used a simplistic example but the thing I am trying to do has dependencies involved so I cannot simply plot the chart with the required column.

View 5 Replies View Related

Adding Quotation Marks Before And After Text In Range Of Cells Using VBA

Nov 19, 2013

I'm trying to create a shortcut that will allow me to add quotation marks to the begining and end of text in cells. I've tried the following, which works fine when only one cell is highlighted:

VB:
Dim rng As Range
Dim txt As String
Set rng = Selection
txt = """"
rng = txt & rng.Value & txt

However as soon as I highlight more than one cell, it errors. How to make it work for a range of cells?

View 5 Replies View Related

VBA - Remove Double Quotation Marks Around String Variable?

Jul 29, 2012

I would like to query your knowledge database (too much VBA I guess ) as I have a predicament that I cannot seem to solve.

Here is the thing: I am trying to write a sub that would enable me to automatically put in place extensible name ranges (the Offset worksheet function).

The problem is that, despite everything seems to go well, the reference in the name box displays : ="DECALER($C$2;0;0;5-1;1)" (the string comes from a variable and Decaler is Offset in French). These quotation marks are the culprits for sure, as taken off the formula works beautifully.

I've tried everything I've found on the internet, that is to say: Replace(String, Chr$(34), "") so on and so forth, but these marks are not recognized a part of the string so they escape the replacement.

View 9 Replies View Related

Save Excel File As TXT Or CSV With Delimiters Quotation Marks?

Aug 6, 2012

I need to "convert" Excel table to TXT or CSV file, but delimiters have to be ";" and text must be in quotation marks "".

View 1 Replies View Related

Create Helper Column That Marks Distinct Values

Nov 26, 2012

I have a table with 200.000 rows.

I need to create a helper column, that marks distinct values with 1 and not distinct "" or 0.

I tried the following but both use countif and I believe it is the problem it's just to slow.

=IF(COUNTIF($A$2:A2;A2);1;0)
=1/COUNTIF($A$2:A2;A2)

but both are really slow +20 mins to calculate and many times Excel crashes( 2007 32bit).

The workbook is really simple

Col1 (number formatted as text) - Col2 =distinct

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved