1,873 questions
0
votes
0
answers
26
views
How to use complex formulas in data validation via VBA without Excel adding the @ symbol? [duplicate]
I'm facing two related problems while working with VBA in Excel. Both involve complex formulas, but they behave differently when set through VBA compared to when entered manually in the Excel UI.
...
-3
votes
1
answer
144
views
Memory is not being allocated [closed]
I am sorry if the question is stupid. The problem is that memory for my dynamic array inside a static structure is not being allocated. The reason might be my pc (it is a really old notebook with only ...
0
votes
2
answers
69
views
Adding SORT or SORTBY into excel function
I am looking to add a sortby or sort function into my query but can't figure out how.
=TAKE(CHOOSECOLS(FILTER(Revenue,(Revenue[Top Product]=$C$66)*(Revenue[Location]=$C$67)),1,2,17),10)
Here is what ...
- 45
0
votes
2
answers
144
views
Is this truly best way to delete last element in C? [closed]
I have a code where I need to delete last element of array. I made this code but I am wondering is there a more optimised way of doing this?
My version:
void DeleteLast(int** array, int* size)
{
...
0
votes
1
answer
94
views
Excel Filter Function based on a variable sized array of conditions + inputting results into a 2x2 grid
I am looking to make a pre-existing function more dynamic such that the user can readily change the filter conditions without needing to delve into the formula and changing manually. I would prefer a ...
-1
votes
1
answer
72
views
How do I manipulate this dynamic vector for fold operations
I am working with flex/bison to create an interpreter for a class. The problem that I am encountering seems to be related to using/converting a dynamic vector. I am trying to create a function to ...
- 15
1
vote
2
answers
166
views
How to keep a pointer to a Dynamic Array valid after resizing the array?
I have a dynamic array, and I need to maintain a pointer to it. Here's the setup:
var
Controls: TArray<TControls>;
Items: ^TArray<TControls>;
begin
Items := @Controls;
end;
The ...
- 13.1k
1
vote
2
answers
147
views
Access JSON strings with different keys using Databricks SQL
I have a array with JSON strings and each JSON has a different key. Also, the size of the array is not fixed and may increase or decrease in occurrences.
An example of this is below :
"[{"...
- 2,745
0
votes
2
answers
93
views
Dynamic array first element remove complexity
I was reading about CPython’s implementation of list.pop(k) method and learned that it takes O(n-k) to remove the kth element of the list since it needs to move the posterior elements one position to ...
0
votes
1
answer
94
views
Is there any way at all to get the size of a dynamic array with sizeof()? [duplicate]
I'm a computer science student and one of the questions on a test asked to implement realloc in C using malloc. My teacher said the correct answer would be to get the sizeof of the previous array and ...
0
votes
1
answer
52
views
During the second call of strtok(), the code raises the following error: Invalid read of size 1
I am new to C++ and I do not understand why the code doesn't continute tokenizing the text array, and instead raises the error.
I suspect that the problme might be because of passing the token ptr mid-...
- 3
6
votes
6
answers
443
views
Excel - Aggregate dynamically values in a Table using array formulas (MAP, BYROW, CHOOSECOLS, TEXTJOIN, LAMBDA, FILTER, HSTACK) in a single Cell
I would like to aggregate, merge, compact some values as shown below
The input is a table and the output is dynamic array formulas on a single Cell and has a goal to aggregate other columns based on ...
- 65
1
vote
0
answers
63
views
passing 2d c array to labview [duplicate]
I want to create a dll that gets some data and put them in a 2d array and then pass it to labview
the problem is all I get is a pointer instead of the whole array
I allocate array in c by using malloc ...
- 21
0
votes
0
answers
31
views
How does ctypes.py_object works?
I have been studying DSA and don't understand how ctypes.py_object works. As of my knowledge it works on concept of pointers to create an array of pointers that will store memory addresses for values ...
0
votes
2
answers
52
views
Excel MS365: 2-D dynamic array creation problem
I have an Excel problem that boils down to the following:
Given the input range A1:B3 (a 2-D array), is it possible to use only formulas to create the output D1:K3? I would like to use the input ...
- 3