large

Hello everyone. I'm new here and excited to share and answer. I've ran into several situations were I need to compare a list of values/text to see if they consecutively match up in a separate table/range. I thing I have finally found a solution which can be universally applied in similar...

I have a table. Column A is Activity, Column B is a list of values that run from BA9 to B108 which are EXPENDITURES, and from B111 to B160 which are INCOMES I want to take the 5 largest and the 5 smallest numbers from the entire list of Expenditures and Incomes and put them in a separate table...

Hi all, I would like to use functions like LARGE, SMALL, MAX, MIN and SUM in spilled arrays and get the values PER row instead of the total. For Example: x y =MAX(A2:B2) dragged down =MAX(A2:B5) 1 2 2 8 3 4 4 5 6 6 7 8 8 The only solution I...

Hello everyone I'm trying to use the formula =MAX(FREQUENCY(IF(T2:T11>1,COLUMN(T2:T11)),IF(T2:T11>=1,COLUMN(T2:T11)))) to find more than one maximum value before a zero from a range. Column T has this values 1 2 0 1 2 3 4 5 6 0 I want a formula/formulas that will...

I need to pick up the lowest value out of two highest out of three. So I have now 3 non-numerical values, which correspond to numerical values and I need to choose the lowest out of the two highest. I figured out that I can use LARGE to pick the 2 highest values and then use MIN to pick up the...

Hello, I've tried small, large, aggregate.. I just can't get it right. My goal is to have a list on a separate sheet, but I tried on the same sheet as the data to see if it can be done first. Look for ID within the list and match, check if that ID matches a criteria in another column (other...

Dear Excel Experts -- I have a stacked bar chart that I am working with that is starting to out grow even 11x17 (Tabloid) paper sizes. I was trying to figure out how to have excel split it so that it would span multiple pages. Ideally I would like to have the data table on the chart also...

Any help would be tremendously appreciated. I am on hour 2 of trying to figure this out. An example: Tab 1: Job # Job Revenue Job Cost Job Status Job Mat Spend 23 100 80 Closed 20 42 200 150 Active 10 56 100 90 Active 30 71 150 30 Active 40 83 100 85 Active 40 I have around...

I really thought that this was going to be simple, but I just can't figure it out. I have a list of 70 values in a range. There are multiple rows of values for each of these columns. For this example, the rows could be a physical good, and the rows are customers. The values in the table...

Hello, I am calculating a weekly score for number of steps performed. I'm taking the top 5 days out of the 7 days in a week using this: =AVERAGE(LARGE($B$2:$B$8,{1,2,3,4,5})) The NO HOLIDAYS table in my spreadsheet is working perfectly. The HOLIDAYS table is just a copy of that table which...

Hi, This is the first time I've posted here so apologies if any of this is incorrect. I have a list of products ordered by week with their volume. I would like to select the top ten products by week. I have found and used the formula which gets the top ten, but I am struggling to do it by...

Hello all, this is my first post. I’m having an issue with Conditional Formatting. I work in a warehouse, and I am having issues in a certain section of the warehouse with items being split across several different stock locations rather than being consolidated into 1 or 2 locations. There is...

All, I created a very large Excel file (i.e. hundreds of MBs or 100,000 rows by 369 columns) for calculating a sample of about 100,000 insurance policies across five or so different companies. I started off by building out the first row with all the needed formulas and then have copied them...

Hi, Is it possible to change the reference range in a sumproduct large formula to expand based on a value in anther cell? I'm using this formula: SUMPRODUCT(LARGE((A2:A9=G2)*(B2:B9),1)) and would like the range to expand based on value in another cell, say E1. If E1 was 20, than I would like...

Hi I realize the title is not that helpful I have a relatively large spreadsheet - around 7 MB - with a lots of calculations and 50+ tabs It calculates fine and very quickly. However, my problem is that if I move a tab or insert a blank line (even if that line does not impact any...

Where can I go to find out why excel takes so long to save a large file, continually bogs down while performing macros etc. I use several different large spreadsheets with lots of calculations going on, they run and save quite well on my PC but bogs down on my assistants PC. Here is one error...

Hi Experts, Need your help in this. My boss wants me to create values for a group of materials bifurcated on basis of pack x Channel, now the values for a pack/channel combination should sum up to 100. <tbody> Unit Brand Channel Pack Value% EAST Product 1 Insti Medium EAST Product 1...

Hi, I have a large range of data - I need to use range formulas using If and Large combinations to return the largest number when certain conditions are met. As the dataset is large, there are duplicate values. As a workaround I add a very small number to every number in the range, to create...

Extremely large data set that will include the following information. Is there a simple method (formula) to provide the following summation (for a large data set,A1:A200, etc.)? <colgroup><col width="99" style="width: 74pt; mso-width-source: userset; mso-width-alt: 3620;"> <col width="64"...

I am looking to use a IF formula but not sure how to write it so it returns the value i want. I have a list of SKU's that have a location by them, i also have a separate list of locations. I want the If formula to return a value of 1, if the SKU's location appears in my 2nd list...