All Questions
114
questions
0
votes
0
answers
82
views
VBA Formula Instead of FormulaR1C1
Following code works as intended. However I am trying to avoid copying the formulas in each cell inside my FormulaArray using FormulaR1C1. It slows down my data collection in my other array. Because ...
- 155
0
votes
0
answers
60
views
moved an excel file between two computers and curly brackets was added to formulas
Moved a file from my laptop to desktop. Laptop has Office 2021, Desktop has 2019.
Formulas like this:
=IFNA(INDEX(Earning!$A$1:$N$1000,MATCH(CONCATENATE(ROW()-ROW(G$2),"_",VALUE(E$1)),...
- 1
0
votes
0
answers
67
views
Dynamic array with VBA - Excel [duplicate]
I m using VBA code to import below formula to specific cell:
.Range("AA9").Formula = "=SORT(UNIQUE(FILTER(tblClients[Clients],ISNUMBER(SEARCH($C$2,tblClients[Clients])),""Not ...
- 8,116
0
votes
1
answer
30
views
unexpected result of Excel formula
i have the following formula; =BYROW(SEQUENCE(30;;0,01;0,01);LAMBDA(n;MOD(n;0,03)))=0.
Excel returns
{FALSE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE, TRUE, FALSE, FALSE, FALSE, FALSE, FALSE, ...
- 39
0
votes
1
answer
454
views
Excel Get total number of unique text values based on condition
I have a weekly breakdown report that requires I collect the total count of unique value of Agents Audited per Week. I have done some research and have come up with a couple ways to get a unique count ...
0
votes
0
answers
19
views
Excel: Unloading an array of data by condition
How to get a list (array) of period dates when the accumulated amount becomes negative?
Also interesting is the formula, how to find the first / last date at which the accumulated amount becomes ...
0
votes
0
answers
462
views
I want to add a column of identical text values to the output of the FILTER function
I'm using VSTACK to combine the output of different filters (same structure, but from different worksheets). However, I want to be able to identify from which sheet each row has been filtered, so I ...
0
votes
1
answer
208
views
Excel Question: Search an array for a value and return the cell group name that value is found in
video of working spreadhseet
I am building a track and field event lineup and need to search for an athletes name in an array of cells and then return that value to a cell next to the athlete's name. ...
2
votes
1
answer
120
views
How to split a search string into parts, then check parts against a database
Here's what I'm dealing with:
We have a database of machines and their part lists are specified using strings. For example, one machine might be specified with the string &XXX&YYY-ZZZ, ...
- 21
0
votes
1
answer
47
views
EXCEL from input using formulas / arrays?
EXCEL question
The sample data is on the left -> how to achieve the expected result using excel?
0
votes
2
answers
833
views
How to copy a row N number of times in the same column in Excel?
We are not able to create a formula which will copy 200 rows of a column in a same order and paste it multiple times in the same column and in the same order.
Example: columns A1:A200 have names in a ...
- 241
0
votes
1
answer
105
views
Getting the above value of the currently processed array (result array during formula execution in excel)
I know how to get a value from an above cell of a cell with a formula being executed but I am struggling to do the same with an array. You can simply refer to the above cell and then let the drag ...
- 48
0
votes
3
answers
121
views
Checking for duplicates per column in a dynamic Excel array
I'm trying to generate a formula in Excel that evaluates the presence of duplicates in a dynamic array per column and then returns a new 1-dimensional array that contains either True or False when ...
- 1
0
votes
2
answers
681
views
Use index, match, and row/column excel functions in a formula to return a subset array with just cells with text and exclude the empty ones
I have this scenario where i want to extract a subset of a range in one row (using index, match and row functions preferably ) and return only smaller filtered array with cells that contain text/data ...
- 3
0
votes
2
answers
360
views
Excel 365 Function to Count Occurrence of Array List In Original List
I have a list of company names in the sheet "Defects". I built a unique list of those companies in a sheet called "Report" using this function utilizing an array list.
=SORT(UNIQUE(...
- 123