Questions tagged [microsoft-excel-365]

Use this tag for questions specifically about the 365 version of Microsoft Excel; otherwise use [microsoft-excel].

Filter by
Sorted by
Tagged with
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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,...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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), ...
user avatar
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 ...
user avatar
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 "...
user avatar
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)...
user avatar
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 ...
user avatar
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....
user avatar
  • 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 ...
user avatar
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. ...
user avatar
  • 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 ...
user avatar
  • 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. ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
-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,...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar