All Questions
Tagged with worksheet-function microsoft-excel-365
71
questions
0
votes
0
answers
236
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
0
answers
287
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,283
0
votes
1
answer
62
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 ...
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
107
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
467
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
0
votes
1
answer
763
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
460
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
88
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 ...
0
votes
1
answer
275
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
1k
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
2
answers
70
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
1
answer
9k
views
XLOOKUP Function Disappeared
I have been using xlookup for several months across several files just fine but today it stopped working across all Excel files. I invested a lot of effort moving from vlookup to xlookup and now it's ...
- 1