Use this tag for questions specifically about the 365 version of Microsoft Excel; otherwise use [microsoft-excel].
Excel is Microsoft's spreadsheet application; Excel 365 is part of Microsoft Office 365.
For more info, see microsoft-excel.
Questions tagged [microsoft-excel-365]
229 questions
1
vote
1 answer
Single SUMIFS and COUNTIFS work, but two SUMIFS and two COUNTIFS do not work
I'm exporting data for a manufacturing environment and importing the CSV into Excel. This data refreshes every 5 minutes.
On the first worksheet, I'm able to calculate efficiency % properly (N:N) with a single SUMIFS and a single COUNTIFS. However,…
TrackerRick
- 11
1
vote
0 answers
availability of LAMBDA function
I'm waiting to get LAMBDA function in Excel.
Support page says it's available from 16.0.14729, I have 16.0.14931 which I believe is a higher version number, still I don't have it yet. Am I overlooking something?
MS support site…
Máté Juhász
- 21,451
1
vote
1 answer
How to define Outline direction in Excel Data Grouping
In Excel 365 (version 1908), I want to group columns using the Data -> Outline -> Group function. This works fine, but it only groups columns to the right. However, I want to group the columns to the left. In Excel 2013, I could define the grouping…
Thomas
- 201
0
votes
0 answers
Nested ISNUMBER SEARCH functions, if more than one returns as TRUE
The problem I have is that if Georgia appears in more than one classroom this string only shows the first occurrence, and I want it to show an error because she cannot be in 2 classrooms at once. How do I make it show a FALSE/ERROR value when more…
BJT
- 1
0
votes
0 answers
Excel How can I build a formula to return the average of the top "n" percent of a column of numbers, while also referring to a 2nd column with names?
I have an Excel 365 workbook with a data table on one tab and a results page on another tab. The data table contains, among other columns, a column with the results of hundreds of trials, each with a numerical score assigned to the adjacent name.…
0
votes
0 answers
Excel 365 Enterprise: Chains of External References
Here is my situation:
I have a base spreadsheet called "data" which does not reference any other spreadsheets.
I have 10 intermediate spreadsheets, each with lots of external links to "data" which work as I would expect: When I change something in…
Anonymous
- 136
- 2
- 13
0
votes
0 answers
Does Excel 365 Not Let you Drag the Formula Bar Down?
Am I crazy or can you not drag down the formula bar in Excel 365?
Clarification:
In the formula bar at the top of the screen, where you enter in your formulas (i.e. A1 + A2), is there a way to make this box bigger?
0
votes
1 answer
COUNTIFS Function for Multiple Criteria
I have a set of columns that look like this:
Keep Label
red
blue
green
Yellow
Pink
I want to do a COUNTIFS function that does a count if the row is "red", "green" or "yellow.
Expected Output:
3
Any…
0
votes
1 answer
Autopopulate table row based on different table's row with same index #
I have a populated table on one worksheet/tab1 with multiple rows and columns.
I want to create a new table on tab2 with same columns and one new column that asks Modify "Yes/No" question. If a user answers "Yes" for row 10, he will fill out that…
Masha
- 1
0
votes
1 answer
Excel - Office 365 formula loss on refresh
I have a query of external data, with a date range parameter. Included in the table are several columns which make calculations based on the queried data. My issue is when I change the dates or refresh the data, the formulas are erased. How can…
-1
votes
1 answer
Generate Time ranges in Excel 365
What is the formula for calculating a random time that ends later than the start time calculated in another cell?
For example, A1 contains the formula =RANDBETWEEN(1,1359)/60 formatted as a time, so I get a start time between 00:01 and 23:59. I…
