# Questions tagged [worksheet-function]

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

6,815
questions

**0**

votes

**1**answer

16 views

### SUMIF only for last condition row

I have a spreadsheet where I need to total values using a SUMIF function and record that total in another column, but I only want it to record that total for the last instance of a value in the column....

**-2**

votes

**2**answers

60 views

### Is there an excel formula that determines whether a number is “stacking” or not?

I need help with developing an Excel formula that determines whether or not a 4-digit number has "stacking" digits (digits that are higher than the last e.g. 1234, 2356, 5679) without any ...

**0**

votes

**0**answers

10 views

### IF condition with ISBLANK using Google Sheets *driving me insane* [migrated]

I have a Google Sheet for investment tracking setup and I'm trying to add a ISBLANK to the following formula:
=IF(G67=TRUE,G12, G12*GOOGLEFINANCE(("CURRENCY:USDEUR"))) <--This formula ...

**0**

votes

**1**answer

21 views

### If VLookup Function that add corresponding cells if 1 range matches another

If B4 matches a # in column A I need the formula to return the # in column C and then add...
For example: Since B4 matches A1, I need C1 (90) +E1 (3) + F4 (0) and return the value in C4.
I tried this, ...

**0**

votes

**0**answers

18 views

### Excel validation of cell as per other sheet

How can i validate excel cell from other sheet below is my sheet example want to validate Sheet 1 from Sheet2 as reference.
I have done validation with same rows using FIND , Search function from ...

**0**

votes

**0**answers

26 views

### What can I do to create simple programs which will manage simple text databases? [closed]

I am taking in a large list of names.
I need to make some operations on them.
Such as: Entering and searching for them in a google search. Potentially pull information from websites, if that data is ...

**-3**

votes

**1**answer

35 views

### SUMIFs function plus returning specific cell and adding

If B4 matches a # in column A I need the formula to return the # in column C and then add...
For example:
Since B4 matches A1, I need C1 (90) +E1 (3) + F4 (0) and return the value in C4.

**0**

votes

**0**answers

29 views

### Excel 2016: How to find a specific name in sheet “A” and and get the adjoining cell's value to a cell in sheet “B”?

Excel 2016: How to find a specific name in sheet "ASPI" and and get the adjoining cell's value to a cell in sheet "Watchlist"?
I have currently used the method of this formula to ...

**0**

votes

**1**answer

18 views

### Validate Excel cell format

i want validate my cell on basis in below values
For ex :
12345678 Test Test Tets so beginning of cell always with 8 numeric digits
Test Test Tets (12345678) end of cell always with 8 numeric digits ...

**0**

votes

**0**answers

16 views

### Macro validation and conditional check

i have below excel where i want to do data validation for ColumnName1 ColumnName2 ColumnName3 & ColumnName4 and as well check the condition if ColumnName6 = ColumnName7 && ColumnName5 = ...

**0**

votes

**0**answers

15 views

### Listing function points in a spreadsheet/excel [duplicate]

I am working on a Pre-Calculus Polar coordinate graphing project that incorporates some creativity; My current plan has me graphing the Nautilus Shell as my focal point.
However, I have to list points ...

**0**

votes

**2**answers

20 views

### How to Fill One Cell With Date Based On Corresponding Cell

For a project, I'd like to look through a set of cells for a maximum in one cell, and auto-populate the next cell based on the corresponding date for the maximum.
For example, column A is the date of ...

**0**

votes

**2**answers

31 views

### VBA or Function to see if a serial number has been used

I have a workbook that contains the issued serial numbers for components. Column A has the serial number and Column B has the part number. I want to have a verification in column C if the serial ...

**10**

votes

**4**answers

7k views

### Spurious 0.0000000000001 added to formula result

My wife and I have a spreadsheet to work out our finances at the beginning of each month and this month has a strange figure in cell F9.
The formula in cell F9 is ="+ £"&-'Sue''s ...

**0**

votes

**1**answer

35 views

### How to return first non-blank value with LOOKUP function

I have a table:
table in which I reference data from a dataset using a LOOKUP function. I can reference columns(such as new_deaths) which have the latest(non-blank) data just fine. However, for some ...

**0**

votes

**1**answer

18 views

### How do I return the value of a cell immediately to the left of a certain value in a column of data?

I have two columns of data. In A5:A200 I have aircraft velocities, in ascending order from 5 to 200. In B5:B200 I have the amount of lift the aircraft creates at each velocity, these values initially ...

**0**

votes

**0**answers

24 views

### Convert to VBA Code

I have a multiple sheet workbook. I am trying to sort by Column A (date) in ascending order. Then I need everything greater than 180 days to be red. Everything between 0 and 180 days orange. and then ...

**1**

vote

**2**answers

28 views

### Minimum from a 3x3 table [closed]

I input the number 3.
I want to find the first number in a 3x3 table for example, that is bigger than my 3.
2 3 4
5 6 7
8 5 6
In this case, I want this formula to return 4.

**0**

votes

**1**answer

85 views

### Is there a way to copy all empty cells in a data set on one sheet and paste the empty cells into a data set on a different sheet?

Is there a way to copy all empty cells in a data set on one sheet and paste the empty cells into a data set on a different sheet?
For every cell in the “Sales Sheet” that is blank, the corresponding ...

**1**

vote

**0**answers

29 views

### How to highlight every cell in an ascending array after a preset multiple, i.e. y > n * x for any integer n [closed]

I have a column of ascending numbers. I want to mark every cell in this column that is larger or equal to an integer multiple of a predetermined value, e.g. 300 in the example image.
I tried using the ...

**0**

votes

**1**answer

23 views

### Excel Formula To Get Last Non Zero or Not Blank Value in Column And Return Value

I already saw a few related questions on here about finding the last item but my question is a bit different because I'm trying to find the last not blank or non zero value in a column and either ...

**0**

votes

**0**answers

21 views

### Copy data from desktop excel to onedrive excel

I need to copy data's from one desktop excel to one drive excel file by VBA. Is their any option works by VBA?
Like This I need to convert One drive excel source
Dim Iws as worksheet
Dim Ows as ...

**0**

votes

**1**answer

15 views

### How do I append values from one column to another range, based on matching values?

I would like to compare lists like the ones below for duplicate values. Then extract the duplicates from column Q, and append the names in that align with the duplicates to column T.
Is there a way ...

**0**

votes

**1**answer

19 views

### Find if cells in multiple cell ranges in Excel are blank or filled

I've got a template which others need to fill in. There are some cells which are required, and I'd like to find a way of showing in another column whether the cells have been filled in or not.
Let's ...

**0**

votes

**0**answers

17 views

### Is it necessary to use ArrayFormula to get the SUMIF function to work properly in Google Sheets? [migrated]

I am trying to find the sum of values in a column based on the month in an adjacent column. For example, Sheet 1 has Three columns, one for student remark, one for payment date, and one for amount. ...

**0**

votes

**1**answer

12 views

### Control+J equivalent using Text to Columns functionality

I'm trying to split a cell with multiple rows of data into into individual cells. Using the Text to Columns functionality.
Text: https://www.howtoexcel.org/tips-and-tricks/how-to-separate-data-in-a-...

**0**

votes

**0**answers

18 views

### Excel: Writing a 'report' within a worksheet

Summary
I want to have a specific worksheet within a workbook display a set of data from another worksheet within the same workbook - like a kind of report - in a specific order, for re-use/population ...

**0**

votes

**1**answer

113 views

### Excel formula to return value based on header and two columns

I'm trying to write an Excel formula that will place an "X" in a cell if the value in the header row occurs anywhere in column A while the values in Column B are unchanged. I envision the ...

**0**

votes

**1**answer

120 views

### Calculating lunch

I need the formula I already have to also include if lunch (30) is in E12. It also needs to calculate if 0 is placed in the E column if they haven't taken a lunch.
Thank you in advance.

**0**

votes

**1**answer

20 views

### Hide rows based on cell value X AND then all following rows until value Z

I have a huge Excel Spreadsheet and have certain rows marked with an "X" in Row B. Those are not important to me and I´d like to hide them.
However, I would also like to hide the rows ...

**0**

votes

**2**answers

48 views

### Excel - How do you compare on two separate columns for matching name and then print the biggest value in another

So my question in more detail is this
Column A - Organization name(Jeffs Pizza) {Dons burgers}
Column B - New Money amount ?? this is what is need ??
Column C - Organization name(Jeffs Pizza, Jeffs ...

**0**

votes

**0**answers

16 views

### Refilling cells without exceeding a certain amount, by a given percentage

I am sorry if this question might sound quite complicated, I will try to be the more clear possible.
I need that the amount in H13 (18,70€ in this case, if positive of course) refill the negative ...

**0**

votes

**1**answer

44 views

### How do I count the number of times a value appears in a 2D array in excel while also having a date condition that varies by row

I'm trying to create a function that calculates the number of times a specific text value appears in a 2D array, while also meeting a conditional that is unique to each row.
Essentially its just a ...

**1**

vote

**1**answer

14 views

### How to use “find” or “search” function on formula not on values/results

I am trying to create an Excel test for begginers but in order to automatically check the answers I plan to put IF/AND function, to check correct result and to check if propper function is used, but ...

**1**

vote

**2**answers

50 views

### Formula to extract value before specific text and after comma or beginning of original cell

I'm trying to extract statistics from a single cell 65 Rush Yds, 1 Rush TD, 1 Fum Lost, 105 Rec Yds, 1 Rec TD to individual columns Rush Yds: 65 Rush TD: 1 Fum Lost: 1 Rec Yds: 105 Rec TD 1
Extracting ...

**0**

votes

**1**answer

26 views

### Excel: Drop down with month instances

Is there a possibility to have a drop down with months inside, when choosing one month to show me all instances that are within that month?
Something similar has Excel format Tables, when you choose ...

**0**

votes

**1**answer

16 views

### How to select cells and subtract the numbers in the cells only when they match certain conditions

I'm creating an inventory management spreadsheet for my food business and I'm stuck with how to use IF, MATCH, or whatever formulas are appropriate to do this.
Specific scenario:
If a cell in the ...

**0**

votes

**0**answers

18 views

### Cells show #VALUE upon opening, until I force recalculate

I have an Excel workbook with 12 sheets and numerous cross-sheet calculations. All sheets are password protected, but the workbook itself is not.
On the budget sheet I have calculations that compare ...

**-1**

votes

**2**answers

45 views

### FUNCTION INDEX + MATCH alternate solution

I hope you can help me with the following query. I am performing a search in the matrix located in the range A2: G481 to bring me the values corresponding to the columns F and G, according to the ...

**0**

votes

**0**answers

7 views

### Simplify Google Sheets Sum Formula? [migrated]

This might be a super easy fix.
I'm just getting started with formulas and I want to simplify my document so it can run a little faster.
I have a big sum formula:
IF(D2<>"X - Done";C2;...

**0**

votes

**0**answers

37 views

### Depedent Filtering

Setting up a Product Order Form in excel for basic users
There is a comprehensive product master data sheet that includes product range, supplier, categories etc. This will be hidden from end user ...

**0**

votes

**3**answers

93 views

### How to sum up values in a column based on the condition in another column?

I keep a log and I wonder if there exists a formula that would sum up the values in neighbouring cells based on the value in the third column as on the image. The first "True" row must ...

**0**

votes

**2**answers

102 views

### Find Average of Last 10 Numerical Values in a Column

I am trying to find a way to get the average for the last 10 numerical values in column G. I am struggling a bit here as there are sporadic blanks in the column (not every row has a number in column G)...

**0**

votes

**1**answer

20 views

### Goal Seek says there are circular references, but there aren't

I have never used stack-overflow so I apologize if my question is formatted incorrectly.
Currently I am working on an excel workbook that is basically every single financial sheet in a company (...

**0**

votes

**1**answer

25 views

### VBA run module 1, wait till finished then run module 2, wait till finished then run module 3, wait till finished then run module 4.?

Excel 2019
Windows
I have 4 page workbook and each page has a VBA module that performs various tasks on the data from the previous worksheet so they need to be run one after another but ONLY when the ...

**0**

votes

**1**answer

42 views

### Excel counting rows within an changing range

Morning
We log how many queries we get per day on different subjects and i want to create a quick formula that automatically counts them for us. CountA partly works if i make sure each topic has a set ...

**1**

vote

**1**answer

45 views

### COUNTIF across multiple sheets does not work with SUMPRODUCT

I have the two sheets below.
(The example table above is highly simplified for this question)
I'm trying to write a formula that adds the total occurrences of A under the year 2017 (Answer is 3).
...

**0**

votes

**0**answers

40 views

### How to apply Text cell format permanently on a google sheet's column?

I recently added IDs as Number in a column those are basically built as alphanumeric.
Then I've applied Text cell format on those IDs to keep their data consistent with the other cells in that column, ...

**1**

vote

**0**answers

11 views

### Excel table.combine({Sheet1},{Sheet2}) erases data on an append

I have a power query combination that looks like this:
= Table.Combine({#"Sheet1", #"Sheet2"})
Now the tables combine, and most of the data appends, but some rows are missing in ...

**0**

votes

**0**answers

12 views

### Excel - quarterly budget cells adding up if the date cell is in range

I have an excel sheet that has rows of data (expenses and revenues). I have a (date) column that changes the cell color to match the specific quarter based on the specific date in the cell. I would ...