largest

I have a column with the data formatted like this: <colgroup><col style="width:48pt" width="64"> </colgroup><tbody> L-15 S-6 L-7 L-8 R-9 D-10 S-11 D-15 R-13 L-6 </tbody> I am trying to find a...

<tbody> </tbody> In my example I've got components of 5 combinations in B5:C9 to be multiplied, Extra is added to each of the B5:B9 and C5:C9 array(s) when calculating the Largest product of those arrays. Instead of listing the results of the multiplication I'd like their...

Hello kings of the formula i need a formula to choose the largest value of the cell 1

Good day! I have a Userform that pulls Number from excel and displays them in textboxes. I would like, within the Userform, to populate another textbox in the form of the largest number from the textboxes. For example, 3 userform textboxes display #'s Txt1 = 12 Txt4 = ABC Txt2 = 37 Txt5 = DEF...

Hello, new member but longtime reader. I haven't been able to find a solution for this particular issue, hope there is one. Given a sheet with several thousand lines, each line representing an item reference code (SS0003, SR0528, etc), I've added a simple countif on each line to determine how...

Have numbers in Excel 2016 column that sorts with A to Z instead of smallest. How can I change order from A to Z to smallest to largest? Cells/columns are defined as a numeric type. Thanks in advance!

I am trying to get a formula to count the values in column I but only if the value in column D is equal to B2. I need the result to be the largest amount of instances of the value found. In simple terms, and assuming the criteria is met, I need to identify the value that occurs most frequently...

Hi all, I'm trying to calculate the frequency a value is used in a formula. I have a range of results (ranging numerically from 1-9) each connected to a topic/subject. I have created a cell which identifies the largest number amongst those results in every row (=LARGE(S5:AN5,{1{)). What i'm...

Hello I'm trying to find a way of comparing the value in one cell with the values in multiple cells. The values in column A contains dates. The values in column B contains all the values I want to compare with each other. To make things a bit clearer, Let's take the value in cell B5 - I like...

Hi. I need help. Example Data in column A - C. Desired Results E-F. I am looking to return the 5 largest sums based on a column and return the corresponding value. Thoughts? <tbody> A B C D E F 1 FL 200 MN 700 2 TX 200 CO 500 3 FL 100 FL 400 4 FL 100 TX 400 5 MN 400 CA 200 6...

Hi there, I am looking to write a multiple criteria array formula and I am stuggling. I want to say from the values in column a that equal are an exact match to the word june (or a cell reference), choose the largest value in column D which is not equal to zero, but has to be from June's...

Hi there I've looked around for solution to this but surprisingly couldn't find one. I would like to build a macro that selects the largest valued cell in column A. it should be easy enough but i guess im not describing it right in my google searches. Regards, John.

Hi, I'm creating a LARGE IF array funtion as follows: =LARGE(IF(Master!$B:$B=A1,Master!$F:$F),1) The A1 is a drop down list that is selecting a Category name and then selecting the nth largest number in Col F from 1 - 10. I also want to include an option to look at all rows in Col F so that...

Hello all, Requesting help from you guys. So basically I am doing a tool comparison and my final dashboard looks like below <tbody> Evalution category Tool 1 Tool 2 Tool 3 ABC 8 4 3 DEF 1 3 6 XYZ 5 2 5 </tbody> So what I am thinking is a way to highlight in which categories is Tool 1...

Trying to figure out a formula that will assign the largest number in a row a value. For example, the largest number in the row below is 53, so I would like for the formula to = VSS4. Thanks in advance! <colgroup><col width="37" style="width: 28pt; mso-width-source: userset; mso-width-alt...

I'm trying to use vlookup to lookup a value that sums up the 2 largest numbers in columns B,C and D. I tried these 2 formulas on my own but thet dont work. I also tried using them as array functions. But still doesnt work. How can I make this work? =sum(VLOOKUP(E9,A2:D5,{LARGE(B2:D2,{1,2})},0))...

I am looking to get the 2nd Largest Value with Criteria Avoiding Duplicates, essentially I want to find out every customer in my records their min, max and 2nd to max ship date This was my original take on it, '={LARGE(IF([Column2]=[@Column2],IF([Ship Date]<[@MAX],[Ship Date]),[@MAX]),2)}...

I have the formula array formula that works great. However, I would like to modify it so it sorts from smallest to largest. Right now, it is sorting largest to smallest and not vice versa. I did trying nesting this inside the Small function but I may not have set up the Rows function properly...

Hi, Please can someone help? If it is possible at all, I would like to edit this code so when it searches in the range for the largest number, it doesn't include the cell that has just been edited. Sub ShowMax(Optional ByVal Target As Range) Dim TheMax As Double TheMax =...

I've searched and found some things that are similar, but not exactly what I want (i.e. Index/Match). I want to look up the 1st largest value and return what is in column A. I'm then repeating for the 2nd, 3rd, etc. Here is the formula I have, but the output for the largest and 2nd largest are...