formula help

I need some assistance with a formula for Google Sheets. The following formula works in Excel, but not in Google Sheets. I don’t believe the “Take” formula is in sheets. Any ideas on how to find what I’m looking for based on the example below? =TAKE(SORT(FILTER(C3:D10,B3:B10=G5),2),-1)

Hi all, I am looking for a formula which will count the no of blank cells in a column having no color fill. I have values in both filled and unfilled cells. i want to get the count of unfilled cells if there is no value in it.

Hi everyone! I have been asked to lead a presentation for my company. I have a shortened list of some of our sales staff and a longer list with all staff. Is there a way to transpose a list of quarterly performance from the shorter list onto the longer one whilst keep any gaps? I am fully a...

Hi, I am a teacher and I have been given a list of students who's grades I need to have a closer look at in excel. I have a curated list of students in one column and the raw listing of the students in the next column with the associated grades after that. I want to remove all the students from...

Hello I am trying to track my energy usage and have a spreadsheet with two sheets ABCDEFG1No.Period FromPeriod toElectricGasVATTotal2101-Mar-2229-Mar-22 ABCDEFGHIJ1No.Period fromPeriod toFuel / StandingTypePrevious ReadingLatest ReadingUnits UsedKWH Rate or Standing Charge Daily Rate...

Hello excel experts, I have the following formula: =SUMPRODUCT(SUBTOTAL(103,OFFSET($F$26,ROW($F$26:$F$999999)-ROW($F$26),0)),($A$26:$A$999999=$A21)*($B$26:$B$999999=$B$7)) The issue that I have run into is that each time I update my pivot table that uses this formula I run out of resources. I...

I've been given a work assignment where I need to fill out an individual tab per sales account. Some of the accounts are locations of a larger parent company. The original template given to me by my organization requires entering data in a single column (C) answering questions/data points...

I've got my column headers as dates Column C:N and my rows 2-3 contain the numbers. I'd like to find the cell in row 2 that first reached a number >=1 and return the date in column header. I'd like to have Column T return the column header for the cell that first meets my criteria. My formula...

Hi Guys :) I am a novice Excel user who is looking to automate my workload to save me time. I am currently working on a financial project for my business and I have attached a screenshot to show what I am talking about. I have my data which gets pulled automatically on the left and then I...

The title can be a bit hard to understand. English isnt my native language, so i am sorry. What i meant is this: I have a Cell with a value of, lets say, "1,2,3". Now i want the position of the last comma. In this case it would be the Position 4. How can i search for it with a formula?

Hi all, I use a spreadsheet as a tracking doc to keep track of our process from project upload through client approval. The way the doc is set up is Column A (Name) has the name of task. Column B (OMIT) is where we log if a task has been omitted. Column D (Code) host the code I need help...

I'm having trouble coming up with a formula that will check for certain conditioners in a specific order. Any help is appreciated. If D144 is blank and E144 is not ‘Specific Text A or Specific Text B’, return E144. If D144 is Blank and E144 contains ‘Specific Text A’ return ‘Specific Text X’...

I am stuck trying to convert this dynamic formula to use the CONCATENATE function instead of the &s. I am using an Excel add-in that does not accept "&" in formulas. I have tried several times to do this myself but cannot figure out what I am doing wrong. It doesn't seem to play nicely with the...

Hi and thanks for helping. I'd like to apply a known deposit amount (B1) to a set of projected income for the year (B3 - M3) If the monthly income is less than the deposit a "No Invoice" is returned under the related month (example B4 & C4) If the deposit is applied, but there is a remainder...

I own a small business and I'm having trouble with employees adding incorrectly and I'm wanting to create a spreadsheet that will do the math for them. As a part of my business I sell lottery scratch off tickets. Each ticket is numbered and we count them down at the end of the day to determine...

Hi all I could really do with some help as I can't get this formula right. I've been trying to use IF INDEX MATCH. IF A2 contains 2016 INDEX data from Column C MATCH H5 postcode with X5 postcode I basically have numbers in column C that I want listed in a new table, but only if cell A2...

Could I get some assistance on a formula that I need in cell B11 below, where I'm looking to sum the total in column B for all of the units that are categorized as "old" (i.e. what's in cell A11) based on the table in F1:H7. Excel 2013 64 bitABCDEFGH1Location1Location2Location1Location22Unit...

I am stumped! I am trying to figure out a formula and it is jut not working. I am working with SKU's and UPC's. Where I work I am dealing with product that has either a SKU or a UPC on it, and I am currently in the process of having to verify where product is in the warehouse. What I am needing...

Hi, I am trying to create a custom data validation and I need some help with the formula syntax. In my spreadsheet Column B has a drop down that says "Refund" and "Charge". I want to create the custom data validation in Column D to limit the number of characters in the cell so that any line...

We are getting rid of some old products, and directing the demand for the old product to a new product. I am trying to setup a table which shows the change in demand for the new product. Here are some very simple tables which lays out what I am working with. I have a table called SKU_Mapping...