Stack Overflow
Stack Overflow

Questions tagged [excel-2019]

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.

183 questions
2
votes
1 answer

Assign a value to a cell in Excel VBA crashes VBA with no message

I am using Excel 2016 32-bit and Excel 2019 32-bit. In both Excel versions, programmatic assigns halt VBA execution without any message. Trust Center settings are set to Enable all Macros and Trust the access to the VBA Project Model. The…
Doug Kimzey
  • 1,019
  • 2
  • 17
  • 32
2
votes
2 answers

m/PowerQuery: How can I convert a table column into a readable text column?

I'm dealing with a PowerShell audit log, which I have imported from an XML dump. Each row is a PowerShell event, including various fields such as: Attribute:Cmdlet (the name of the command that was executed) Attribute:Caller (the username of the…
Giffyguy
  • 20,378
  • 34
  • 97
  • 168
2
votes
0 answers

Excel 2019 - ADODB connection from VBA stopped working

I have a problem here with the new Office 2019. The Microsoft help pages have absolutely no relevant information about it. Looks like the same connection string that was used in Office 2010 does not work with 2019 anymore. On machine running the…
Slava S.
  • 31
  • 1
  • 6
1
vote
5 answers

Count non zero numbers in excel

I have a string in one cell 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,2,1,0,2,5,4,0,5,4,7,6,7,8,0,8,9,8,8,10,11,0,9,10,9,8,10,9,0,15,18,17,16,17,16,0,17,16,17,16,15,14,0,12,11,10,9,10,9,0,7,8,7,6,5 In this I want to…
silbia
  • 37
  • 4
1
vote
2 answers

Excel 2019 How to set Cell format in Scientific notation to thousands only, E9, E6, -E6, -E12

I'm doing calculations and I would like to keep all the data in scientific notation to the powers of 3 like I do when I'm doing real life calculations, currently I'm getting 7.025E7 instead of 70.25E6. Thanks in advance Formating individual cells,…
Puha Technologies
  • 41
  • 7
1
vote
2 answers

Can this code be streamlined with less "with" "End With" statements>?

I ask as it seems there is a better way than having a separate "With" "EndWith for each Column. On the active sheet For the entire Columns A1:C1 it is setting to autofit plus two blank spaces, and for the entire Columns D1:G1 it is setting to…
user2303407
  • 59
  • 9
1
vote
1 answer

VBA code in excel 2019 freezing for extended periods, resulting in crash

let me preface this by saying I'm very new to VBA coding, and I put together VBA Macro that compares two data sets and looks for matches in a specific column of both tables. The matches aren't on the saw rows, so I had to use loops to search through…
Greg P
  • 11
  • 2
1
vote
1 answer

VBA Webscrape URL from HTML (src="")

I tried to combine code parts i could make work, but it was working with , but it is not working with Can anyone help to make it work? I try to…
hwka
  • 11
  • 2
1
vote
1 answer

Loop Through All Sheets in Workbook, Compare Two Sets of Cells, Copy Another Cell Value

I have a workbook with 50+ sheets. On all but the last of these sheets, A19:L30 is the range I'm concerned with. Within each row in this range, cell Kx is a job code, Lx is a sub-code for the given job, and Jx is the total hours worked in a specific…
ck8177
  • 13
  • 4
1
vote
1 answer

Is there any formula to get the date only?

Is there any formula to copy the date "10/13/2022 12:30:00 AM" but just get the date only? Like: 10/13/2022 Thank you.
David Knight
  • 49
  • 5
1
vote
1 answer

How to calculate average price of open position of stocks Excel Table

I have a simple table with some dummy data to simulate stock trades. I know the its model is not exactly right, but it does comply with the basics and that's what I'm looking for. The answer I'm looking for is how would I calculate the data on…
APJ
  • 51
  • 5
1
vote
2 answers

How best to pull the name of column header into a cell if certain conditions are met across multiple columns?

Basically, I have an excel sheet similar to the below. I want to use the YES cells to create an equation for the source column which indicates the source of the yeses. Header 1 Header 2 Header 3 Source YES NO NO Header 1 NO YES NO Header…
kksweene
  • 9
  • 1
1
vote
2 answers

How do I get the top N results based on wildcard criteria via a formula in Excel 2019?

Since I've exhausted about every resource I could find in regards to this question, I figured it was finally time to ask this community. I have a very large (15k+ row) dataset that I'm looking to generate a report on giving the top 25 largest values…
Aram Howard
  • 11
  • 2
1
vote
2 answers

Function to summarize text in Vba Excel

Now I'm using MS Excel 2019. I desire to make function to get text at Summary Steps column and Sumary Values column from Steps and Values Column It's described as . I tried with this function. However, It doesn't work at all Function…
banana
  • 33
  • 4
1
vote
2 answers

Remove word from string with one or more condition

If match part of word in string, how to remove that entire word? Input: "This is a beautiful text in string." Rule: If in string exist "autif", then delete "beautiful" Result: "This is a text in string."
Losai
  • 329
  • 2
  • 9
1
2
3
…
12 13