Questions tagged [microsoft-excel-2019]
The microsoft-excel-2019 tag has no usage guidance.
75
questions
1
vote
1
answer
50
views
Nested If's with Vlookups not working in Excel
I have an MS Excel 365 (with current patches) spreadsheet that tracks mileage and tolls to various locations. I am trying to build in logic that won't populate mileage and tolls if I have 2 entries ...
0
votes
1
answer
105
views
How to TEXTJOIN specific no of rows based on constraints?
I need to concatenate certain attribute value based on the sequence number for specific material number and a formula to automate the process. I have columns as listed in the below screen shot and I ...
0
votes
1
answer
63
views
How to get an exact match with VLOOKUP into the current cell
The name "Dodson" is on A5, the lookup is from B5, the table A16:B19, the value in the second column of the table, but am looking for the precise result of a VLOOKUP.
The formula I have is:
=...
0
votes
1
answer
33
views
Where is the Sparkline tab in the Show group for Excel?
How would I display the high points?
screenshot
Copilot says:
You Apply Blue sparkline color and display the high points for the
sparklines.
Copilot Certainly! Let’s create sparklines in Excel, apply ...
1
vote
1
answer
120
views
Disable truncation of labels of treegraph in excel
I'm creating a treegraph in Microsoft Excel, but my labels get truncated unnecessarily. See the image below:
As you can see, the second digit of the labels of the smallest rectangles, which are the ...
0
votes
0
answers
65
views
How to turn off the automatic alignment to cell borders in microsoft excel?
In microsoft excel, the page border always automatically stick to the border of cells.
I don't know how to exactly phrase this phenomena. We know that the area in which we are able to view the data ...
0
votes
2
answers
921
views
How to use the Offset() function when referencing the cell's tab/cell address
I am trying to use the Offset() function to return the value of a neighouring cell. Starting on the "Order" tab I would like to enter a cell reference ("source") to a "Ticker&...
1
vote
2
answers
46
views
Lookup data corresponding to the same time for each date
I have a sheet with two columns, column A is the date and time and column B is the data:
A B
|------------------------|----|
1 | 7/21/2023 12:00:00 AM | 5 |
|-------------------...
0
votes
1
answer
57
views
How do I repeat a function that has different size inputs?
Is there a single function that can multiply cell A1 by B1:B24 and put the results in C1:C24, then A2 by B1:B24 and put the results in C25:C48, then A3 by B1:B24 and put the results in C49:C72, etc... ...
0
votes
1
answer
29
views
Excel 2019 Transpose: Transposing multiple columns Excel
I have an excel sheet with three columns: Country, Year and Fuel consumption per capita.
Dataset:
The country column has data for all worldwide countries. The year range for each country is from 1965 ...
0
votes
1
answer
329
views
VLOOKUP Name Error even after using formula wizard
I'm having a really hard time trying to figure what is wrong in by VLOOKUP formula. I even used the formula wizard to try to fix it.
Here is the formula I'm using.
=VLOOKUP(A10,Melaminedetails,2,FALSE)...
0
votes
3
answers
3k
views
Using Excel formulas to create multiple rows of data from one row
I am looking for a formula that takes the name and quantity of a table and itemizes it so the quantity amount matches the amount of rows the name appears.
An example being taking this table as input:
...
-1
votes
1
answer
158
views
Import Data from Text File into Excel 2019
When attempting to convert from TXT to Excel as below inside Excel I can't get desired output. I have tried it with different delimiter but no luck.
I want to put the text in separate columns in ...
0
votes
1
answer
54
views
Combining two Excel Formulas into one
I have two formulas that work correctly by themselves and am not sure how to combine them into one formula.
1st formula:
=COUNTIFS('FFRCA - FMLA Archive'!D8:D2500,">=1/1/2020",'FFRCA - ...
1
vote
2
answers
429
views
Excel importing: converting text file with many new lines into single cells instead of multiple
I have a lot of data in a text file and I'm trying to figure out the fastest way to convert what are individual lines in the text file to a single cell entry.
Each Person has a number of entries that ...