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...
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...
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.
New to Mr. Excel Forum. searched many blog but not reached to the solution. please help.
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...
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...