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
Confusing built-in function behavior (SymbolInsert) in Excel
I ran into a strange behavior of a built-in function SymbolInsert. Cell font is Arial. In SymbolInsert I select font Wingdings,then I select and paste the symbol, and get out of SymbolInsert. After moving to the next cell i get the following result.…
iFuraon
- 11
- 2
0
votes
1 answer
How can I check the most recent date and get the right cell information in VBA
I need a macro that check the most recent date on the left in a column and get the information from the cell on the right in VBA.
I can't order by most recent because each column in the same sheet has different date for different purpose. So this is…
David Knight
- 49
- 5
0
votes
1 answer
Is there a way to display a number more than 12 characters whose format is TEXT
I know how to display a number more than 12 characters whose format is Number.
However, I downloaded an excel and when I open the sheet, I saw like "47821E+12" and I changed the format to TEXT but It won't change.
It still shows…
Eric Lee
- 700
- 2
- 9
- 30
0
votes
0 answers
Adding Up Values Based on the name of a Sales Rep Name
Please how do I sum up values based on the name of a sales rep? Below is an example of the table I am trying to perform such operations…
King
- 1
- 2
0
votes
0 answers
Macro to open reports in a specified folder, then open the vba in each report and find and replace a specific text string
I am not quiet sure if this is possible or not, but I am updating from 32 bit to 64 bit excel, and there is a little of a language change between the two. I have many reports that need updating, and going into each file and find and replace would…
Saima
- 1
- 1
0
votes
0 answers
Excel vba to generate a list of files and sizes in subfolders
Hello I have inherited some excel vba code which produces a list of files which are less than 100 days old and captures the file sizes that sit in a specific folder and sub folders. When running the code, it tries to access some sub folders which…
Classre
- 1
- 1
0
votes
1 answer
Excel fetch maximum() from column of values
I have tried all possible formulas I know to fetch maximum value where the available record date = current record date using both the index formula combined with the max function and likewise used vlookup but all to no avail. Below are the…
King
- 1
- 2
0
votes
1 answer
Extract Matching List of Keywords
I have a huge amount of data that has no consistent sentence formatting, and I have a list of keywords I refer to. Whenever a keyword exists in the data, I want to extract them out onto another column. examples of how I want keywords to be…
Bing Shuen
- 23
- 5
0
votes
0 answers
How to identified the smaller number only from specific lines of a table
I am not familiar with excel as you can probaly guess by my question so I am sorry if it's a silly question but I have been googling for a long time and I can't do it.
I manage to do it in excel 365 with the function filter, but I can't on excel…
yellow_melro
- 25
- 5
0
votes
0 answers
How to make a group and only show the smaller number of a cell
I have a spreed sheet called went to. It has name of places and people, as well as a cell that shows how many months ago someone went there.
I am trying to make a list with the name of everyone and the places they went to. But I only want to show…
yellow_melro
- 25
- 5
0
votes
0 answers
how to create a drop down menu in data validation using excel 2019
The course I was learning from taught data analytics using older versions of Excel, so I was missing some information and understanding when I tried to follow along.
I was tought how to create a drop down menu in datavalidation using an earlier…
Lyn Warner
- 1
- 1
0
votes
1 answer
Excel table auto-fills incorrect formula when inserting rows
I have an Excel 2019 Workbook in which I have a sheet with a range of cells defined as a table. Table columns are A to H, where columns A and C contains formulas and the others have to be manually compiled with information by users. The sheet is…
Christian
- 3
- 1
0
votes
2 answers
How to extract numbers with separation in Excel
Does anyone knows any formula to extract the number with separation (dot, comma) from cell A1 to cell B1?
Example, I want to extract 2,590.00 from cell A1 which has the following value:
[sum: 2,590.00]
I got the formula below that works nice,…
David Knight
- 49
- 5
0
votes
0 answers
Reading connection Last Refresh date
When I hover over a Power Query connection in Queries and Connection menu, I can see short preview of data, list of columns, date of last refresh, load state, source of data and quick menu with view/edit and remove buttons.
Is there a way to…
Tomek S
- 27
- 5
0
votes
1 answer
Using Dynamic Ranges in excel
I know my question might have been answered somewhere. However, Either I am not able to find the answer or understand it. Anyways, My question: I am trying to select unique values from different columns and then transpose them to concatenate in a…
Newtocoading
- 1
- 2