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
0 answers
Average Monthly Report Excel
I am trying to get the average time it takes to complete a project. The excel sheet is constantly being updated. I used =AVERAGEIFS(L:L,D:D,">="&$O2,D:D,"<="&EOMONTH($O2,0)) which gives me you can't divide by 0 and I tried pivot tables and they are…
svjeller
- 1
0
votes
0 answers
How do I add xlookup add-in for excel 2019
My current version of Excel 2019 is v16.29.1 and I'm having difficulty with adding the add-in ExcelDNA.XFunctions64.xll i.e trying to add the function XLOOKUP. I've downloaded this file from the following link…
Van Wilder
- 21
- 2
- 5
0
votes
0 answers
Lookup for Certain Text if so..Copy cell value of the same Row
I'm trying to do the following.
I got two sheets on the same worksheet.
Sheet A:
Sheet B:
When i check the checkbox on the Modules Filter (Drones) i need to fill a list with TYPENAME(Sheet B) that contains only Modules that belong to the…
user9561062
0
votes
1 answer
Excel MAC 2019 Help Compare Characters In Cells
I have an Excel sheet with two columns (A & B) each cell containing text, I would like to be able create a third column (C) with the characters that are different between the two.
There are 50,000 rows to go through.
An Example:
Another…
PaulW.
- 13
- 3
0
votes
1 answer
Can I autofill the formulae in new columns of a Table using relative references
I have a table, it has a few columns
It has formulae like this:
And I would like to fill more pairs of columns like this:
Column "A 2" has the same formula as "A 1", but with the reference offset by 2 columns. Or generally "A i" & "B i" refer to…
Greedo
- 4,967
- 2
- 30
- 78
0
votes
1 answer
VBA Compile Error: Syntax Error for Saving Excel in PDF for Excel 2019
I'm getting a "Compile Error: Syntax Error" when running the code below using Excel 2019. It works with the older version Excel, but not on 2019. How can I fix this and what's causing it?
the error line
ReportSheet.ExportAsFixedFormat…
MMMM
- 29
- 1
- 7
0
votes
0 answers
EXCEL [Get Data] from .txt row column is going wrong
Is it possible that the Input Data from our company bio metrics are wrong? because the data that I always getting is not exactly the thing that I am expecting.
Some data are input in the wrong row in excel.
I provided some pictures for you to…
Alfredo Canonizado
- 21
- 1
- 6
0
votes
1 answer
Getting value by incrementing to a specific row in Excel
So I have a long list of raw data in Excel wherein I need a formula to get the values of specific rows and paste them into another column. This is how I want it to happen.
Picture of the Data in my Excel file:
I need the end result to be like…
Abraham
- 11
- 4
0
votes
1 answer
Column width in Excel to PDF
I am trying to convert a Excel document to PDF. The Excel document has 64 pixels width for first 10 columns. I am using the A4 Sheet size for PDF in which the first 10 columns should fit. But, Excel only fits 9 columns. In this document right and…
MOHAN C
- 34
- 4
0
votes
0 answers
How to find parts of words using index match in excel?
So I already have this formula
=IFERROR(INDEX(Table2[Company'#],MATCH("*"&[Store Address 1]&"*",Table2[AddressLine1],0)),"FALSE")
so it works completely fine. But the thing is I was wondering if there is a better formula to read the cells…
Scott P
- 29
- 8
0
votes
0 answers
Having to refresh twice to get one certain column of data
I am running a macro on excel, and for some reason, the "Hours" tab doesn't seem to run if I press my macro once. But if I click my macro twice, it populates. My code is the following
Sub Refresh()
'
' Refresh Macro
'
'
Sheets("P DB").Select
…
Scott P
- 29
- 8
0
votes
1 answer
How do you get leave a cell blank, if there is a string attached before it?
this might be a simple question, but I was just wondering how would you leave a cell blank if there was an error occurring and if there is a string attached in front of it.
So my code goes like:
="FW " &…
Scott P
- 29
- 8
0
votes
1 answer
Microsoft Excel 2019 not responding
I am using MS Office 2019. I have an excel file of 3,776 KB. It takes so much time to open and once it is open it hangs a lot. If I try to select the cell to edit it says "not responding". I have another file of 1126 KB and it is working fine.
I…
Asra Khalid
- 177
- 1
- 18
0
votes
2 answers
Macro takes more time to be executed when activated through button inside sheet in Excel 2019
I have a macro in Excel 2019 which runs in less than one second directly through VBE (by pressing F5), or when I configure a button to the macro in the Ribbon (through options>customize ribbon).
When I create a button (FormControlButton) inside the…
Lucas
- 1
- 4
0
votes
1 answer
SUM two rows in PowerPivot Pivot table MDX Balance Sheet Subtotal for Liabilities + Equity
Really new to MDX and have researched for hours but haven´t found the way to make it work.
Objective: Sum two rows (liabilities-pasivos and equity-patrimonio) for a pivot table that represents a balance sheet.
Background: Data is currently in the…
Ricardo Diaz
- 5,658
- 2
- 19
- 30