Questions tagged [microsoft-excel-2019]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-1 votes
0 answers
21 views

Microsoft Office Professional Plus Excel Spreadsheet data transfer?

I want to begin by saying thank you for taking the time to read this. Okay, I am in charge of creating a series of Excel worksheets for a company. I have an idea on how to make it but I am curious if ...
user avatar
0 votes
1 answer
19 views

Excel count if in sum of ranges

I have a sheet like this: | A | B --+----+--- 1 | 20 | 1 2 | 20 | 2 3 | 40 | 2 I can do =COUNTIF(A1:A3, 40), but how do I count (or any other operation) on the sum of the columns? i.e. I want to ...
user avatar
  • 373
0 votes
0 answers
29 views

Is it possible to automatically match rows in Microsoft Excel?

Let's say, that I have the following table: 1 2 3 A A B B C C C D E Is there any automatic method to match rows in those three columns? Expected result looks like this: 1 2 3 A A B B C C C ...
user avatar
  • 265
0 votes
0 answers
33 views

Running Excel.exe as Administrator is Much Slower than as a User

On Windows 10, I have an autohotkey script that opens an Excel file. If my computer has been running for a while and I have the script run the Excel file as administrator, it takes over 60 seconds to ...
user avatar
  • 916
0 votes
1 answer
20 views

In Excel, how do I join portions from different dynamic arrays into one new dynamic array?

In Excel (but without the use of VB) how do I join some columns from one dynamic array to columns from another such that result is also a dynamic array? Here's a very simple example. Suppose I have ...
user avatar
  • 342
0 votes
1 answer
43 views

Dividing between values in an Excel pivot table

I am attempting to use a pivot table to sort numerical values by month and year (the field 'Close/Last'), and wish run calculations that take the standard deviation of the 'Close/Last' data for each ...
user avatar
0 votes
1 answer
56 views

Return rows ONLY if another column is equal to "Yes" Using dynamic table

So I m trying to return rows of data in a dynamic table Here's a picture below of the data, table name is "Assignments" and I've tried this formula if(Assignments[Shipping]="Yes", ...
user avatar
0 votes
1 answer
87 views

Excel blurry and bold text in ribbon

I have a new computer (Windows 10 Pro N 64bit) and I installed a clean MS Office & Business 2019 (also 64bit). There is a strange problem with Excel: some of the text in the ribbon are bold and ...
user avatar
  • 306
0 votes
0 answers
25 views

How to Increase a number in INDIRECT function

I need to increase the value referred to in $C$1 at the end of the following formula while dragging down: =INDIRECT("data!"&A$3&$C$1) A$3 refers to A, $C$1 refers to 1. And both A$3'...
user avatar
  • 105
0 votes
2 answers
48 views

Excel Index Match with adjustable rows

I am using Excel 2019 and I want to write a formula that will do the following: search for a student name in Sheet1 (named classes) and for every class he/she took, update from Sheet2 (named Archive) ...
user avatar
0 votes
2 answers
73 views

Creating multiple values from single value + monthly increment

looking for any advice/ tips that could help with the creation of this dummy data set From this table, want to create another table ID MOB date(dd-mm-yyyy) A01 2 01-07-2019 A02 3 01-02-2019 This ...
user avatar
  • 1
0 votes
2 answers
36 views

Append string to an Excel-cell, but ignore appended value when referenced in calculations?

I am wondering if there is a way to append a cell with a string value (for better/readable presentation), but ignore this appended value in formulas when referenced? For example, lets say A4 has the ...
user avatar
  • 323
0 votes
1 answer
350 views

How to sum a column based on existance of value in another column

I have the following sheet: I want a sum of individual spending by Frank, John and Nancy in the yellow cells. Each person's spending is denoted by an x. I tried the SUMIF formula, but I don't know ...
user avatar
  • 17.4k
1 vote
0 answers
265 views

Excel 2019 default encoding for csv files

Problem I'm using Excel 2019 and I have this .csv file(Multiple language) which is in UTF-8 encoding and when I try to open the file, Excel opens it in ASCII encoding — the english characters and ...
user avatar
0 votes
1 answer
33 views

Excel: Take on the value of a formula cell when other cell is equal to x?

I know that title isn’t great but essentially: Let’s say A1 = some number And A2 = some formula involving A1 I want to store values of A2 in a column for different values of A1 so like a function ...
user avatar
1 vote
0 answers
95 views

Excel color is abnormal

The Excel setting is Dark Gray, and it turns out to be super black inexplicably when opened today, and there are some dotted lines in the table. I checked online and there are several methods, but ...
user avatar
3 votes
1 answer
182 views

Datalabels are missing in dynamic chart

I am trying to create a dynamic chart but the data labels are missing. I add the data labels manually to all headers and then save and close the file. When I open the file and select a different ...
user avatar
  • 53
0 votes
1 answer
77 views

How do I pull data from another tab/worksheet based on a column value in Excel 2019?

I am trying to create separate sheets on the same workbook that automatically update for all our sales based on one column value which is Column D. We get data from a master sheet in the same workbook ...
user avatar
0 votes
1 answer
74 views

Issue on Excel number formatting

I'm trying to type a number eg: 65, and when i press enter it shows as 0.065. Even I have tried the basic settings still it shows like this. How can i fix this?
user avatar
0 votes
1 answer
73 views

How to find last digit IF next column has a condition?

In Tab 1 I have 2 columns, B with the material numbers of 11 digit, and C with the commentary. In Tab 2 I have one column (E) with the 10 material number digits. In column F I have to find the last ...
user avatar
  • 5
3 votes
1 answer
281 views

How can I fill a shape in Radar Chart?

I'm struggling to find a way to just fill one shape in a radar chart. An example of what I would like to have is in the image. I tried to start from a simple radar chart and then filling the shape --&...
user avatar
1 vote
1 answer
468 views

Alternative for a filter formula

I used a filter formula to find all data from another sheet and column, that start with "US". In the column, I have about 5000 rows that have different data with different markets. And the ...
user avatar
  • 5
0 votes
0 answers
9 views

I want to enter date in one cell, and each time I enter, have it populate down a list in a different sheet

Assume cell A1 in Sheet 1 is where I enter time. I want to keep on entering new time values in only A1 and have it populate down a column list of all such values in Sheet 2. What formula setup would I ...
user avatar
0 votes
1 answer
69 views

Why there is dotted line in Excel?

The line between D and E is dotted. Why? How can I change it to normal (eg. the line between E and F)? I am using Excel 2019.
user avatar
  • 117
0 votes
0 answers
59 views

Excel copying data from workbook to another workbook date format remains same but in VBA

Daily, I have to copy a master file in my workfile. Master file comes in .csv, normally i just copy & paste into new sheet. Now I want use vba code mentioned below, code works, but dateformat ...
user avatar
1 vote
0 answers
164 views

Microsoft Excel: how to disable the "two click" requirement when Excel window doesn't have focus?

In Microsoft Excel, all versions as far as I can tell (office 2007 to 2019), implement window focus differently than any other Windows apps: When Excel does not have focus (i.e. you're using another ...
user avatar
0 votes
1 answer
844 views

Excel formula. Find partial text in column and return cell value from row

This seems like simple concept at least to my limited excel knowledge, but I'm unable to find a formula that does the following. I have two columns of text, column A & column B. I want to search ...
user avatar
2 votes
1 answer
151 views

How to identify what a shortcut key is triggering in an Excel workbook?

I've inherited a workbook and a personal macro workbook that operate in conjunction with each other (drawing on a CSV and 2 LST files) to produce a report. The spreadsheet has rudimentary instructions,...
user avatar
  • 211
0 votes
2 answers
811 views

Excel highlight cell (text) that equals one of multiple other cells

I want to format cells $C$2:$C$32 if their value (text) is equal to not one other specific cell but one out of multiple cells, let's say $C$35:$C$42. Additionally blank cells should remain untouched. ...
user avatar
  • 1
1 vote
1 answer
54 views

Excel bar graph with error bar

At this point I feel kind of stupid for asking, because I should probably be able to do this. I want to create a graph like seen on the first image below, with each task having its own label on the x-...
user avatar
1 vote
2 answers
42 views

How do I get the first row and column to stay visible in Microsoft Excel

When I downloaded the fatalencounters.org data (found here: "download database" ) in a .xslx file. I have Microsoft Office 19 I believe. I noticed in this spreadsheet the first row and ...
user avatar
  • 131
0 votes
1 answer
63 views

I get the "You've entered too many arguments for this function” on excel

I have a table where the user adds a chemical formula by adding elements one by one (the table has 5 rows) and i'm trying to calculate the degree of unsaturation in two ways. The user has to specify ...
user avatar
  • 1
0 votes
4 answers
286 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" ...
user avatar
  • 27
0 votes
1 answer
107 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 ...
user avatar
-1 votes
1 answer
61 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 ...
user avatar
0 votes
1 answer
27 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 ...
user avatar
0 votes
1 answer
282 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-...
user avatar
-1 votes
1 answer
96 views

Why the results are not the same? (matrices)

Last image is the question and the official result
user avatar
  • 11
1 vote
0 answers
54 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 ...
user avatar
5 votes
2 answers
768 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 ...
user avatar
  • 5,174
0 votes
4 answers
85 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 | | ...
user avatar
  • 5
1 vote
1 answer
183 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 ...
user avatar
0 votes
1 answer
76 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 --------...
user avatar
  • 5
1 vote
2 answers
2k 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,...
user avatar
0 votes
1 answer
91 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 ...
user avatar
2 votes
1 answer
91 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. ...
user avatar
  • 55
1 vote
1 answer
338 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://...
user avatar
  • 2,361
0 votes
1 answer
22 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 ...
user avatar
  • 3
0 votes
0 answers
63 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 ...
user avatar
  • 241
0 votes
1 answer
280 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 ...
user avatar