# Questions tagged [worksheet-function]

Questions about using in-cell functions/formulas in spreadsheet software.

**0**

votes

**0**answers

11 views

### Find the first occurrence of a value in a filtered data set, and return a corresponding value from another column

I have a spreadsheet of donor data, and I want to find out where our new donors come from each month. A data sample is below, but the full data set is approx 80,000 rows, and is formatted as a table. ...

**0**

votes

**1**answer

29 views

### Return All Column Location of String Value (Can be subbed for T/F) in a Row

I have a quandary - I am attempting to automate a process where I am manually searching across 59 cells per row, looking to provide all cell locations that house the string value of "Unmet" I have a ...

**1**

vote

**1**answer

36 views

### How to implement this formula with braces and brackets into Excel

I'd like to use Microsoft Excel to compute this formula to find y :
But I absolutely don't know how to do... It's the first time I see such one.
Could you help me ?
Note : Td2 is a known variable ...

**-1**

votes

**3**answers

73 views

### Excel Formula IF/AND with MIN Calculating Due Dates

I'm creating a spreadsheet for payment plans. I am trying to create a formula to calculate the due date based on the $ amount and enrollment date. I want the formula to calculate for different tiers ...

**1**

vote

**0**answers

11 views

### Spreadsheets: Sum points per row based on if expected value is unique within row [migrated]

Given a Google spreadsheet of quiz answers (with rows for questions, and columns for people's answers), I want to work out a person's total score. The scoring system is that if only one person gives ...

**1**

vote

**3**answers

87 views

### How to automatically fill data in Excel in a blank cell, using a logical copy of data

I have data in cells A1-A50 and also data in C1-C50.
Columns A and C are synchronized;
i.e., the value in Cn corresponds
to the value in An.
When I enter information in column A (new row, A51+) I ...

**2**

votes

**1**answer

37 views

### Excel: Sum up a column based on conditions

I have an Excel sheet with such columns:
A B C D
1 1 X INT
2 1 X INT
1 2 Y INT
2 2 Y INT
3 2 Y INT
1 3 Z INT
2 3 Z INT
3 3 ...

**0**

votes

**1**answer

30 views

### Count if subtotal

I am trying to get a subtotal of numbers smaller than 3 in another sheet (named "Detail") were the formula is. I have other subtotal formulas in the sheet that work fine, but I am unable to figure ...

**2**

votes

**2**answers

33 views

### Using GCD Function With Arrays in Excel

I'm having trouble determining GCD from a dataset. I'm trying to determine the quantity of items in a box of any given item in a warehouse without physically looking at each item on the shelves.
...

**-2**

votes

**1**answer

38 views

### Moving data from one sheet to another via a hyperlink

I've searched the existing questions and found similar questions and answers but none that meet my requirements.
I have a spreadsheet where I wish to be able to click on links in one spreadsheet to ...

**0**

votes

**2**answers

24 views

### Excel offset from two different workbook, create a copy of one without affecting the other

I am using two different workbooks the first one [Excel Data only] created as a databse and the second one [Invoice Template] created to create an invoice.
When creating an invoice i am using offset ...

**0**

votes

**2**answers

47 views

### Formula to take the closest possible result from the lookuplist [on hold]

Need your help for the formula that can get us the closest match possible from the lookup list
I need to use a formula that will get us the closest possible result from the lookup list, in this case, ...

**0**

votes

**1**answer

46 views

### Excell SUM minus numbers

I am trying to add up specific groups of numbers (some negative) in a column, then get an average.
I've tried =SUM($O8,$O9,$O10)/3 where O8, O9, and O10 are negative numbers.
Other SUMs in the ...

**1**

vote

**1**answer

22 views

### Two If statements using index match

=IFERROR(IF(I33<120,INDEX('Cost Lookup'!$E$3:$E$12*I33,MATCH(Data!J33,'Cost Lookup'!$C$3:$C$12,0))),IF(I33>120,INDEX('Cost Lookup'!$F$3:$F$12*I33,MATCH(Data!J33,'Cost Lookup'!$C$3:$C$12,0)),""))
...

**0**

votes

**2**answers

57 views

### change 2017/2/3 to 2017/02/03

I have a column in Excel which shows date but not in date format, it is in text format and the values for those dates that have one character for the month or day don't contain a zero before them.
E....