Hello - In my example below, I'm trying to use an array formula to filter the Top 5 "Accounts" in column AA based on the "Sumif Labor Cost" in column AB. I want to ultimately do this with a single array formula in cell AA13. I've provided the rank in column AC to show the top 5 items that I want...
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...
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...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.