Returning Two Highest Numbers From A Range?

Jul 5, 2012

I have a row of upto 20 numerical entries, (1,1,2,2,10,10,3,3,4,5,6,7,8,12,1,1,7,8,9,11) what formula do I use to go about getting excel to return the two highest numbers?

In this example I'd want excel to return the numbers, 12 and 11

View 1 Replies


Sum Highest Numbers In A Range ...

Nov 22, 2007

I am looking for a formula that will add the 8 highest values in a range of up to 20 cells. The range may have fewer than 8 values in some cases in which case the sum of all those values will be returned.

Thus a row with these values will yield the following output (bold denotes highest 8 values):

8, 28, 45, 13, 17, 19, 21, 30, 47, 8, 15

47+45+30+28+21+19+17+15= 222

View 9 Replies View Related

Take Three Highest Numbers From Range Of Cells And Add Them Together

Jul 15, 2014

How do i take the three highest numbers from E4:E5 & E13:E14 and add them together in E26

View 3 Replies View Related

Adding The Highest 4 Numbers In A Range

Jun 23, 2007

I am trying to add the highest 4 or

View 9 Replies View Related

Sum A Selection Of The Highest Numbers In A Range Of Data

Jan 29, 2007

I need to know how I can create a formula which will sum a selection of the highest numbers in a range of data. So for example, if I have a row of 10 cells each containing dfferent numbers, and I want to take the 7 highest values from there and get the sum of these values, how do I go about this?

I've tried using the LARGE command but can only get an individual figure.

View 9 Replies View Related

Returning The Person With The Highest Value

May 31, 2007

I have some data as below and I want to return the name of the person with the highest value.

Col A Col B Col C Col D
John Peter Paul Luke
3 4 7 8

View 9 Replies View Related

Selecting Highest Value And Returning Data?

Nov 22, 2011

I have the following table of data...


I would like to populate the Letter column with A B C or D depending on which contains the highest value.

View 8 Replies View Related

Using Highest Of 2 Numbers In Formula

Jan 20, 2014

I'm trying to wrap up a spreadsheet and I'm trying to figure out how to have my formula use the highest of 2 numbers when making a calculation.

For example:

Cell A1 = 5000
Cell B1 = 3828

I want the formula to use A1 in this case. However, if the total of B1 = 6000, I want the formula to use B1 instead of A1 in the calculation. (A1 = 5000 will always be a constant/base).

View 4 Replies View Related

Averaging Only The X Highest Numbers In A Row

Jun 7, 2006

Is there a way to average only the X highest number of scores in a row?

What about if there is an additional condition, i.e., if the column
heading says "Quiz", for instance, instead of "Test"?

View 9 Replies View Related

Getting Numbers To Go From Highest To Lowest

Dec 1, 2006

I have A bunch of numbers going up to 4.0 from 0.0 how can i get it so that it takes the number and the name beside it and buts it in a colume from 1 to ..... complete
David 1.5
Jon 3.5
Sally 4.0
Susan 3.24
Fred 2.99

View 9 Replies View Related

Extracting 3 Highest Numbers

Aug 1, 2009

I came up with a way to extract entire row corresponding to the highest number in L column and to post it in the different sheet.

I have 2 issues to solve though.

1. I need to extract only 13 ranges corresponding to the highest number in L column - ( A through M) - not entire row.

2. I need to do the same with the second and the third highest numbers of the same column L.

This is what I have so far:

Sub extract()
Dim first As Range
Set first = Range("L" & WorksheetFunction.Match(WorksheetFunction.Max(Columns("L")), Columns("L"), 0))
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
End Sub

View 9 Replies View Related

Average Of X Highest Numbers

Jul 27, 2007

I want to pick the top five numbers out of a random list of numbers and get its average. What is the best way to go about doing this?

View 2 Replies View Related

Finding The X Highest Or Lowest Numbers In A Set?

Jul 24, 2014

I am looking for a way to find a highest (and/or) lowest value in a list of numbers. The list keeps getting longer and after a certain point I will need the 2 highest (or lowest), then the 3 highest (or lowest). I know MIN and MAX will find the high and low, but how do I find the 2nd highest, etc?

View 3 Replies View Related

Return Highest Numbers From List

Nov 16, 2011

I am looking for a formula to extract numbers from a list in descending order. As the list may have more than one entry of the same number the formula i need should only show one of that particular number.

So in effect

Column A


Hopefull end result

Column C


View 9 Replies View Related

Excel Function For Highest Number For Every 10 Numbers?

Dec 11, 2013

Suppose I have a column filled with numbers in fraction. And correspondingly I have a specific name for every 10 numbers. I want to find out which is the maximum among the 10. For this I could use the "MAX" function in excel. Similarly I have to find the maximum among the next 10 numbers. Since I have about 200 such numbers under 20 different names and eight such sheets (10 numbers per name), it becomes difficult to type the formula and select the range everytime. I would like to know if there is any shortcut for getting this highest number among the 10 numbers.

Name Value Number
TU 489.662.272
TU 380.450.0379
TU 331.970.0475
TU 309.641.004
TU 300.890.1215
TU 288.840.0501
TU 280.090.022
TU 278.580.0115
TU 270.160.0397


View 6 Replies View Related

Get The Highest Value When All Values Consist Of Letters AND Numbers?

Feb 18, 2014

I have thousands of drawings listed in colums and each in the row has revisions P01 to P10 for Proposal and C01 to C10 For Construction. Is there a way of getting the highest revision of all listed in a row without turning them into numbers when P is older than C , but 1 is older than 10? MAX function doesnt count when value consists of both - number and letter.

Manualy selecting the highes revision will cost me weeks... and brain damage.. as I have thousands of drawings and more are coming...

View 14 Replies View Related

Picking 5 Highest/lowest Numbers From A List

Jul 17, 2009

I am trying to generate a list of the 5 highest and 5 lowest numbers from a list of scores that range from 1 to 10. I have found the highest and lowest absolute values (numbers over 7.5, and less than 5, out of 10), but I would also like to generate the 5 highest and lowest relative numbers, ie. if there are no scores over 7.5, then the 5 next highest numbers. I have used if/then formulas for the absolute highest and lowest numbers, and a rank/countif formula to rank them. I have no idea how to generate a list of the "relative strengths and weaknesses".

View 14 Replies View Related

Average Of Highest 48 Of 52 Radom Numbers With Duplicate Low #'s

May 2, 2006

I must determine out of 52 radom numbers the average of the 48 highest even
if one or more of the lowest numbers is repeated 7 times without exempting
the 3 out of the 7 that must be included in the 48 to extract the average.

View 11 Replies View Related

Calculate Highest Common Divisor Of 2 Numbers

Sep 6, 2007

Assume Cell A2 + A3 as the fraction: 60/100. How can I get the smallest fraction (3/5 in cells B2+B3). I do not want to use the build in cell format for fractions)
There are a few samples of want I would like to get a s the result (Red Digits). I will appreciate 2 ways: via VBA Code and via Sheet Build-In Functions.

View 5 Replies View Related

How To Sort Data Based On Numbers From Lowest To Highest

Feb 17, 2014

I can't find a way to sort my data. It looks similar to below. And I need to sort them based on the numbers from lowest to highest.

Tom Simmon (23.2)
Jason Paige (19.1)
Jeff Johns (14.1)

View 8 Replies View Related

Find Four Highest And Lowest Numbers (sorted By Date)

Jul 6, 2013

I have two sheets:

Sheet one has dates, my prices on each of those days, and the fields h1 h2 h3 h4 (h1 is the closest higher number, h2 is the next closet higher number, etc.) and l1 l2 l3 l4 (l1 is the closest lower number, etc. etc.)

Sheet two has certain dates and prices of a competitor's prices.

What I'm trying to do is two things (see attached):
1) find the four closest higher and four closest lower prices (if available)
2) use only the prices that are on or before the date in question.

I've tried combinations like LARGE and OFFSET and so far it is not getting me anywhere.

Can this be done???

View 4 Replies View Related

Removing All But Highest Occurrence Of Version Numbers In Long List?

Feb 7, 2014

I have a list full of different IDs with different version numbers (This format: AKH123.1).

I'm trying to clean the list - removing all duplicate IDs but leaving only the largest version number.

I managed to remove the last digit using LEN/VLOOKUP and removing duplicates, but leaving only the largest version number is too tricky for me. I've thought about trying something with LARGE but can't wrap my mind around it.

My thought process went like this: I want to find all occurrences of "AKH123" and return the largest one.

The list contains about 8000 entries and this would save en enormous amount of work.

Here is a tiny portion of the list:


View 3 Replies View Related

Copy Rows Where Column Of Numbers In Between Highest & Lowest Values

May 30, 2008

I have imported and filtered a .csv. to specified sheet names. I have rows that have been sorted by a specific column's cell contents. i.e.

xxx xxxx xxx xxx xxx 1 xxxx xxx xxx
xxx xxxx xxx xxx xxx 1 xxxx xxx xxx
xxx xxxx xxx xxx xxx 2 xxxx xxx xxx
xxx xxxx xxx xxx xxx 2 xxxx xxx xxx
xxx xxxx xxx xxx xxx 2 xxxx xxx xxx

I need to be able to select all the rows or ranges that contain a common value 1's and then loop back and select the next group 2's of rows until the row or column contains "".

View 4 Replies View Related

Returning Characters After A Series Of Numbers

Dec 10, 2013

I have a list of data in Column A of a spreadsheet that is all at different lengths.

I would like to return the numbers from this (see below) seperately and also everything after the last number so returning "green"



View 1 Replies View Related

Web Query Returning Text But Not Numbers

Oct 3, 2009

I have this web query to retrieve Stock Market data for individual scrips which used to work fine till 2 weeks ago:

Since then all it returns is the text in the tables. Numbers eg dates and stock prices come as blanks.

These show up alright in the browser (Mozilla as well IE).

Some other tables at this site plugged into query return complete data. eg [url]

I tried many different scrips with same results.

Since it was working fine till 2 weeks ago AND other tables at this site are working fine, I suppose the site changed something.

View 10 Replies View Related

Find Highest Value From Range

Mar 31, 2009

I have a large spreadsheet of data that contains 3 columns: Columns are Name, Revision, # of items. I want to find the # of items for the highest revision for each name. List looks like this:

Smith, 1, 30
Smith, 2, 36
Smith, 3, 18
Johnson, 1, 125
Johnson, 2, 130
Lopez, 1, 8
Lopez, 2, 12
Lopez, 3, 15

I'm only interested in the data for the latest Revision. There's over 500 names. A lookup or pivot could be possible?

View 3 Replies View Related

Formula To Look Up The Highest Value From A Range

Apr 20, 2009

i want my formula to look up the highest value from a range (the =max column), then return a name in the leftmost column. What it actually is, is a player of the month for fantasy football. Each week the player gets a score, then each month, a total of four weekly scores. i want to look up who scored the most and return the player name to me. see the attachment.

View 2 Replies View Related

Get Highest Value From Range Of Cells

Aug 8, 2013

Basically I want to get the highest value in a cell from a range of cells on another sheet within the same spreadsheet......
The problem is that the values in the range of cells I want it to look up are not just straight values but rather the summary of two other cells as follows:-

=IF(BN5<"",BO5&" - "&BP5,"") which means that the Values in the cells that the formula needs to search will read something like:- "1250 - B Builder"

Also, cell BN5 is where the archers 3rd highest score gets entered and as such only at this point in time do they 'qualify' for the Standings Table Sheet.....

Then, with luck I can look for the second highest score in the next cell down from looking at the same range and so on and so on.....

View 4 Replies View Related

Indexing Top X Highest Of A Range

Aug 22, 2006

In the attached sheet, I'm trying to get excel to return the top 5 values in an array, based on the preceding cell. This example is for a Football League, in which the QBs, RBs and WRs all have different salaries. The objective is to return the salaries of the top 5 paid people in each. Don't need to return the name, just the salary amount, so that an average can then be taken to figure future salaries.

View 5 Replies View Related

Highlight Highest Value In Range

Nov 8, 2006

Is it possible to highlight the highest value within a given range in that particular cell ? Example: I have a range of value from cells A1 to A10. The highest value is in cell A3. Can I make cell A3 highlighted in colour red?

View 5 Replies View Related

Copyrights 2005-15, All rights reserved