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
1
vote
1 answer

Function to find exact word in a column (without other letters) when other similar words exist in cell

I have data that is multiresponse in a cell, separated by ALT+ENTER (or ctrl + j). The three categories that can be in a single cell are "Unreleased", "Released", or "Released for Testing" I want to add a column that's "contained released", meaning…
hanbanan
  • 81
  • 5
1
vote
1 answer

Hide one group while the other is visible vba

I have one group of objects "Group 34" and another group "Group 6". I want one group to be visible while the other is hidden. I thought it would be easier to make two buttons instead of one toggleable one as i didnt know how to so if any of you…
Hamza Ahmed
  • 15
  • 7
1
vote
2 answers

Creating a List of only Whole Numbers

I am trying to create a list of only whole numbers from another list. Suppose my range list is: I want the results to appear as: I want the solution to work in excel 2019 only. Any help would be appreciated, thank you.
MochaLatte
  • 13
  • 2
1
vote
2 answers

Combining cells unless a cell contains certain text

I have an Excel spreadsheet with 7 cells (in a column) with data in, these are C13 to C19 I have a formula that combines all the data in these cells together and puts it into one cell, this formula is =C13&", "&C14&", "&C15&", "&C16&", "&C17&",…
rnmuk
  • 53
  • 5
1
vote
1 answer

Copy Filtered Data in Excel VBA

I have some code which does some editing and then filters. I then copy this data and paste to new sheet. Problem is, the rows can grow each time so i would like to make this dynamic. Can anybody guide me here? Here is my code which is working Sub…
Lalaland
  • 306
  • 1
  • 8
1
vote
4 answers

How to capitalise date month whilst using EDATE formula at the same time

Currently, I am using the EDATE function in cell A5. It is displaying the date as "February". I want this "February" to be displayed as "FEBRUARY". (simple change to upper case) How can I do this whilst keeping the formula currently in cell A5? Cell…
Insider
  • 95
  • 12
1
vote
1 answer

What formula will allow me to complete certain SUMs depending on the data of a different cell?

This is an example spreadsheet of trading wins and losses within a year. I am trying to get cell I6 on sheet MONTHLY STATS - SPREADS to populate a 0 if there have been no L's to count between the dates of 1 Mar 21 and 31 Mar 21 on sheet SPREADS…
Insider
  • 95
  • 12
1
vote
1 answer

How can i calculate a ratio when the #DIV/0! error is present

I am trying to get a formula to compute when 0 is present, and the #DIV/0! error is being problematic. I want cell H4 to calculate a ratio using cells F4 and G4. This works fine when 0 is not present in cell G4 however when 0 is present I get the…
Insider
  • 95
  • 12
1
vote
0 answers

How to COUNT between a date range if nested within another formula?

I am trying to substitute '!!!!!!' for a formula to count the number of W in column P on sheet TRADE LOG between the dates of 01 Feb 2021 and 28 Feb 2021 in hardcoded format. This is the current formula : =IF(COUNTIFS('TRADE…
Insider
  • 95
  • 12
1
vote
0 answers

c++ Excel COM automation: querying server status

I have a problem and I have done several day's worth of research but found no answer. I have a c++ application that controls Excel programmatically. Specifically I use VS2017 and MS Office 2019. To cut a long story short, I don't seem to have away…
jboy
  • 11
  • 4
1
vote
1 answer

How to rearrange cells within a row based on partial string matches in Excel, R

I have a large excel spreadsheet with 8 columns. Simplified it looks like this: Identity column1 column2 column3 column4 column5 column6 column7 1 tk=tr cont=fb sourc=a camp=b med=c nm=he ad=fst 2 camp=a cont=fb …
jawk23
  • 13
  • 4
1
vote
1 answer

Default Behavior of Excel 2019 Opening a Template File

I have an .xltx document on my desktop that I use to upload conversions to Bing. On my old laptop with earlier versions of Office, double clicking the template file created a new worksheet with the data from the template. On my new laptop with…
Brandon
  • 766
  • 4
  • 13
1
vote
0 answers

VBA Excel 2019: msoControlPopup throws error "Object doesn't support this property or method"

I'm trying to use an addin which works fine on PC as well as on Excel 2011 for Mac. When I try to use it with Excel 2019 on mac I get the error message above when trying to add controls. The last line in the following code is causing the…
Mike
  • 40
  • 6
0
votes
0 answers

Embed/Host Excel into WPF application

I am trying to embed an excel workbook into WPF application. I have used the Microsoft.Office.Interop.Excel for achieving this, It works and opens the excel workbook in WPF application. Problem: When I try to run the macros in VBA the workbook gives…
Ganpat Gutte
  • 1
  • 1
0
votes
0 answers

Is there a way to have information automatically exported to various excel workbooks including their respective sheets, from a single master excel

I'm in a position where I have to put various repetitive data points into several excel docs and or specific sheets in a mess of a document. As of current there are upwards of 4 documents that all get the exact same information while some of it may…
Psichotix
  • 1
  • 2
1 2
3
…
12 13