largest

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. If I had a formula for the 2d largest I can figure out the other nth Largest...

Hi A have a row with 0 and 1 and they comes in a serial. A wants a formula to calculate the largest/ second largest serial of 1's in a row. I wants to variate were to start and stop, sometimes I have to start counting in a middle of a serial of 1's 1111111110000000111111000000000001111111111...

Hello, I am making rate calculator for clients to type in their ages and the ages of their dependents to know their insurance premium. Blue Cross has the rule that subscribers only pay for the first three dependents under the age of 21. (the largest 3). These ages and rates are only a sample...

Becasue I am not adept a creating macros I frequently have to create spreadsheets that are similar to the samples that can be downloaded from: http://mandgweb.net/excel-samples/sample.xls by recording them. After creating the macros buttons are applied and macros are assigned to them to for...

Hi, I have a table and when I update it, it loses its "Sort largest to smallest", and I have to press the filter and then set the criteria again. I would like to avoid this and "keep" the table sorted by my first column that has the large and small numbers in it. Any idéa on how to keep a...

Hi! I need some help. I want to find the second largest value in an MAXIFS function. My Maxifs function only returns the highest. I've tried to use the large function around the maxifs but it didnt work. Any suggestions? Thanks for helping!

Hello! I've tried many different methods for what I am trying to do and none seem to work quite right... Please see below for what I am attempting. I have a table with two columns- the first column has words and the second column has numbers. In the second column, I have conditional formatting...

Hello, A3:G200 has my data that gets pulled in by macro. In I10:I210, I would like a formula or a automatic method to sort D3:D200 (percentage value) from smallest to largest while keeping original data in the columns next to it. As of now I have I10 filled down to I210...

Hi All I am having trouble with the following situation I have a data set 1 A B C D 2 GDP 100 200 300 3 BBB 400 500 600 4 XYZ 700 800 900 I would like to do an index/match formula that returns the largest value for GDP which would be 300 by searching...

Hi All I have data in columns A4:DR & LastRow (4 being the header row) I want to be able to look at each column from G onwards and see if the word "Hello" appears in there - if it does, sort smallest to largest based on that column. Continue to look at every column and if it appears again then...

Hoping someone can help me out.... I am working in a spreadsheet with almost 10,000 rows of data and growing. I have an array formula that provides me with the largest (5) value within a date range as follows: {=LARGE(IF(Dates>=$A$5,IF(Dates<=EOMONTH($A$16,0),IF(Zones={1,2,3},LineStop))),F5)}...

Hi, I wonder if someone would be able to help me. I have a spreadsheet that has columns as follows: 0 1 2 3 4 10% 15% 20% 5% 25% I want to then populate cells with the 3 largest percentages, however, if I use the LARGE function, it gives me the...

Hello, I have 2 questions, How do I get the largest value from a row using only the values from every other cell? Specifically from the cells B2, D2, and F2. I think I can add the other cells I would like to get the large from if I know how that much of it is formatted. Also, how do i get...

Hi I'm looking for a formula to find the 2nd largest in a range including negatives, but ignoring zero values. eg, range of values is 8 0 -2 0 -6 -8 -9 I have tried to calculate a formula which gives me -2 as the second largest value, but had no luck. Can anyone kindly assist? Kind...

I have the following table: <tbody> A 2 B 3 C 5 D 5 E 1 </tbody> I use the following formula to find in col A with highest value in col B: =INDEX(A$1:A$5;MATCH(LARGE(B$1:B$5;1);B$1:B$5;0)) Result =C. Now, to find the second largest (D) I use the same formula, where the argument in the...

Hi, I have data in a spreadsheet that has products down the side and weeks of sales across the columns. I need to find the largest week of sales and also the value in the column previous to it. I have been able to use the Large formula to find the largest sales week but I am not able to figure...

Hello, I am looking for a formula to add 100% of the largest number or sets of that number with 50% of the second largest number or sets of that number. For instance, the following numbers may be in cells 12 35 14 14 6 14 So the formula will first see 35 is the biggest number, and there is...

Hi, I'm stuck and I'm not sure what to do. I'm not what you would call an Advanced Excel user but I'm able to get around and most of the formulas make sense. I've linked an image of what I'm trying to do. Essentially, I'm trying to take information from the Total Responses section and show it on...

my data is as below: column 1 column 2 1 1 2 1 1 2 1 3 2 2 2 3 1 4 2 4 1 5 1 ????? I...

Hello, I need help evaluating a range for the largest and smallest values, but I would like to restrict my output based on another range. Assume A1:A100 include values ranging from $100 - $100,000 and column B1:B100 includes percentages ranging from 0% - 50%. I would like to identify the top...