excelformula

I need an Excel formula that will find the word that has a certain text on it. In the table below, I've tried to show what I mean. In column A, you can see the word that needs to be found in column B of the text, and in column C, where the formula should go to get the needed word, I would...

Building an excel formula that if a store is required to be open til 1am and their sales from midnight to 1am is greater than 100 then "yes" if not true then "no"

I have a column as NOTES that contains data such as 01-feb-2022 text text text w. text date text a.text date text n. text date text t. text date text basically, w.a.n.t. are the stages the note is written for. I want a formula to check if w.a.n.t. is present in the cell. There are some...

Afternoon all, I'm in the process of making a calculator for my work place an have run into a slight mind block I'm trying to calculate differences on 2 variables which is based on a pass or fail scenario the code I'm using is this...

Hi guys, I need to create a short schedule about my backlog in my DB. As you can see I have 5 category ( PWHT ,MPI/PT, HT, RT, UT ) with a little backlog ( PWHT 4 , MPI/PT 0 , HT 7 , RT 16, UT 0 .) and I want to see only Backlog Lines from my DB. DB range in Sheet1 A2:CC367 and also after...

I have code to where it takes a table and makes exact copies of them one after another. sheet one has a table that is 16 columns and when I run the code it will past the same 16 columns, for example A-P is the 16 then it leaves Q empty then pastes the 16 starting at R and so on Sheet two has 3...

Set SumRange = ReconWS.Range(Cells(2, AmountFilter), Cells(ReconRows, AmountFilter)).SpecialCells(xlCellTypeVisible) If Application.WorksheetFunction.Sum(SumRange) = 0 Then ReconWS.Range(Cells(2, MatchedItem),Cells(ReconRows,MatchedItem)).SpecialCells(xlCellTypeVisible).Select...

Sub Mail_workbook_Outlook_1() Dim UserInputToEmail As String Dim OutApp As Object Dim OutMail As Object Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(0) UserInputToEmail = Application.InputBox("Enter your email id") On Error Resume...

I am currently trying to use a formula range to automatically move along a column every month based on values up until the current month. When a new month begins the formula should extend its range to the next new month and extend the sum. Each month ranges up to 4 years worth. the error seems...

I am hoping someone could help me with an excel function I am struggling with. I have two tables one in sheet one and one in sheet two (as shown below). I want to generate an excel formula that will sum all the values for Q1 - Q4 that match each fruit name in the summary table on sheet 2. So...

Hi Guys, I am trying to develop a formula which can help me do the following: 1. Looks up for two specific values in two separate columns 2. Looks for the first value in a third column and also looks for the second value in a fourth value 3. If both the first value and second value are found...

I'm stumped trying to get my formula to do what I want it to do. The formula I am using is: =IF(ISNUMBER(SEARCH("2003",F4)),"NOT OK","OK") and the goal is to search for the text 2003 in a cell. This formula works perfect for cell F4 when the text is something like: "Microsoft Windows Server 2003...

C8 = "20" , K8 = "$1000" , K22 = "$2000" if c3 = "=c8" , THEN c2 = k8 = "$1000" if c3 = "=c22" , then c2 = k22 = "$2000" so if i just need to change c3 value , then c2 will follow is this possible? i want the formula in C2 cell thank you