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
0
votes
1 answer

Excel small function with 2 dim table

I'm trying to write a formula that will calculate 5 earlies dates from the list I have. The list will grow - number of rows will be bigger, but number of columns will be max 12. Those dates are tied with some events, so they have to be in 2…
krzyche
  • 1
0
votes
1 answer

Power Pivot - Get previous Year sum

I have a table with these headers: DeptName - ActualFees - Month - Year I want to see in a chat the Deptname and the amount, according to a slicer to select the year, plus the previous year. I have tried a few codes but none worked. The Year column…
Atila D. Grings
  • 11
  • 3
0
votes
2 answers

Ask for VBA code for counting days between two dates and activate mandatory input if result as “less than 4”?

I am a fresher in VBA and want to do a VBA as below conditions, could anyone help me? Please…… Cell J2 us set to be today() Cell J4 can be set another date by user Cell L4 set a formula =NETWORKDAY(J2-J4)-1, to calculate the exact days between 2…
Joffee
  • 5
  • 3
0
votes
0 answers

My EXCEL filtering macro has stopped working

I've used a macro on MSExcel for some months now, but, for some reason, it has stopped working. Its supposed to check if the index already exists in one table, filter it and list the "new entries", but it has started outputting duplicates. I've…
roalfa
  • 1
0
votes
1 answer

Distinct count in pivot adds 'empty' to pivot

I was happy to find out there is an option for a distinct count in pivottables. I used it, but found out something happened which I cannot explain: When I use the normal count command, I get a nice, decent table containing all the values in the (in…
DutchArjo
  • 319
  • 3
  • 8
  • 29
0
votes
0 answers

How to get global positivity rate of medical samples that each have multiple tests

I have a database for results of respiratory virus tests. Each test checks for multiple virus (7) and can be done on different sample specimens. So, for each sample (ie each patient tested), the database has 8 rows: one that contains the sample…
panconkeso
  • 1
  • 1
0
votes
1 answer

Script used to work in Excel 2013 but now fails in Excel 2019 with "Runtime error 91: Object variable ... not set"

I've got an Excel VBA script to reformat and sort data I import from a CSV file. The script was developed with Excel 2013, and it used to work fine. I updated Office 2013 to 2019, and the script fails with runteim error 91 "Object variable or…
phunsoft
  • 2,674
  • 1
  • 11
  • 22
0
votes
1 answer

Use VBA to direct cell contents from Excel into PowerPoint presentation

I am using VBA code in Excel to create a slide in PowerPoint for each row of the spreadsheet. The following code works correctly in opening a new presentation and creating a new slide for each row as highlighted in my spreadsheet. It places the 1st…
Pᴀᴜʟsᴛᴇʀ2
  • 133
  • 1
  • 3
  • 8
0
votes
0 answers

Attaching the active workbook to e-mail

Trying to get this macro to attach the active workbook to email sent through outlook. I can get the e-mail send (it is also sending a clip from one of the sheets as the body of the e-mail. The email sends, but will not attach the file. Sub…
JLGAZ
  • 15
  • 3
0
votes
0 answers

VBA Filter PivotTable Based on Range of Cells

I'm attempting to write a VBA code to filter my pivot table based on the Start and End Time a user enters into a cell. My goal is for users to enter Start Time in "T6" and End Time in "U6" - When they click submit, then it would filter the table…
QRLess
  • 23
  • 5
0
votes
0 answers

IF ... ROW always returns the same number

I'm trying to reach a famous goal: I want to filter a list based on a value and return all items in another column. I have seen lots of pages suggesting a formula part of which is something like this: =IF($C$4:$C$34=$I$4,ROW($C$4:$C$34)-3,"") My…
Mohammad
  • 1
  • 1
0
votes
1 answer

IF formula excel-2019

IF(Database!L2="male, female",Database!N2,"") Salam to every one, The above formula can't working properly, I want ot get data from one sheet to other sheet( if L2 column equal to male or female get data from N2 column otherwise cell must…
Javid
  • 3
  • 4
0
votes
0 answers

Running Total using Pivot Table

I want to add a RunningTotal column to my data using Pivot table, i've the following data: id Customer item SalesAmount 1 Global inc apple 50 2 Americana banana 10 3 Americana apple 100 4 Americana apple 60 5 Global…
technotux
  • 181
  • 1
  • 2
0
votes
0 answers

Why is the object type```TextStream``` set to nothing?

When the program runs, it goes through function Initialize without issues. When function WriteString is called, log's value has changed to "Nothing". On the Retry, when Call Initialize runs, Set log = FSO.OpenTextFile(sLogPath & sLogName, 2, 0)…
BMStacks
  • 56
  • 7
0
votes
0 answers

Edit Date and number in excel

i was new about edit format excel data. i have problem with remove time(HH:MM:SS sss.ss) from my date data, and edit my value data to decimal format i was planning make date > 15/05/2017 and waktu_eod_per_menit > 13,58 There a lot data for me to…
Toshi Mario
  • 3
  • 2
1 2 3
…
12 13