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...
Hi all,
I have the following topic that I cannot take a step further:
I need to summarize data from 3 tabs into a table based on multiple criteria and as it can be seen below I have created 3 different sumifs. The index matches the month, and then follow the 2 criteria.
My goal is to reduce...
Hi,
I have a big sales report which expands every week. It shows the sales in different weeks (CYWeek) for each of the 15 stores.
Now I want to make a graph to show the sales for each store during the year, so It's easy for me to see trends for all different stores.
I have the criteria CYweek...
Hello,
I try to figure out how to sum from a table right numbers, can't make it work, stuck for a few weeks :eeek::
<tbody>
A
B
C
D
E
F
G
1
Urban
Rural
2
18
13
L1
L
?
3
27
14
L3
H
?
4
72
5
H1
5
32
57
6
4
38
L1
7
-----
------
-
-
-
-
-
8
L
L1
Urban...
Hello,
I hope I can explain my question - I try to solve this problem for a few days and didn't find any solution.
I attache the file to make it easier to understand, short explanation of attached file, it have 3 pages:
1. Spots - it contains 2 tables. First table is connected to 2nd one. For...
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.