Hi
Trying to create formula foe the below table which has multiple criteria x Qty x Duration (with two dates)
Attached sample file: Eg for Apple. Same as vlookup to be made for all items like carrot, beans, tv from nested cells.
After this, the results will be converted to Pivot table /...
I have a situation where I have 4 contract types and many clients have multiple contract types. I have created a spreadsheet with a "switchboard" so I can select the contract types I want to include in my sales estimates using "TRUE" or "FALSE". I can also set a percentage threshold based on...
Hi all!
I have a question regarding on how to get multiple values from different sheets with multiple criteria.
What i basically want to do is the following thing:
I have multiple weeks (Week 1-52)
in all these weeks i fill in the hours that i've been busy on a project with a certain sub-task...
I have two sheets, one named, "DATA" and another named, "STATS".
I need to enter a formula in a cell in the "STATS" sheet that will count the number of unique dates in column G from the "DATA" sheet but ONLY IF column F contains the text, "JC".
<tbody>
F
G
JC
22/10/2017
JC
22/10/2017
AF...
Hi! I've using cycle macros for searching in each column certain value and then comparing values in adjacent columns in order to get values to show or similar matters
At this moment I found out that there is a way to call formulas from vba code via Application.WorksheetFormulas
and at the same...
Hi,
I have a pivot table that is based on a data set which is updated every month. The pivot table has a multiple criteria filtre in order to select the month ie 1/1/2017,2/1/2017,etc.
I want to select the months from an external cell, meaning that if I type in 5 that cell the pivot table...
Hi all,
With help from the internet, I was able to find out the first and last test attempt for a user using an array formula, but I'm having trouble adapting it to look at TWO criteria (Name and Course). Because it is only currently looking at name, users that attempt Course 2 more times than...
Hi All,
I have an issue that I am hoping someone can help me with.
<tbody>
31/10/2017
Manual Entry
Orange
Manual Entry
31/07/2017
31/08/2017
30/09/2017
31/10/2017
30/11/2017
Apple
65,906.16
64,208.91
60,553.10
61,147.29
(65,168.44)
Orange
82,423.36
79,439.45...
Hello, Im trying to write a formula that calculates an average for a location under a specific period.
I have to specify the start and end dates and also the location and then get the average.
With one location I was able to calculate the average using averageifs, but if there are multiple...
Hi Folks,
I want to be able to get a sum for a column using multiple criteria in at least two other columns. I don't have a problem when using multiple criteria in only one problem, but I can't find a way to have multiple criteria in multiple columns.
An example follows:
Product
Supplier...
Hey there,
I have been reading around this subject for a while now and I can make it work for 1 value but not down a whole column.
Anyway, I am looking to have and index and match using 2 criteria in separate columns. But I created that, I could not drag it down my destination column (probably...
Hi There
I'm new to excel and was wondering if you could help me :0
So I have a spreadsheet with 2 worksheets.
The one has 3 columns: Brand, Date, Traffic
The other one contains a table that should only show the traffic amount my website received based on the brand and date in the worksheet...
Hello. I need to count the number of donors who have contributed as of 09/30/2017 in the North America region Only. How can I do it? I am using the frequency and match formulas, but I don't know how to use it with multiple criteria, such as, dates and region. I have this data,
Region/...
I am statistician for football team. I have created a list of team stats for the entire team, but am wanting to create separate lists for individual categories such as rushing and receiving, but only include those individual players with at least one attempt. The following is a sample from...
Hi,
I need some help with an excel file.I have tried to do it with an index match function, and some cells come up with #NA other cells will come up with a value. Every month I pull a report (Discover Report) that has three columns. The first column is the project number, second column is the...
Hello,
Using 2010 Excel, I have 192k rows and 6.5m filled cells of data that I need to be able to match certain criteria to and pull the matching rows from the data sheet into another sheet. It also needs to be as fast as possible (no looping?).
My research took me to these posts regarding...
Hi Guys,
First post, hope I'm doing this right!
I have Table1 which contains the values I need to Average into a column in Table2. The selection of rows in Table1 for the Avg is based on multiple criteria matching every row of Table2.
My problem is with solving the requirement for me to use...
Hi all,
I have hit a dead end and am in need of some help. Apologies in advance as this scenario is slightly lengthy I want to ensure that you all have the full information.
The data that comes out of the accounting system is raw data dumps from 2 SQL data tables, one gives me all the purchase...
EDIT: I tried changing SUMPRODUCT to just SUM and that works. How do I make SUMPRODUCT work to get the output I need?
Hi all,
I've got a long SUMPRODUCT formula to search through a big database and sum the range of cells that match all criteria. I've checked all individual components of my...
I read many posts and researched the Index Match function & still keep getting #N/A :confused:
I have 2 sets of data that I need to compare for a data conversion project. I need to update the old dataset with new account, subledger, department values in order to get the closing balances to...
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.