Questions tagged [worksheet-function]
Questions about using in-cell functions/formulas in spreadsheet software.
452
questions
2
votes
2
answers
10k
views
How do you make a set of cascading dropdown lists in excel?
I'm working on a system to try to take inventory more quickly instead of filling in each row by hand.
The reference data is several hundred rows. The first 3 columns in the reference sheet are Class ...
2
votes
1
answer
8k
views
Using Excel Linest function with blank cells
I need LINEST function to be applied with blank cells to get the slope parameter as well as the associated standard error. I can get the slope parameter with a normal function that may resolve the ...
2
votes
3
answers
13k
views
Listing non-blank cells in Excel based on adjacent column(s)
Given columns A and B, I want to list the A-values that have a non-blank B-cell in their row, in column C:
A B C
One Two
Two x Four
Three
Four x
...
The best I came up with so ...
2
votes
2
answers
1k
views
Can I use the Excel Match function to match on more than one type of value
In another question I posed recently I was shown how to use the Excel Match function to query my data in order to produce a summary type table:
Creating a formula that queries data in Column B based ...
2
votes
3
answers
2k
views
Return sum of multiple vlookups
Okay, so I have an issue I'm trying to solve all in one formula.
I have a setup of tables:
How many NFPI (Number of Fruit x Percent Intensity) do I have for Apples?
I need to scan column G of Table ...
2
votes
1
answer
550
views
how to determine which values in a given set of cells will add up to a numerical range
In other words, I'm looking for a sum range that consists of combinations of cells from an array. Given a set of numbers:
1 720 56 17 59 120 153 203 39 1 690 583 582 561 256 310 232 95 108 16
26 ...
2
votes
1
answer
14k
views
How to copy a column with conditional format by "value" - Libreoffice 4.1
I have a column that contains the data and a set of rules for the conditional format of the cells.
i.e. the conditional format changes the background colour of some cells if they are negative.
I ...
2
votes
3
answers
35k
views
Lookups targeting merged cells - only returning value for first row
I have a master worksheet which contains data that I wish to link to another 'summary' sheet using a lookup.
However, some of the cells whose data I wish to include in the summary sheet are merged ...
2
votes
1
answer
70k
views
How to hide formula results until conditions are met
I am completely new to making spreadsheets with Excel and even more dumb when making formulas. I have come to surprise myself how much I have learned, but now I am stumped and could really use some ...
1
vote
1
answer
49k
views
Copy Data from One Sheet to Another if Criteria Met, Relative Rows
I need to copy data from one worksheet to another based on criteria being met. On Sheet 1 (All Projects), information is collected in columns A - L. If "Project 1" has been selected in column M on ...
1
vote
1
answer
4k
views
Excel: How to extract group of the same rows and their values into columns?
How can I extract the second table from the first one? I need to extract those titles that have exactly three costs (in the following example: f1 and f3). I tried using pivot tables but could not ...
1
vote
1
answer
94
views
Filtering a column and summing values (in Excel)
I have an Excel worksheet, pieces of which are shown below:
I want to filter column D so they're unique (i.e., cat, dog, fish) and sum the values corresponding to those values like this:
I'm ...
1
vote
1
answer
204
views
Excel SUMIFS based on two criteria
I would like to total a list of minutes based on two criteria to make a graph after the data is calculated.
The item "Department" (Column C) and "Day of Week" (Column F) are both drop down menus.
I ...
1
vote
2
answers
2k
views
Excel Formula difference between two dates
I have two dates as the following , I want to get the duration spent between them.
6/29/2015 12:18:04 PM
Regards,
1
vote
1
answer
129
views
Excel: Changing and updating a future value based on past occurrence and lookup in a table
I have a big dataset, dataset is in such a way that each time a customer is called a row will be created. So the customer Number is the unique ID here. Based on their current and past response type, ...