All Questions
58
questions
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
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 ...
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
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
368
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