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
2 answers
Excel says: "Excel file is not a valid file extension or format type..."
I am using apache.poi to make an excel file, but when I generate it with a simple java code when I'm trying to open with Microsoft Excel, it says that this file cannot be opened because my file format or extension not valid.
I'm using the latest…
Boy Smiley
- 23
- 1
- 6
0
votes
1 answer
Display user control in active workbook
I have a VSTO Excel Add-in project. I have a ribbon called "ManageTaskPaneRibbon" and on the ribbon I have a toggle button called "toggleButton1" which opens a User Control called "TaskPaneControl". When I run the addin and click on the button, the…
TheoMysh
- 1
- 2
0
votes
2 answers
Properly call a cell formular from a macro in excel vba
im trying to work out a little scheduler in excel to manage my life a little better. I use different cell colors for each event (yellow for work, red for university, etc.). I already have a macro CountColor which counts the occurence of a color in a…
Yastanub
- 1,227
- 8
- 19
0
votes
2 answers
How to parse string timestamp into date
I have a text value that looks like this: 2019-03-25T06:05:00-07:00. The general format is yyyy-mm-ddThh:mm:ss-GMT. I don't care about the GMT part. I am trying to use this text field to make time series scatter plots in excel.
I want to convert…
Intrastellar Explorer
- 3,005
- 9
- 52
- 119
0
votes
1 answer
Excel: Text-Based Multi-Lookup Formula
I have a table describing a basic two-way relationship system.
For simplicity, I'll just use animals as an example.
(My actual spreadsheet is needlessly complicated, and wouldn't be helpful.)
I list animals with a unique text name (identifier).
Then…
Giffyguy
- 20,378
- 34
- 97
- 168
0
votes
0 answers
How to use IF or IFNA or OR to get a value from multiple columns?
I have 4 columns in Excel with values
as mentioned in the image. I want to get the output in column E. The output should come from each row with a Not Null value. For eg Row 1 should return 1 as that is the only value from column A and Row 1 which…
sxb1649
- 27
- 1
- 10
0
votes
0 answers
Copy Ranges from one workbook to another workbook
I have a workbook with three sheets. RC,RI,RCB. I need To write VBA code, which will copy ranges from this workbook and will paste to a newly created workbook.
In this code, everything Works except sheet RCB. Debug turns on on line 12
Sub…
giorgi lomidze
- 9
- 8
-1
votes
1 answer
Excel pivot/group/transpose
Data presented like this (3 rows with same key 1,2 etc):
k va vb
1 A11 B11
1 A12 B12
1 A13 B13
2 A21 B21
2 A22 B22
2 A23 B23
...
I need to group and transpose each group so I get (dont need keys even)
va1 vb1 va2 vb2 va3 vb3
A11 B11 A12 B12 A13…
Boppity Bop
- 9,613
- 13
- 72
- 151
-1
votes
1 answer
How to select table cell in the if function in VBA excel?
I have a stock management table in excel sheet. Demo here:
Demo photo of this table
I want to create a code in VBA that comes In stock column and will test the whole cells. If any cell.Value < 2 and >0 then go to 4 cells backward take the value of…
Saiful Islam
- 17
- 2
-1
votes
1 answer
How to take the cumulative sum of data up to a specific date?
I would like to find a formula that takes the cumulative sum up until a specific date specified. Ideally a formula that contains the date function so the user can select which date to have the cumulative sum of. For example:
In this example I chose…
TeelowxD
- 27
- 3
-1
votes
2 answers
How to count appearences along a timeline with criteria
I have a table with 3 columns: expense, client_id, date.
The date has record of clients expense for half a year for each day.
Some clients spend many each day, but some not.
The expendure ranging from zero to few hundreds.
I want to group/count…
paul
- 59
- 5
-1
votes
2 answers
How to display a blank cell using IF formulas?
I am trying to get cell H5 to display blank if cell G5 is also blank
This is the formula I am currently using in H5 :
=IF(COUNT(G5)=0,AVERAGE(F5),SUM(F5/G5)),IF(G5,"","")
This currently returns the #DIV/O! error
If anyone could tweak this that would…
Insider
- 95
- 12
-1
votes
1 answer
VBA Excel , How to extract max value in an specific column and show the max value in Specific sheet
What I am trying to to achieve is the max value in all sheets in my workbook and gather them in an specific sheet
My vba code is working for one specific cell and when I have tried to add for loops Nothing happen and my excel would be not respond…
-1
votes
1 answer
AverageIFS with multiple IF criteria from the same column
I tried looking for solutions here but sadly enough I can't find a similar enough issue related to mine. I have quite a lengthy AVERAGEIFS formula:
=AVERAGEIFS(Hoofdtab!AE2:AE19883;
Hoofdtab!V2:V19883;"="&'Statistics Query'!F4;
…
VHes
- 15
- 5
-1
votes
1 answer
How to freeze a dropdown list cell in Excel depending on another dropdown list cell, and assign a default value to it?
My excel tool allow me to calculate prices.
There is this dropdown list cell that indicates the product, and another dropdown list cell to indicates the city where is should be delivered, but what I would like to do is to freeze country cell(set it…
BrokenStrings
- 1
- 2