All Questions
Tagged with worksheet-function microsoft-excel-365
71
questions
0
votes
1
answer
349
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 "...
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....
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 ...
0
votes
1
answer
160
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 ...
0
votes
1
answer
55
views
Is there an excel formula to calculate all "like" entries from two criteria across two cells?
I'm putting together a personal budget and have added a tab to track daily expenses. I've allocated a "code" against a type of expenditure, and then a "sub-code" for more specific ...
0
votes
2
answers
7k
views
Cell referencing change with filter
I am quite new to Excel and just figuring out how to do things. I have a question about cell referencing between sheets.
Say I have on Sheet1 this table:
DIMENSION VALUE
X 0
Y 1
Z ...
0
votes
1
answer
50
views
Look for Date values in embedded in strings
I have a value in a cell that might have a 2-digit month and 2-digit year value embedded in it, and I need a function that would return TRUE if that is found.
Sample input data: sCa!1220LB6qHZbCnsEE ...
0
votes
1
answer
6k
views
Extract multiple columns with single dynamic array formula
In Excel 365, how can I select non-contiguous columns from a range using a single dynamic array formula? Consider data in columns A:E as follows:
Entering =XLOOKUP(G1,A1:E1,A2:E11) into cell G2 ...
0
votes
2
answers
1k
views
Excel workday function to skip custom array of holidays
I am trying to use the Excel "workday" function to assist with handling a large list of public and organisational holidays when scheduling education courses in a multi-state country (Australia). ...
0
votes
0
answers
14
views
Excel - Create 'Next' after spill range
I may be reaching the extent of excel's capabilities without getting into VBA (out of my depth).
I need the "Product Collumn" (Collumn B) to automatically populate (Spill) the subsequent ...
0
votes
0
answers
19
views
How to return unique, ordered data in Excel?
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 ...
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
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 ...
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 ...