All Questions
Tagged with worksheet-function microsoft-excel-365
70
questions
0
votes
0
answers
7
views
How to return additional data in a LET function?
Last year I asked the following question. The formula has been working great. But I've been asked to provide some additional information that I can't quite figure out how to add.
My input data now ...
- 3
0
votes
1
answer
25
views
Median calculation of IFS function returns #VALUE! error
I need to calculate the median number of construction days for multiple projects across multiple markets and based on whether the project is completed or not.
Examples
ROW A = Markets
ROW B = Days in ...
0
votes
2
answers
163
views
Can an Excel Filter function base its include on a whole row?
I have a Table from which I pull a list of unique values, then I want to pull all their keys and merge them using textjoin. But the Filter function the criteria to be compared against a single value, ...
- 988
0
votes
0
answers
51
views
Identifying "bad" data combinations in Excel 365
I have a spreadsheet of employee data (time charged to projects and customers) that is tens of thousands of rows long. Each month, the file is updated to include the most recent month data. Each row ...
- 1
0
votes
0
answers
20
views
Dynamic Dropdown, MS Excel, Use on Multiple Rows (MS365)
Goal
Using Excel table ("Claims") to track claim statuses, have dropdown values in certain columns (in Columns C, D, F, G) in which the dropdown values for Columns D, F and G are Dynamically ...
- 89
0
votes
2
answers
182
views
Calculate when volume counts are cleared based on daily amount received and daily amount processed
I have this data table containing the number of returns per day (Ret Volume) and the number of returns that have been processed per day (Volume Cleared).
What I'm after is the date displayed on the ...
0
votes
0
answers
231
views
How to copy the format of locked cells in Excel?
after the latest update of the Microsoft 365 package to the version 16.0.16227.20202 (32-bit), I am no longer able to copy paste the format from and to locked cells. In the previous version (16.0....
- 103
0
votes
1
answer
60
views
is it possible to logical AND two values from two different columns in COUNTIFS?
I have the following formula:
=COUNTIFS(Transactions2023[Result], "Win", Transactions2023[League], "NBA", Transactions2023[Date], "<=" & "4/11/2023")
I ...
- 113
0
votes
0
answers
284
views
Why doesn't my Excel 365 does not cover the "LET()" worksheet function?
My Excel account information shows me I'm working with Office 365:
However, the LET() worksheet function is not covered, as you can see:
What do I need to do in order to get this function to work? (...
- 2,281
0
votes
2
answers
126
views
How do I convert a custom function to handle spill arrays (excel)
I need a function that produces a list of sheet names, I already have one that can turn sheet numbers into sheet names but it doesnt handle arrays
The function I would like to convert is
Function ...
- 53
0
votes
1
answer
61
views
IF Function Not Populating Correct Data in Excel 365
I am completely stumped as to why this formula is not working properly. To provide backstory, I am trying to randomize a DMS grid coordinate, for example: 2339**01**N05005**51**W. I only want to ...
0
votes
2
answers
3k
views
How to drag a cell reference formula down a column, but move the cell reference across a row
I am trying to drag a cell reference formula down a column, but have the row value increase as the formula is dragged down.
For instance, in the shot below, cell B3 has the formula "=I3". I ...
1
vote
1
answer
587
views
Getting unique items from comma separated lists in Excel
I have the following setup (which is shared by a number of users through office 365 and changed frequently):
I need to collect all unique items from a number of comma-separated lists in a range and ...
- 13
0
votes
2
answers
71
views
Excel formula gives unexpected result
Each year I create a workbook within which there are several worksheets corresponding to each month of the year. I copy and paste the same table with formulas into each new month as the year ...
- 103
0
votes
1
answer
5k
views
Use FILTER function to "Include" match against an Array and not one value if possible
I'm currently trying to filter some data. I have two sheets, one with the users name, e-mail and their function within the company and another with the same e-mail and then which mailboxes they have ...
- 1
0
votes
1
answer
135
views
INDEX MATCH with multiple matches. Find the MAX match
I ran a GIS operation that provided me with a table to show the 3 closest lengths of pipe to a valve. Main line pipe comes in 12,8,6 & 4 inch sizes and outputs to 4,3 & inch lateral lines.
I ...
0
votes
1
answer
106
views
Excel find non matches reverse XMATCH
I need a formula that finds non-matching entries in array1 with the criteria array2
To make this simple (and as the actual data is confidential)
array1 is {"a";"b";"c";&...
- 53
0
votes
0
answers
458
views
Excel Data Validation: If any cell in this row isn't blank there must be a value in this cell
I'm trying to set up data validation in a cell so that if any cell in a range in that row has a non-blank cell, the cell with the validation must have a value from its drop-down list. As data is ...
- 1
1
vote
1
answer
367
views
=DATEVALUE() behaving different in Excel 365 online and Excel 365 local
I noticed that =DATEVALUE() behaves different in the online version of Excel 365 (i.e. it does not work) than in the local version of Excel 365 on my PC. Below are two screenshots of the two Excel ...
- 107
1
vote
0
answers
12
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
0
votes
1
answer
754
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
345
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,...
0
votes
2
answers
1k
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 "...
- 15
0
votes
1
answer
382
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
455
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
68
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
86
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
1
answer
27
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
0
votes
1
answer
41
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 ...
- 672
-1
votes
3
answers
98
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