large formula

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, I managed to use below formula to ignore blank and it worked, what I need now is how to get the top 20 or any top (any figure). I'm using below table as an example data: Formula I used : =UNIQUE(SORT(FILTER(Sheet1!$CQ$15:$CS$7241,Sheet1!$CR$15:$CR$7241<>""),3,-1)) Real data range in my...

Hi, I have a monthly/quarterly report that shows top 25 companies that we gained employees from. What I need to build a dynamic list that can be refreshed whenever I dump the updated data file and formula can be refreshed to update my list. I know using some formulas like rank, filter and other...

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...

I have been trying to figure this out for a few days and haven't been able to find anything online with this exact situation. I have a large set of data (~5000) with names of individuals, dates of completion, and scores assigned. I have figured out without too much difficulty how to average all...

I am going to input data in A2:A100. Based on a formula, a calculation is made and returns results in J2:J100. The lookup value is in cell P2. There are cells in column J that are currently displaying "#DIV/0!", due to the fact that there are cells in column A that have not been filled yet. I am...

Hi Friends, New to Mr. Excel Forum. searched many blog but not reached to the solution. please help. Query; <tbody> Sheet: DATA Sheet: Result a b c a b c 1 month emp code collection 1 Rank Jan Feb 2 jan a1 500 2 1 a1 a2 3 jan a3 500 3 2 a5 a3 4 jan a5 1200 4...

Hi all, In Excel 2010 I have a table of information containing sales of items. On anther tab within the document I am creating a dashboard with an overview of the main information people want to know. In the 'Sales Sheet' data table I am reading from I am interested in the following columns...

<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody> Data Names SKU1 SKU2 SKU3 SKU4 SKU5 Ali 0 20 15 0 0 Butt 15 0 16 30 Adnan 0 25 15 10 15 </tbody> <colgroup><col width="64" span="2"...

I have a workbook with multiple sheets. I am using the following formulas to find the 3 largest numbers in a defined cell across each sheet (L12). I need to return the name of the sheet as well. number will change, and I need the sheet name to be variable based on what the formula pulls in. Any...

Hey, Needed some help with nesting some formula. Suppose I have a row like this: <pre> A B C D E F 1 apple mango orange guava banana 2 2 4 1 5 5 </pre> a) Now, if I want to return the...

Hi, I have a table like this A B C D E <TABLE style="WIDTH: 339pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=452 border=0><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 48pt" width=64><COL...

Hi, hoping somebody here can help. I am trying to calculate the top 3 values in a range of 6 values and sum them. I was using the large formula =Large(E134:J134,1)+Large(E134:J134,2)+Large(E134:J134,3) and that was working excellently until I hit a snag. Basically sometimes there might only be...