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.
Questions tagged [excel-2019]
183 questions
0
votes
1 answer
How to add conditional formatting to the cell in front of the cell which content starts with certain keyword in Excel?
I want to extend the formatting to the next cell (which contains mins) as well.
Here is the formula I'm using:
Both of them are applied to =$A$1:$B$1,$36:$50,$A$2:$C$35,$E$2:$XFD$35,$D$1:$XFD$1
Um9vdAo
- 53
- 2
- 9
0
votes
2 answers
Excel If Condition matches in two column fetch value
I am working on an excel simple query, where I am trying to fetch Name based on
first if the ID matches between two tables columns values
second if the Status column has a value of Pick, then Fetch the value from the Name column. Else Do nothing…
Istiak Mahmood
- 2,330
- 8
- 31
- 73
0
votes
0 answers
Return N/A as value in a MINIFS function when value in a criteria range is N/A
I would like for my formula to return N/A in column G when there is an N/A in column C. The following screenshot provides my current…
VHes
- 15
- 5
0
votes
1 answer
Excel VLOOKUP using 2 colums from a table array
I have the below VLOOKUP formula
=IFERROR(VLOOKUP(@B5:B64,dbVEH!$A$2:$E$296,5,FALSE),"")
I am trying to create a formula that searches 2 columns on the table array. I have the range A$2:$E$296 however it only matches the A column and delivers the…
Exhausted
- 179
- 2
- 5
- 19
0
votes
2 answers
Find adjacent cell values based on 'looked up' cells' original position whilst dealing with duplicate values
I'm currently stuck with an excel problem that I can't seem to find an answer to.
Take the following example dataset:
A B C D E F G
Date Color …
VHes
- 15
- 5
0
votes
1 answer
How to embed creating dropdown lists inside a select case on Excel?
I can't figure out how to create dropdown lists depending on a certain cell value.
I have these two functions but don't know how to merge them.
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("C14")) Is Nothing…
BrokenStrings
- 1
- 2
0
votes
1 answer
How do i split an excel sheet into 3 sheets according to a column (UiPath)?
I have an Excel file that I need to split into multiple .csv files based on the "Name" column, so that each file is like .csv using UiPath. I'm extracting the data to a data table, but I can't split them into different files by "Name".
Nousi
- 1
- 1
0
votes
1 answer
MS Excel 2019 - VBA - Workbook.OpenText not correctly using Origin Value specified
I am trying to open a CSV file produced by ebay, in MS Excel 2019 where it correctly loads the foreign characters within th efile. ie "Harzstraße 25" when imported as a Text - UTF8, but where opening as an default ASCII loads "HarzstraAßE 25"; the…
Steve Crosland
- 33
- 7
0
votes
1 answer
Format numbers as thousands,millions,billions with Zero
i want to use format number with 00K for thousands & 00M for millions & 00B for billions & - for zero
I used the following format
[<999999] #, "K";[<999999999]#,, "M";#,,, "B"
but the problem is in cells that contain zeros it shows K
As you can see…
Milanosap
- 3
- 3
0
votes
1 answer
Same Formulae Different Values in Different File- Problem of round off of decimal
Problem in 1 File, I have divided and later multiplied same result with the denominator and it gives different numberator.
But in another file it is ok:
Bhim Bhandari
- 11
- 2
0
votes
1 answer
Get last value in a column not equal to some value
I have an excel spreadsheet with a column with states where I have ran races. I would like to write a function that returns the last out of state race I ran. How would I do that?
Denis McElligott
- 3
- 2
0
votes
1 answer
How can I Multiply two columns then add them together easily?
I would like to Multiply Column A with Column B. There is data for each column in rows 3-20.
Rather than doing (A3B3)+...(A20B20), is there an easier and more efficient way of doing it?
Josh
- 13
- 3
0
votes
0 answers
How to import a header from a txt file?
I have this data (I pasted it from a text file) https://imgur.com/gallery/cHWLVYD
And I have another text file with the data of the header (with the font size and the type of information). But I don't understand how to put that data as a header ?…
Tita Tita
- 1
- 2
0
votes
0 answers
Excel 2019: Copy data from sheet2 columns B, C, D to sheet1 columns B, C, D based on value of sheet1 column A
I have the following conditions:
I have a Workbook with 2 WorkSheets named Data and Users
In Data, I have column A populated with numbers ranging from 1 to 9999999
In Users, I have column A populated with numbers ranging form 1 to 9999999
In Users,…
Dennis
- 79
- 11
0
votes
0 answers
My VBA code worked in excel 2010 but does not in excel 2019
I have a code (seen below at the bottom of this message) built by someone else and it has worked very well in excel 2010 but our administration migrated us to excel 2019. Now the same code produces errors. I have also tried checking if there were…
msdraino
- 1
- 2