The Excel-2019 tag is used for referencing the spreadsheet component of the Microsoft Office 2019 suite released 1 Oct 2018 (Commercial preview released 27 April 2018). The version independent Tag is "excel". If it is about an Excel formula or worksheet function, then tag it "worksheet-function". If the question pertains to VBA code, the "vba" tag should be used in addition to this one.
Questions tagged [excel-2019]
183 questions
0
votes
3 answers
Taking the Cumulative sum of a Column while Selecting only a Specific Sum within that column
I have a table that has a symbol column and a corresponding number for it. Let's say I want the cumulative sum of only specific symbols such as ABC and DEF in this case , How can I build a formula that only takes the cumulative sum of only ABC and…
TeelowxD
- 27
- 3
0
votes
1 answer
How to create a formula that takes information from a table for a specific date in time
Given symbol such as (123) and a date such as (2021-08-11), I would like to obtain specifically stat 1 or stat 2 from a separate table (Table name is "Table1"). The symbol can appear more than once on the same date in the table but in this case stat…
TeelowxD
- 27
- 3
0
votes
0 answers
clear an existing table then paste the contents of another table into it vba
This table has two the first two columns which I want to paste in another table which is "table9"
the rows on both tables can vary however this is the sequence of the task. First clear table9, then take the first two columns of table3 and paste…
Hamza Ahmed
- 15
- 7
0
votes
1 answer
deleting all rows in a table without losing formula information vba
I have a table that is:
This has formulae, and the number of rows in the table can vary. I want a code in VBA which I can apply to an Active Button that would delete all the rows of the table and turn it something into like this:
However I still…
Hamza Ahmed
- 15
- 7
0
votes
1 answer
Getting a value error while using SUMIFS function
I want the gross amount of each unique email if the days remaining is less than 12 and if the unique email is present in the email column.
I have used SUMIFS function but I am getting a value error.
Is there any workaround?
Vignesh Satheesh
- 13
- 4
0
votes
1 answer
How to take a list of Numbers that contain decimals and turn it into a list of Whole Numbers only. (Excel 2019 answer only)
There was a similar question posted about this that works well with Office 365. However, an answer that works for Excel 2019 is gladly appreciated as well as a formula that work regardless if there is other calculations in the workbook.
For example…
TeelowxD
- 27
- 3
0
votes
1 answer
VBA ByRef argument type mismatch in Excel 2019
Another failed attempt to escape from VBA. I am trying to parse a string in Excel VBA into two variables. I do bring up the non-common sense portion in my head to work on it but still no luck.
Sub StartEndMonth(ByVal MonthRange As String, ByRef…
chapter3
- 914
- 2
- 12
- 21
0
votes
0 answers
vba LinEst worksheetfunction 2019
I'm trying to loop a LinEst function in vba but it gives me error "Type mismatch"
For i = 2 to x
.Range("A" & i) = Application.WorksheetFunction.SeriesSum(xVal_start, 3, -1, Application.WorksheetFunction.LinEst(y_range,…
0
votes
1 answer
Can a worksheet ActiveX ComboBox work on a Mac?
I have worksheet ActiveX ComboBoxes in my file (Excel VBA 2019) that are not working on a Mac computer. Is there any way that I can get these to work on a Mac?
I know I can use Form Controls that will work on a Mac, but a Forms ComboBox doesn't…
Paul Martin
- 17
- 4
0
votes
1 answer
How to create a hyperlink with a userform ? VBA
I have create with many help a code who create with a user form a new sheet with the name of the client and many other information. And in the first page who resume all name client i have made an hyperlink (column C) who send to queue name of the…
Cédric Coutant
- 13
- 5
0
votes
2 answers
How to Extract ALL Unique Values from one table's column to another table's column?
I am having serious issues trying to understand absolute reference within TABLES. I do not want to use the =UNIQUE function as it causes #SPILL errors and I need the unique values in another table. Furthermore, the =UNIQUE function is unique to…
D41V30N
- 171
- 1
- 9
0
votes
1 answer
AdvancedFilter to exclude multiple criteria in Excel VBA
I've been trying to use VBA's advanced filter method to exclude a set of criteria. Here is a simplified example.
My criteria are stored in the worksheet "Criteria", as such.
I now want to filter the data, such that any entry containing the name…
MonteCarlo
- 26
- 4
0
votes
1 answer
How to use conditional formatting to compare two columns
Here is a very simple conditional formatting problem although I cannot see what I am doing wrong.
I want the cells in column E to be green if they have a greater value within than the cells in column C and red if vice versa. What am I missing
Insider
- 95
- 12
0
votes
1 answer
Why has my VBA stopped working only in certain parts?
Recently the VBA has stopped working. Normally it auto-populates today's date into column B when you enter data into column C and also populates today's date into column R when you enter data in column K.
I have recently messed around with…
Insider
- 95
- 12
0
votes
1 answer
How can i used nested SUM functions with multiple criteria?
This formula is nearly complete, I am just missing a small part of it that I cannot see!
I want cell A19 to SUM column K:K if column A:A contains either OPEN OR CLOSED.
What is it I am missing?
The formula works if only counting CLOSED or OPEN…
Insider
- 95
- 12