Questions tagged [worksheet-function]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
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
2answers
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
0answers
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
1answer
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
0answers
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
0answers
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
1answer
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
0answers
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
1answer
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
0answers
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
0answers
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
2answers
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
2answers
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
4answers
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
1answer
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
1answer
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
0answers
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
2answers
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
2answers
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
0answers
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
0answers
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
2answers
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
0answers
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
0answers
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
3answers
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
0answers
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
0answers
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 ...

1
2 3 4 5
137