386 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
79
views
Power Pivot for Excel fails to retrieve duplicate row from query
I'm fetching data from a SQL Server database through a query in Power Pivot / Excel 365.
It's to gather sales data from the rows of all the invoices in a particular time frame so I'm extracting fields ...
Advice
0
votes
4
replies
109
views
How to mark two largest values?
I need advice on how to mark the two largest values among a set of values.
1
3
2
4
FALSE
TRUE
FALSE
TRUE
0
votes
3
answers
111
views
Counting multiple ranges based on a single criteria [closed]
I have a data set where I have my criteria in Column A which is an alpha numeric code, and my values in Columns C through H. There are duplicates in Column A and I need these to be captured and not ...
2
votes
1
answer
152
views
VBA code to check if user-input filename is a duplicate
VBA newbie here. What I'm trying to do: Write a macro that brings up the Save As box with a filename pre-filled in, which the end user can edit if they choose. If the file name already exists in the ...
5
votes
3
answers
252
views
Expand records for each month between two dates
I have a few members lists for donations for a campaign. Individual members will to contribute for a duration.
Here is an example:
ID
Name
Donation Amount
Donation Start Date
Donation End Date
Status
...
0
votes
2
answers
100
views
Try to open Excel.xlsm file using xlwings results in Com-Error
I'm currently working on a project where I need to open an .xlsm Excel file through my code.
However, I keep running into the following error:
öffnen
Traceback (most recent call last):
File "C:\...
3
votes
6
answers
235
views
Attempting to create a pivot-like report using a formula
I am working with this data and attempting to create a pivot-like report using a formula, with months displayed as columns, status categories as rows, and the corresponding status counts under each ...
1
vote
0
answers
167
views
Is there a way to define a class Function call "If" in Excel VBA?
I am trying to implement a boolean based logic custom class for my application.
I am trying to define a Public Function If(trueValue as Double, falseValue as Double) As Double. The logic is if the ...
0
votes
1
answer
79
views
Excel/Excel 365 - =FILTER() function fallback
On Excel365, I am using a basic FILTER formula to retrieve data from a different Workbook (Workbook2) based on the cell content inside Workbook1.
For a given input in cell A1, which is a fiscal year (...
2
votes
1
answer
86
views
how to use Paramarray in Property Let in VBA (excel365)?
I am trying to write a VBA class with Get/Let properties of an internal dictionary.
here is the implementation of the properties.
Private m_Values as New Scripting.Dictionary ' I've added the ...
1
vote
1
answer
115
views
How to implement a Default property usage in nested class hierarchy inside VBA?
Consider the following code
parent.cls
Public Child as New ChildClass
ChildClass.cls
Private m_internal As New Collection
Public Property Get Item(index As Integer) As Variant
Attribute Item....
2
votes
4
answers
169
views
Cross sorting arrays
I have a table that list the tickets with a list of tests attached:
And I want to get the list of test with the tickets related to this test:
I'm using Excel Office 365 and the dynamics arrays, so ...
4
votes
6
answers
285
views
Nested BYROW in Excel?
I have five columns for which I need underlying nested values on a single row. Here is sample data I have:
ID
Product
Sales Manager
Sales Rep
Rep Status
1
Product1
Manager1
Rep1
Active
2
Product1
...
2
votes
1
answer
188
views
In Excel, why does the output of Unique() include duplicate values?
I am trying to use =TEXTJOIN(";",TRUE,UNIQUE(TEXTSPLIT(A1,";"))) to remove duplicate values from a semicolon separated list of names (as a string in a single cell on each of many ...
0
votes
0
answers
25
views
In my Excel 365 worksheet: I want to lock a specific worksheet but just let a data validation value box, assigned to a cell, operatable
In my Excel 365 worksheet: I want to lock my worksheet "Home" but just let a data validation value box (not form or active-x combobox), assigned to a cell ("I6"), operatable.
I ...