# Questions tagged [microsoft-excel-2019]

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

34
questions

**0**

votes

**4**answers

50 views

### How do I number Excel rows with a prefix?

I need the following text displayed in column A, as follows. It just needs to be plain text.
Cell A1: "R1" {without quoutes}
Cell A2: "R2" {without quoutes}
Cell A3: "R3" ...

**0**

votes

**1**answer

42 views

### Font substitution in Excel

I have an Excel file with cells formatted with Trade Gothic LT Std font, and my computer has Trade Gothic LT Pro installed, which I believe is basically the same. It seems Excel is substituting the ...

**-1**

votes

**1**answer

56 views

### How to combine table 2 sheets (ข้อมูลตัวอย่าง1 and ข้อมูลตัวอย่าง2) to new table 1 sheet (Use VLOOKUP formula with multiple condition)?

I have data in Excel file to combine table 2 sheets (Have data with web : https://www.contextures.com/xlSampleData01.html)
How to combine table 2 sheets (ข้อมูลตัวอย่าง1 and ข้อมูลตัวอย่าง2) to new ...

**0**

votes

**0**answers

14 views

### color coding based on conditional formatting countifs and coloring

I am trying to work on an excel. It has detail of fuel consumption of vehicles.
So I have marked three categories for vehicles casanova,orbit,gokia,
The excel looks some thing like this ( I dont have ...

**0**

votes

**1**answer

16 views

### what is the mistake in usage of countifs in excel

I am trying to count number of objects category orbit and criteria > 10 here is my excel sheet
https://drive.google.com/file/d/17_aKgd5__R3o4mUMy2sJAuIwpk42aEol/view?usp=sharing
I used following ...

**0**

votes

**1**answer

249 views

### How to control percent in Forecast Sheet no more over 100%?

How to control percent in Forecast Sheet no more over 100% ?
I learn to make Forecast Sheet with percent value with link : https://support.microsoft.com/en-us/office/create-a-forecast-in-excel-for-...

**-1**

votes

**1**answer

93 views

**0**

votes

**0**answers

27 views

### How to sort letter-number-letter value in excel

I have values completely dispersed with a prefix, a number (up to 3 digits) and a suffix. I want a simple sorting scheme that would let me order them in ascending order with suffix taking priority ...

**1**

vote

**0**answers

21 views

### Deleting table rows in Excel VBA by cell value - doesn't delete all rows, why?

I created this macro in Excel 2016, and the problem persists in Excel 2019.
My spreadsheet has a macro to delete all rows in which a cell in a specific column contains the word 'Closed'. The macro ...

**5**

votes

**2**answers

426 views

### Excel - Live filter of list based on another column?

In Excel, I'm looking to get a breakdown of the values in one column (IDs) by the values in another (status).
Input
| ID | Status |
|----|----------|
| 1 | Complete |
| 2 | Active |
| 3 | New ...

**0**

votes

**0**answers

5 views

### MS Excel 2019 - Automatically Expand Line Graph as Data is Entered

I see that this question has been answered, to a point but I wasn't really satisfied with the answer.
I have a worksheet with three columns: Data, Total Cases and New Cases. This is for local COVID-...

**0**

votes

**4**answers

62 views

### Sum cells on the basis of other cells

I have, for example, the following Excel file:
| USER ID | SCORE | TOTAL SCORE | TOTAL BONUS | NOTE |
| ------- | ----- | ----------- | ----------- | ----- |
| 18 | 10 | | ...

**1**

vote

**1**answer

143 views

### Getting a “Parent” Start Date From the Earliest Date in a Range of “Child” Start Dates Based on the Parent WBS Number

Background
I used Formula 1 to automate the assignment of work
breakdown structure (WBS) numbers (D15). The assignment of WBS
numbers (1, 1.1, 1.1.1, 1.1.1.1, etc.) is based on the WBS Level
selected ...

**0**

votes

**1**answer

49 views

### Complete Excel sheet with data from CSV

I have this .xls file:
| ID | SKU | Description | etc
---------------------------------
| | prod_A | Lorem ip... | etc
---------------------------------
| | prod_B | Lorem ip... | etc
--------...

**0**

votes

**0**answers

70 views

### Excel recovered file disappeared

After a Windows crash I opened an Excel file I was working on before. It opened and also showed a pane for the found recovered files.
As I was not sure what version to keep, I decided to first backup ...

**1**

vote

**2**answers

115 views

### Excel Mac - create graphs with two columns with values for x- and y-axis

In my Excel-file, I have four columns with information that I want to graph:
Sample data
I want to graph this information as follows: the values of t, time, should be the x-axis and the values for A,...

**0**

votes

**1**answer

42 views

### Excel 2019 - Conditional Formatting specific cells based on their values as well as value in another cell

I have a table like this
|Physics| |Chemistry| |Math| |English| |Fail/Pass|
50 30 60 25 F
60 25 50 70 P
I want to highlight those cells ...

**0**

votes

**0**answers

38 views

### Finding the correct Inputs for Data Table in Excel

I am tasked to,
"Enter the Data Table covering columns F and G: F calculates the rank of the person hired for each hiring experiment and G calculates the number of interviews after the "pre" ...

**2**

votes

**1**answer

85 views

### Calculating totals with hidden cells in Excel

I have a problem with my Excel sheet.
"Kolom4" has the product codes. Each code has two rows with data. With each code I want to have the combined values of "kolom11" till "kolom14" from both rows.
...

**0**

votes

**0**answers

117 views

### Can't Autofilter Over Pivot Tables in Excel 2019

I have a file with a pivot table created in Excel 2016 (rows 5–7 in the image).
Above the pivot table there is a row of column headers (row 2 in the image). This row is -not- part of the pivot table.
...

**1**

vote

**1**answer

147 views

### Geography, Stocks - Excel's rich data types / linked data types

In Excel 365 (the full online version), I see there is such functionality:
Now, I find articles implying that such feature exists in Excel's Desktop version (at least Excel 2019) too:
https://...

**0**

votes

**1**answer

16 views

### Excel 2nd axis categorical data

I need a 2-axis Excel chart. Primary axis is US Deficit by year - this would be a bar chart w/ both positive and negative value ranges in time series from 1940-2019. 2nd axis would be a binary ...

**0**

votes

**0**answers

26 views

### Excel restarts with a lag, idle Excel process running for 10 seconds

I am experiencing slowdown in in closing&opening Excel 2019. After I close one workbook, Excel keeps running for another few seconds, until it let's me open this or another book. No difference if ...

**0**

votes

**1**answer

131 views

### Is it possible to have two Y axes and two X axes on the same chart for one variable?

How can I draw the correlation for calculating Y and R squared as scatter graph in Excel 2019 for one variable, calculated with four models?
I want two models in two x-axis' and the other two in two ...

**0**

votes

**1**answer

112 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

113 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

25 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

548 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

29 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

79 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% ...

**2**

votes

**2**answers

5k 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

290 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

258 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

686 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, ...