All Questions
1,139
questions
0
votes
0
answers
39
views
Dependent Pivot Drop Downs
I am hoping someone can help. My search thus far has yielded no results, and I refuse to think this hasn't been released yet.
I have a Pivot of an extremely large set of data. In the filters is a ...
0
votes
1
answer
28
views
Trying to create a drop down list that is able to filter out all other columns base on selection (calendar months)
I have a rather crude spreadsheet that tracks simple monthly data with each month in a different column. I'm hoping to create a drop down list in cell B6 or C6 which allows the user to select the ...
-1
votes
0
answers
13
views
Pivot filter : How to get the drop-down on the first element of Row in pivot table:
I received an excel file with five elements in pivot table
Geo, Country, Partner Name, Persona, and End Date
However, I am unable to apply filter on Country, Partner Name, Persona, and End Date as the ...
0
votes
0
answers
45
views
Excel VBA transpose/filter to other sheet
I'm trying to automate the sets of data. So far I have this code that filters the data to another sheet but I cannot figure out how to transpose the data vertically. I've tried adding Transpose:=True ...
1
vote
3
answers
116
views
Combining Excel FILTER() and SUM() Functions
As efficiently as possible, I am wanting to take a tabular dataset in Excel where there are (purposefully) duplicate identifiers to records and consolidate this to a unique/summed dataset (very common ...
0
votes
1
answer
83
views
How to copy and paste data into n new workbooks based on two filters with VBA?
My goal is to copy and paste data from 1 Master workbook into n separate workbooks.
The user should be able to select a "Desk" in the Master which then triggers the creation of X amount of ...
0
votes
0
answers
27
views
Populate results based on stacked data set [duplicate]
I wanted to filter the agents from the stacked column dataset A3:A26 to my table C3:F7.
My problem is how can I filter them easily using only the headers on my table from C2:F2, and my dataset only ...
0
votes
2
answers
96
views
How to make excel detect Products in a Bundle and deduct each of said Products in Inventory?
As shown from the picture, it doesnt deduct the SKU sale from Bundle with the sumif formula
Lets say Bundle A has Product A100, B100 and C100
I have 3 tables:
Bundle table: List out Bundles with ...
0
votes
1
answer
86
views
VBA Macro for Exact Match Filtering
I have a VBA macro that filters on 6 differents criteria, but I'm encountering an issue where the filter includes partial matches. For example, when I filter for the element 1 "G56", it also ...
0
votes
1
answer
56
views
VBA code is not copying the full set of data
The below code is supposed to copy all matching REGION rows with e.g. ASIA (EX. NEAR EAST), but for some reason it doesn't do anything if the first row (non-header) is not "ASIA (EX. NEAR EAST)&...
0
votes
0
answers
29
views
Reducing the width of data validation list - Excel
I can't seem to find an easy, VBA free way of reducing the width of the validation list below to fit the data. The source list alos has a narrow column width. So too does the destination data. Any ...
1
vote
1
answer
55
views
How to filter an excel date column using VBA?
I’m working on a VBA script in Excel that filters a range of cells and then prints the filtered rows. However, I’m encountering a runtime error and I’m not sure how to resolve it.
Date filtering : For ...
2
votes
2
answers
73
views
I need to fix this formula so that the columns letters go UP as I drag DOWN
So specifically with the following formula, how do i fix make the range say =B2:b21, =C2:c21. =D2:d21, etc when i drag down?
The full formula is:
=TEXTJOIN(", ",TRUE,FILTER('Staff Rota'!$A$2:...
0
votes
1
answer
44
views
c# Excel Interop How to setup a filtered area without applying a filter
We are using Excel for reporting. As part of one of the reports the users have requested that a subset of the UsedRange of a worksheet is setup as a filterable area. i.e. were I to do it manually in ...
-1
votes
4
answers
138
views
Adding empty rows between values while using Filter or Sort
Hi I am wondering if I can add empty values to filter or sort formulas in excel.
My idea is to create an empty row to separate the results.
So for instance, this is a result of a sort function:
I ...