All Questions
4
questions
0
votes
1
answer
117
views
look for empty cell between non empty cells in one row and then put 0
enter image description here enter image description here
A B C
abc 30 40
def 4646
ghi 45 3234
So, I want to write a macro code where it takes all three columns into consideration at once....
0
votes
2
answers
691
views
Excel VBA - Dynamic Array not Working
I am trying to make an array that stores all of the values in Column A from "Workbook B" so I can then reference and see if a cell's value is in that array in Column A from "Workbook A&...
0
votes
1
answer
514
views
Inserting Array Formula with VBA
I am trying to insert an array formula using VBA but I keep getting the error
"Unable to set the FormulaArray property of the Range class"
Sub Insert()
Range("J2").Select
...
0
votes
2
answers
568
views
Checking if sum of arbitrary amount of cells in a column matches a cell in another
The result I would like to achieve is Column 'C':
To make this spreadsheet easier to copy/paste into your own, here is copy-pastable data:
ID
1
2
3
4
5
6
7
8
9
Number
1000
300
800
300
200
ID
1
1
...