# Questions tagged [microsoft-excel-2019]

The microsoft-excel-2019 tag has no usage guidance.

13
questions

**0**

votes

**0**answers

16 views

### Excel 2019 pivot table not working on mac

I am going through the Welcome to Excel Tutorial for Excel 2019 on Mac. Everything worked as explained except for trying to create pivot tables.
I tried creating my own tables to do the same thing ...

**0**

votes

**0**answers

6 views

### Excel 2016 Edit Revision Logging Functionality?

I came across a piece of software that uses git when editing Excel documents, and I thought this was a great idea, but then I remember that most Office Excel users don't really use git.
Is a ...

**0**

votes

**1**answer

47 views

### convert Date to Julian day in Excel

How to calculate the fourth column based on the first three columns in Excel?
Date cell to Julian day
for example:
year month day **Julian day**
2000 1 1 1
2000 1 2 ...

**0**

votes

**1**answer

34 views

### Excel 2019 Corrupting Files - I run Windows 10

I've upgraded to Excel 2019 and run some fairly basic VBA code on files created in Excel 2010. I'm finding Excel 2019 corrupts my files randomly (I save daily versions of similar files where some data ...

**0**

votes

**0**answers

13 views

### How do you create a dynamic table in Excel that gets its data from multiple other tables?

This is a bit of an edge case and I've seen several similar issues but nothing quite like this.
I have 3 tables of data and I'd like to create a master table with various parts of each table. As I ...

**0**

votes

**1**answer

94 views

### Excel says SUMIF formula I try to use to have too few arguments

I am trying to use the SUMIF-formula, but can't seem to work out how it works, and how it want me to input the formula.
The formula template is stated as:
=SUMIF(range criteria [sum_range])
I have ...

**0**

votes

**1**answer

27 views

### Excel Nested IF is not being evaluated as a formula. The output of the cell is the actual Formula itself

So I have a table and in one of the table columns I have the following
=IF(ISNUMBER(SEARCH("JugA",[@[Original Wonderware Tag Name]])),"0",IF(ISNUMBER(SEARCH("JugB",[@[Original Wonderware Tag Name]])),...

**0**

votes

**1**answer

41 views

### Sum must equal 10000

I was wondering if there is a way to make a formula to automatically adjust so that the sum of a column doesn't a certain maximum.
For example: I want to contribute $10,000 to a charity, taking 10% ...

**0**

votes

**0**answers

20 views

### Excel, how to insert rows and auto-sum from other worksheets based on two dates?

I would like to be able to lookup information from worksheet-B (History) and automatically insert N number of rows found from worksheet-B into worksheet-A (Tool). The number of lines inserted need to ...

**1**

vote

**2**answers

348 views

### Excel shortcut to expand / collapse entire group outline level

I'm trying to find out if there's a shortcut key combination in Excel to expand & collapse an entire group outline level. This would be the the equivalent of mouse clicking on the 1, 2, 3, ... ...

**0**

votes

**0**answers

43 views

### Change font in Excel forumula bar

Is it possible to change the font type in Excel's formula bar? I want to use a monospace font to make my formulas easier to read.
I'm using Office 365, Excel version 1904.
Thanks in advance.

**1**

vote

**1**answer

115 views

### Excel Dynamic Arrays - creating multiple dynamic arrays based on another one

I'm trying out the new functionality of Office 365's Insider versions of Microsoft Excel, dynamic arrays, and was trying to make something I've been wanting to do for some time in a simple way.
In ...

**2**

votes

**1**answer

121 views

### Excel number format adds decimal point for whole numbers

I want to be able to see every digit, but without any padded zeros on the right.
So I formatted the cells like this:
#,##0.################################################################
However, ...