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
16 views

How to take a set of values and compare it to multiple criteria rows

Example of what I would like to achieve: A B C D E F 1 1 <= 2 2 1 2 2 <= 4 23 8 3 4 <= 7 5 3 4 7 <= 10 40 10 5 10 <= 12 7 3 6 12 <= 17 8 4 7 17 <= ...
0
votes
1answer
21 views

Formula to get a sub table where the values in a column match a certain criteria

I'm looking for a formula to get a sub table out of the main table, of the rows in which the balance column has a value greater than zero. NameClass Date Pre Balance July Van Fine Total ...
0
votes
1answer
14 views

How to prevent #REF errors appearing in formulas when referenced workbook is opened

In my workbook A, I have formulas that reference my workbook B. Once I open workbook B and enable editing, all of the formulas in workbook A show workbook B's worksheet name as #REF (but the filepath ...
2
votes
2answers
20 views

Excel - How to return different match values with other formulas?

I have the following table and resulting formulas: First I have the sales person and the number of sales. Then in columns D and E, I want to know who are the best salesepeople. The formula in E2 is ...
0
votes
1answer
21 views

How to calculate Q1, Q2… but for a given date and not 01 Jan

I have been trying to calculate the Quarter period but not for a year that starts on 01 Jan but for a date that denotes the end of year which could be 03-22 for example. There are a lot of examples ...
0
votes
0answers
56 views

Excel vba, Changing cell references in formula to point to different cell location

I am trying to move (offset) only parts of formula column location to a different column location by a specified amount of columns. The formula cells change from sheet to sheet. I have thousands of ...
-2
votes
0answers
30 views

Office 365 Excel

Q1: I am generating a percentage of completion with the formula =COUNTA(E4:N4)/COUNTA($E$1:$CU$1) However, I would like it to ignore any "no" values in a cell. How do I write the formula to ...
1
vote
1answer
31 views

Assign Nested Sequential unique numbers for items in Excel Table

I'm trying to generate a unique ID number for a items in a table in excel. For example: 1.2.4 For each column the number is uniquely numbered based on the text. For example in the table below would ...
-1
votes
0answers
22 views

Excel VBA programming [on hold]

One column has a 16 digit ID number. I need to be able to copy and paste that number into a cell and it will be able to tell me if it is duplicated. If it is duplicated the number of times it has been ...
0
votes
0answers
20 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
49 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
38 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
77 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
90 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 ...

15 30 50 per page