highest

I'm hoping someone can help with something I'm trying to do at work. Here's the basic situation: Column A consists of names and each name shows up 1-20 times. Column B consists of numbers. I am trying to highlight or somehow identify the highest number corresponding to each name. Is there a...

I have 3 columns, column A, B, and C. Column A has names while column B and C have numbers. There are 10 rows in total. I wish to find the highest sum of a row to see which employee did the best for what i am doing. Once the highest sum is found i wish for the employees name, that is linked with...

So I have a large list of data that contains multiple categories. I am wanting it to automatically pull from highest to lowest based off criteria in another cell. If I wanted to see the highest for KY for Division 10 then the second highest. I would also want to pull more than just the...

Hello, Step1 - I am looking some Formula or VBA which can look B9 value (it can be alphabets "A To Z" or could be Number "1 to 9") in this example B9 value is "2", I want look this value "2" into C7 (most right alphabet or number 2 not found) look into D7 (most right alphabet or number 2 not...

Hi, Column B starts with 1 & increases by 1 everytime it encounters the same # in Column A. For illustration purposes, Column C has been manually populated & has returned the highest (last number). This is what I am looking for. What formula or macro can be made & used to perform this ? I...

Hello, A............B..................C..................D..................E..................F 1-------------------------------------------------------------------------- 2-------------------------------------------------------------------------- 3---------22 / 183---215 /...

Hello, I have 4 columns named: "Blended" F30; "Construct" G30; "Intercept" H30; "Acquired" I30. Just below those columns (F31:I31), production totals for each column is calculated. I would like cell S21 to display the column name with the highest value below it.

i have a column that includes a subtotal, when i click on the filter of the row with the subtotal and select filter then up top sort highest to lowest (it is a range of %s in that column) it doesn't sort in that order of highest to lowest. it is just kind of random any ideas

Hi all, i am currently trying to create a counter which can help me select an action (A,B,C) depending on the highest value in that state. Example: First, the random counter would random between "HIGHEST" or "RANDOM". The probability of the random counter would be 90% "highest" and 10%...

Good afternoon Is there a way to average a range excluding zero values if any and the highest and lowest value

Input Range:C2:M2 By default C2:M2 is either 0 or “” (null) Else positive integer Formula required in A2: HIGHEST value from C2:M2 If ALL values in C2:M2=0, negative (less than 0) or null, A2 should be “” (null) How to accomplish? Thanks very much for your time given & help in advance...

I am familiar with the LARGE function of finding the largest, 2nd to largest etc. value of a range. I have the situation where I have a range of marks, and then below it another range of what the mark is out of. E.g I have the following in A1 to E1: 1,2,3,4,5 Then in A2 to E2 I have 3,4,4,4,10...

Hi , I was working on a sheet where i have some values in column A , in the last cell of column A is the SUM of the values. I am looking for a code that will copy the sum of values next to the highest value in column A , for an example : <colgroup><col width="64" span="2"...

Hi guys, Broke my head on this one so I have criteria in A2 As in picture I want A2 to be ranked by AI first starting ranking 1 as highest but if there are duplicate rankings like column AI6 I want it to be ranked first by AI and then by AB combined and display highest ranking so for example...

Hi all, Looking for some help on a formula to find the highest values in a range then returning a 1 against the name.

Dear Friends, I have a workbook where cells are carrying values like the following: 2~~5~~18~~-15 -11~~-60~~-3 55~~80 More surprisingly sometimes there is a space after~~ sometimes there isn't like this 20~~50~~60 30~~ 60~~ 70 I badly need a formula which will give me the highest value of...

Hi, i have the 2 formulas which work G2 {=MAX(IF($A$2:$A$20000=A2,$G$2:$G$20000,0))} gets max value of column A data H2 =IF(G2=O2,1,0) checks to see if value in G2 is highest, if so output 1 Im sure i can merge these somehow thanks in advance

Hi I'm having some problems and was hoping I might get some help here having come up with nothing from searching the forum I want to return the text string in a the Cell to the left of the highest value cell in a non-adjacent range from another worksheet to the one where I'm entering the...

Hi all gurus: Quick question here, I have a data table like the one below. For this, id like to be able to pull the result in column "C" this is, the second highest time for each specific code only. The challenge I've had so far is that Large does not account for duplicate values, so for Code...

In Access,I can sort by region by highest producer and save that record for further processing. I have to convert the Access DB functionality to excel. I know I can sort in excel, but how do I save/copy just those highest producers in a separate tab. Does excel or sql have a “first” function...