All Questions
4,781
questions
0
votes
1
answer
25
views
EXCEL Sumproduct COUNT 2 AND condition every nth COLUMN, counting blank and not blank
Good Day to all! as my title suggest I am having a problem with the sumproduct formula to get the result that for the following condition
Check and Count every 4th column range for NOT blank ...
1
vote
0
answers
21
views
How to stop a #N/A result showing in a most frequent value formula? [duplicate]
I have a spreadsheet of raw data that includes a cost based on a product code. I am trying to create a table that collates that information into an easy to read overview.
The cell I am currently ...
0
votes
0
answers
46
views
Best practice approach for dynamically loading and referencing large datasets [closed]
I have an analysis framework which operates on large datasets loaded from other workbooks. The sets comprise headered columns each containing a single metric, with multiple columns on each sheet and ...
0
votes
1
answer
69
views
How to loop through an array?
How do I loop through an array?
The idea is to go to the Names worksheet, Where I have a list of users Initials and names in a list. Create 2 arrays that record the initial and name of each person. ...
-1
votes
0
answers
35
views
Access nested array output in compose using power automate
I'm working on an excel that was saved as XML Spreadsheet 2023, I got too deep into the table row, but I've lost sight how to get to the innermost value. I tried Parse JSON and Compose but I can't ...
0
votes
2
answers
62
views
How to get a string array in an Excel cell and use as a reference
I have the following formula:
=SUM(COUNTIF(Country;{"CHN";"SGP";"AUS";"MYS"}))
where Country is a Column.
I would like to have a cell containing the array of ...
-1
votes
0
answers
46
views
EXCEL a dynamic solution for searching through 3 different arrays
I have so far all the names of teachers who match students post code, subject and age phase using TEXTJOIN.
I have then used TEXTSPLIT to separate the teachers names into columns.
Under the PostCode I ...
0
votes
1
answer
71
views
How do I deal with a type mismatch error in VBA?
My VB code keeps below and keeps generating a runtime error 13. Not sure why. Can someone point out what is wrong with the code below?
Sub GenerateUniqueData()
Dim ws As Worksheet
Dim i As ...
-1
votes
1
answer
42
views
VBA. Passing A1 = Transpose(range(“a1-n1” to a function
So the first array works fine but when i pass the array to the procedure I am getting a type mismatch for the array. I obv dont understand.
Proc1()
Dim Arr as Variant
Arr = Application....
0
votes
1
answer
68
views
In VBA, how to write an array that references all sheets in my workbook
I am using the code from the spreadsheet guru to mass protect/unprotect my sheets. This file is updated by me and used by other team members. I have some cells open to editing and others not when the ...
1
vote
3
answers
123
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
3
answers
80
views
runtime error 9 when pushing new array elements
I have a workbook with descriptive numbered sheet names. I need to populate an array with the numbers I extract from the sheet names. I am getting a runtime error 9 subscript out of range when I try ...
0
votes
1
answer
50
views
Using an Excel Array Function from Python
What I am attempting to do is use Python to open up a new Excel workbook, write some array functions in the first row and save the file so that when I open the workbook, my data is there. I'm using =...
1
vote
0
answers
60
views
Does InstrB convert byte arrays to string and then search or does it use the byte array provided in VBA?
Microsoft Documentation
If you use a byte array as an input parameter does VBA cast it to a string and create its own array or does it use the one provided?
Function NextOpen (byteA() as byte,...
0
votes
0
answers
54
views
VBA Adding Spaces to Numbers Populated from Range to Array
When populating an Excel range to an array, the numbers in the range gets spaces on either side of them after it is inside the array.
I am populating the range shown below to an array using the ...