All Questions
58
questions
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
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
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
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 ...
-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,...
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 ...
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
2
answers
2k
views
Formula to extract only unique values from horizontal range into a single cell, separated by comma
I have a spreadsheet where users are asked to place a value in their allocated column across many rows.
There are a range of other columns used by an Admin area and one of these is supposed to list ...
1
vote
2
answers
304
views
Excel 365: Array formula based on value above (compounding)
I am trying to perform an operation in a cell based on the value of the cell above it. Doing this in the "normal" Excel way is easy enough. However, I am playing with the array functionality ...
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 ...