filter array

I am looking for some help in one formula to get the desired output...I have data table something like below...which includes Name, Date, Amt, Type and Place... I have only Type1, Type2 and South, North...these will not change. <colgroup><col span="2"><col><col><col></colgroup><tbody> Name...

Hi all, ActiveSheet.PivotTables("BuyerOnTime").PivotFields( _ "[Fact_Purchase].[USER_NAME].[USER_NAME]").CurrentPageName = _ "[Fact_Purchase].[USER_NAME].Buyer(i)" I am trying to make a VBA code, that can change the filter of a Pivottable in a dynamic way. I made an array...

Is there an easy way to see what columns you are currently filtering on in a large filtered set of data? I know the arrow changes to a different symbol when you have filtered on a column but it is painful/difficult to scroll through and find these on 100+ columns. TIA.

I have a range, say B4:B13, in which each cell may contain a value, some text, or may be left blank, for example: <tbody> 0 2 "" 5 Yes 6 9 "" 12 No </tbody> I need a formula to check if the numerical values in this range are in ascending order, but ignoring any text and...

Hi everyone. I have three different data sets/tables that contains some common columns. The first five columns of each table have the same data type: case, period, place, process, unit. The rest of the columns have different, but correlated, data. The first table contains the feed streams of...

Hi guys, This is my first post on this forum so sorry if it's not clear but I'm hoping for some help with a formula. I'm trying to design a formula that will present people with a list of holiday destinations based upon when they'd like to go. On the sheet 'Countries' there's data with each...

Hello!, Please I ask fro support in applying function for specific element DAX. I Have a column called LOB, contains 11 elements "Criteria" <tbody> LOB Business Golden Customers NC Reapers TEData-Sales TEData-Sales "Subscription" WE Xceed-UP Q Xceed-Basic Xceed-Sales...

Hello, this is my first post! I pulled this great formula from exceltactics.com and it works great for filtering through a single source list to produce a dynamic output list. In particular I'm looking through a todo list for only items for today or before. I have multiple todo lists and...

I am having trouble modifying a formula I built out to calculate what the weighted average price of a filtered set of data is. After a lot of trial and error, I was able to successfully create an array formula that could do the above. However, I now want to add if parameters to the formula that...

Hi I have some sales data, I use Pivot Tables to organize the data into countries. So I have a column of countries with a column of sales for each country. Now I would like to sum up the sales into various groups, namely: 1. Germany 2. Europe 3. Non Europe I can do this manually by using...

b. Take a spreadsheet that has in Column D a name for an entity: (for example, call it 'United Airlines') b. Filter the data in spreadsheet by Column D (called United Airlines). Note there will be 56 of these queries...one after the other with diffrent names... c. Delete all other data in...

Hi all, I am trying to use the following code to filter on field 2: Sub FilterInvoices() Range("B6:N9000").AutoFilter Field:=2, Criteria1:=Array(Range("C2").Value, Range("D2").Value, Range("E2").Value) End Sub The results only seem to be looking at the final value in my specified ranges...

I am working on a series of Gantt chart reports where one of the requirements involves the end-user entering one or more "employees" to view all of the programs assigned to them. I can’t seem to filter on the Lead/Test field if the cell isn’t exact. I am also filtering only on the last...

Hello, I've managed to filter OLAP Pivots before if the CurrentFieldName was one option. Now, I have a range of dates that cannot be selected using the between function because the OLAP Cube isn't set up that way. I've set up a date table in my workbook that has all the possible dates between a...