Questions tagged [microsoft-excel-365]
Use this tag for questions specifically about the 365 version of Microsoft Excel; otherwise use [microsoft-excel].
169
questions
1
vote
0
answers
2
views
How can I generate a multi column sorted list in Excel based on data pasted into another sheet?
Okay, so I can't unfortunately go into too much detail due to the sensitive nature of the data, but the short of it is that I've got a table I paste into "Source" that I'd like to have two ...
- 111
-2
votes
1
answer
21
views
Formula helps to extract value
0
Please need a formula to get the NUMBER after the "SV in the description. In the 1st row, want to extract the 1 and in the 3rd, row want the @1 AND Fourth row want the 10.
CONSTENT.1 SN.1 AMMI ...
0
votes
1
answer
42
views
How to condense data irregularly distributed over several rows in an Excel table
Actual Table: Data irregularly distributed over several rows and thus partially empty lines
Date
Text
Date_1
Text_1A
Text_1B
Date_3
Text_3A
Text_3B
Text_3C
Date_6
Text_6A
Text_6B
Date_8
...
- 3
0
votes
1
answer
45
views
All COM add-ins hidden after closing last Excel Window
Following an update of Office 365 in March or April 2022, my COM Add-ins for Excel started to disappear:
Restart your computer, run Excel and choose new blank workbook: all COM add-ins show as ...
- 101
0
votes
1
answer
15
views
excel 365 macro that previously worked fine is now saving tabs as CSV with 9999 rows even if the rows are empty, why would it do that?
update: I also just tried to do a plain old 'save as' on my tab manually and that also results in the comma rows appearing up to 9999.
When the spreadsheet is open I see no data in the rows that end ...
0
votes
1
answer
23
views
When referencing an array of dates and times in a formula when using Excel I sometimes get unexpected outputs
I ran into some unexpected behavior when handling cells with dates and times in the form of "YYYY-MM-DD hh:mm" and as you can see in the second image the formula "=A2:A5" only ...
- 1
0
votes
0
answers
30
views
How to connect Excel to Redshift?
Thank you in advance for any help you can provide!
We are attempting to connect Microsoft Excel for Mac to AWS Redshift, but we're not sure how to go about it or if it's even possible. It would be ...
1
vote
1
answer
35
views
Excel 365. Splitting Cell into multiple rows whilst copying neighboring rows
Not sure if there is a way to do this but here goes.
I have a table with Columns named Vuln, Vuln type, Devices, Comments.
Each Devices cell has multiple values in it separated by a comma. I would ...
0
votes
0
answers
24
views
Cells referenced in formula not displaying by default
Trying to have cells to auto highlight for formulas. All the other posted fixes do not work. I am wanting it to act like it did in Office 2003. I'm using Microsoft 365, Excel. My example using ...
- 1
0
votes
1
answer
20
views
Create a Table that Filters Data and Sorts Unique Values
I am trying to generate a list of unique values in excel based on a unique list of items.
Basically, I need to create a list that Sorts and Assigns a Part Name Based on Width and Length. Then counts ...
0
votes
1
answer
47
views
Link to a specific Microsoft 365 Excel sheet
Can I construct a link from a website to a specific sheet (called Admin) or a named range (called Status) in a workbook originally created by Microsoft 365 Forms in my account?
I have a share link ...
0
votes
1
answer
52
views
How to edit legends of a chart from cell range
I have a list of legends and plot data in separate file. When I plot the data it creates legends as series1, series2, and so on. Now I want to replace the legends from cell list in other file. I can ...
- 103
0
votes
1
answer
30
views
Sum a range of cells in Excel according to a range (criteria)
cordial greetings
I am trying to obtain the sum of the number of males taking into account an age range that I set previously.
For example, I want to know how many males, between the ages of 3 and 12,...
1
vote
3
answers
52
views
How do I create this kind of step chart in Excel?
I'm trying to make a chart like the image below. Essentially, two companies are splitting a share of profits, but the actual share they're splitting is different depending on a specific threshold. I'm ...
- 745
1
vote
1
answer
52
views
updating with modified date, not todays date
Im a total novice at VBA code, but from my googling it looks as if I’ll need VBA for what I’m looking for. I have a sheet where there is a “notes” cell, and a separate cell which contains the date of ...
- 11
0
votes
0
answers
24
views
Count of previous week values when data filtered by slicer
My report so far
I have a data table in Excel as below.
I've imported it into Power BI using this:
let
Source = Excel.Workbook(File.Contents("C:\Documents\Test Data.xlsx"), null, true),
...
0
votes
1
answer
400
views
Excel 365 - Workaround for greyed out calculated fields when creating pivot table from data model
I’m creating an interactive dashboard containing pivot charts for different product sales at my work. The dashboard also contains a slicer that controls ALL charts in the dashboard since all are ...
- 11
0
votes
2
answers
35
views
Excel wildcards not finding the matches they should in VLOOKUP function
I have multiple product families I'm working with, and each family has multiple products within. Some families have more products than others, all product names are unique. On one sheet named "...
2
votes
2
answers
125
views
Excel MEDIAN across ARRAY with multiple conditionals using IF and AND functions
I want to determine a MEDIAN of values in one column based on meeting conditions in two other columns. I'm using MS Excel.
I know I have to process the MEDIAN function as an ARRAY (ctrl + shft + enter)...
0
votes
0
answers
18
views
Excel previously changed text to dates. How do I get it back to what I originally typed?
I have a large Excel (xlsx) spreadsheet full of various types of data. I had initially downloaded this data from Google Sheets. At some point (I'm not sure when), one of my columns of data that had ...
0
votes
1
answer
59
views
Extracting all matching (or close to) values between given START n-th and END n-th values / using Power Query
Consider having two tables. Table1(T1) has Date/Time and Pressure value columns and Table2(T2) has also Date/Time and Info values columns.
T1 is showing pressure change through time, for instance: 21....
- 121
0
votes
1
answer
38
views
Excel - How to reference a cell, within a formula, located immediatley to the right of a value returned by a MIN Function
New to the community. I am attempting to use within a formula, a value within one of two possible cells that are located immediately to the right of two cells, the contents of one of which will be ...
0
votes
0
answers
49
views
How to hide certain columns when another cell shows a specific text
This is what I want to happen:
If Cell F6 is blank does nothing.
If Cell F6 the Cell has specific text saying 'A' only then I want full columns N, O, Q, T and U to be hidden, the whole columns hidden.
...
- 1
0
votes
2
answers
101
views
Converting TXT to CSV with a complex custom delimiter
I am trying to convert following text file into csv by using Text Import Wizard of Data Excel 365. File seems to have come from a source that is using 1252: Western European (Windows) encoding.
By ...
- 125
0
votes
0
answers
36
views
In excel, how to select every column of a table with a specific header
I would like to select only a repetitive set of column from a structured table to apply data validation or conditional formatting.
I tried to create named range with a formula but without success. ...
0
votes
1
answer
48
views
Is there a way to manipulate multiple data values in one cell without splitting the values apart?
I have multiple "Mixes" that I want to create a cost for. Currently each mix is shown in component form in a cell for clarity, the number of units is in a separate column within the table ...
1
vote
0
answers
29
views
How can I stop the date format changing?
I am using a simple form to enter dates in certain cells (Start_date and End_Date). The date format in the form is set to dd/mm/yyyy which works fine. However, when the VBA code copies it to the sheet ...
- 11
1
vote
1
answer
25
views
Unexpected behavior when using named cell in IF condition
I noticed something strange when using named cells in an IF condition in Excel 365 and I would like to know what's going on.
Let's say I have a named cell MyValue, whose value = 15.
Then, the ...
- 111
1
vote
1
answer
103
views
EXCEL - How do I consolidate rows with duplicate information in one column but combine data in the other columns
Click to see example data
I have a spreadsheet of incoming products and the shipping containers they are arriving on. I want to combine rows with duplicate items while preserving the quantities of ...
0
votes
0
answers
23
views
Dynamic filter one column of data into array of rows where adjacent column matches column headers
I have spreadsheets exported from PDF documents containing consecutive tables of data separated by rows of irrelevant text. Where the range contains relevant data, column A contains the headers column ...
0
votes
0
answers
14
views
How to share OneDrive from one account to others 365 account and allow real time collaboration
I have a set of three Office365 accounts:
A - account that holds only OneDrive 1TB
B - standard Office365 assigned to a coworker
C - standard Office365 assigned to another coworker
Before:
Only A ...
- 101
0
votes
1
answer
31
views
Automated Table Of Contents - Adding Details from Last row of related page
Good Day,
Does anyone have recommendations on how to reference a cell with the worksheet name in it and add it to a formula that determines the last row with data in it on that worksheet.
I've used ...
- 580
0
votes
1
answer
44
views
automatically mirror =NOW value from one cell to another
I am using an excel file to upload data to a database. During the import specific cell values are entered to the database.
At a point during the import process the database looks for cell B31. If B31 ...
-1
votes
3
answers
95
views
order two columns off another two columns
I would like to order two columns off another two columns.
Consider the image:
I would like to order column C and D based off column J and K. For example, the order should go something like John Brew,...
- 3
1
vote
1
answer
57
views
Excel keeps saying it repaired my file, but nothing's wrong
Every time I open one of my Excel files it shows a sidebar to the left saying it has recreated it ("Återskapa dokument" in Swedish) and says I should save the one I want.
The file is opened ...
- 449
0
votes
1
answer
57
views
How to multiply every combination of elements of two vectors and output in a third vector?
I need a function or combination of functions which would be able to perform the following operation:
Given two vectors containing booleans (might be integers as well):
V1 = {0;1}
V2 = {1;0;1}
I want ...
- 3
0
votes
3
answers
76
views
How to increment a cell reference by one inside a hyperlink equation to apply to a whole column?
So I have a column in (Sheet1) that I want to lead to the same cell number in another sheet (Sheet2) when I click each cell.
When I tried to use the hyperlink function, I typed the first equation as ...
0
votes
1
answer
122
views
Pivot table column name and horizontal bar in Pivot Chart
My pivot table has a problem.
As you can see,
the first column has a heading of "Row Labels" (in cell A10).
I want it to say "Months".
Also, I'd like to have a horizontal line ...
2
votes
1
answer
548
views
How to import CSV using single quotes in Excel for Microsoft 365
My company recently upgraded from Excel 2016 to Microsoft 365. Before the change, when importing from Text/CSV the wizard would have an option for the delimiter and the quote character. Now, there is ...
- 125
1
vote
1
answer
41
views
Using one table to update another in Excel?
Let's say I have a table with two columns. The first column is a list of email addresses. The second column is a list of dates--let's say appointments. Each month I receive a table with updates, which ...
- 11
0
votes
2
answers
67
views
Is there a formula to count dates as the approach?
I created a sheet to track projects that my team is working on. it contains it has a few columns which are conditionally formatted. One of those columns is for the date equipment needs to ship out to ...
0
votes
0
answers
9
views
Pivot Table Calculation
I have created a field on my pivot table to calculate the duration between my start date and end date columns using the Fields, Items and Sets button.
I now want to do some analysis on the calculated ...
- 1
0
votes
2
answers
339
views
Formula to extract only unique values from horizontal range into a single cell, separated by comma
I have a spreadsheet where users are asked to place a value in their allocated column across many rows.
There are a range of other columns used by an Admin area and one of these is supposed to list ...
- 1,195
0
votes
0
answers
98
views
Excel Online - automatic refresh issues
I'm having issues trying to automatically refresh a workbook using Excel online. I've searched through here and online but I'm struggling to find an answer (or the exact terms to search).
I have 3 ...
- 1
0
votes
2
answers
55
views
Excel 365: Array formula based on value above (compounding)
I am trying to perform an operation in a cell based on the value of the cell above it. Doing this in the "normal" Excel way is easy enough. However, I am playing with the array functionality ...
- 239
0
votes
1
answer
87
views
Confusion with data validation (list)
Hello cordial greetings
I am a bit confused, I need to perform a data validation in cell C7, so that the days correspond to the month set in cell C6 and the year found in cell C8. The data is recorded ...
1
vote
1
answer
19
views
How to list dates material on order will arrive using Excel
I have a table that has all my different SKU's in item number and shows the dates the product should arrive. I want to be able to enter the item number and get a list showing when the product will ...
- 11
1
vote
2
answers
47
views
Counting elements based on three criteria located in two columns
I wanted to ask you if there is a way to perform a count by applying formulas directly, without having to resort to the filter option, through the COUNTIF or COUNTIFS function.
From two criteria found ...
0
votes
1
answer
70
views
FUNCTION INDEX + MATCH + OFFSET alternate solution
good day
In the attached file I have an Excel sheet in which I am performing some searches according to certain criteria such as month (cell I4) and Salesperson (I12).
The question is that for the ...
2
votes
1
answer
150
views
Two different computers downloading same spreadsheet - data displays differently
I work for a company in the United States. One of my clients is in Montreal. Whenever the client tries to download a spreadsheet from our network, she ends up with a bunch of data bunched into Column ...
- 23