Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Join us in building a kind, collaborative learning community via our updated Code of Conduct.

Questions tagged [worksheet-function]

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

0
votes
0answers
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
1answer
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
1answer
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
3answers
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
0answers
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
3answers
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
1answer
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
1answer
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
2answers
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
1answer
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
2answers
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
2answers
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
1answer
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
1answer
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
2answers
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....

15 30 50 per page