# Questions tagged [worksheet-function]

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

**0**

votes

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**3**answers

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

**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

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 ...