excel formula

I have a formula that works but need to put a twist on it to look at another column / Sheet. {=IF(ROWS(E$5:E5)<=$B$8,INDEX(INDIRECT(E$4),SMALL(IF(Date_Received=$A$8,ROW(Date_Received)-ROW(AuditLog!$B$2)+1),ROWS(E$5:E5))),"")} This is working. I need to add this to it...

I have an excel where I need to pull in the total hours for a date range (always start on Monday) in my excel tab called 'Dashboard'. I'll be getting the data from the tab 'Budget' but I only want to pull in the number based on the QuickBooks Code I've identified on B1. So AH3 will equal to...

Hi, I have the following table and my goal is to have to restrict the number of keywords per key to 3. For every key containing more than 3 keywords, I want to delete every keyword after the third one...

Hi there, does anyone know what formulae I can input on the right table to easily track these data from the left table and input them instantly on the right table based on the various names (especially if the list on the right side names are not in order on the right) I have included the link...

Hi all, I want to highlight cells when the row has 5 consecutive (or more) "Need attention". I only want to highlight cells with a word of "Need attention", and only if there are at least 5 consecutive word of "Need attention". The cell values are from a formula. Thank you in advance.

Hi everyone , I need help with a lookup. I have one spreadsheet that has the invoice number, and on a second spreadsheet they combined all the open invoice numbers in a single cell by PO, I need help with a vlookup that can search the column A for the single invoice number and return the PO...

I need some help please. I am looking for a excel formula that will determine the parent of a child based off a number/period outline on sheet 1 (yellow column sheet 1 "Item No.") and take the part number of the parent (orange column sheet 1 or yellow column sheet 2) and populate a column with...

I would like quite a complex formula. I got close to what I wanted but couldn’t quite get it right. The sheet has a series of columns: - Date started - BF date - Column to state “Checked”/blank to show if cleared, making BF date redundant (but left in for auditing) e.g.: A1 - Date started, B1...

I am sure this is simple but i have searched the internet to then end with no answer. I have 3 columns. A1 has the name of of the person B1 Has the sales made column 3 has the price per sale. What i am trying to do is this: In D1 i want it to do a if greater then .8 but less then 1.3 show...

Hi guys, Sorry that I don't know how to upload under excel format so that pls help to review this image. I'd like to get result in column C = "c" following below logic however don't know which excel formula is workable. Kindly help to solve issue. Thanks. Requirement: a/b/c Approved: a/b...

I have a data coming form submits to Google Sheets through Zapier email action. The data comes into 1 column and 1 row for each submission. The cell data looks like the following between the quotes: "You have received a new form submission. Be sure to follow up with this lead as soon as...

we have the following sheet:- ABCDE1Unique NoSelectNameUnique CodeBook Status2Call WorkSevian3Work Recd. 4Call WorkJohn5Work Recd. 6Review 7Call WorkRoz8Work Recd. 9Recd/Started!!SQ360#Partial10Recd/Started!!SQ360#Partial now we want to auto generate a unique number (which will be in serial)...

Hello, I need some help finding a formula to calculate the values from Table 3 (Lgt Exptds), details about the dataset are below. - I have the main table (Table 1 - Actuals) which represents the values of 5 Brands for 3 different Brand Images. - Table 2 (Logit) was calculated from Table 1...

Hi all, Hope to get your support to solve this issue. I've searched in forum & there are many way to do but I still can't do with my data :( Pls help to review this case & advise which Excel formula should be? (Not VBA or Pivot) Below are What I want: 1. If I do filter at column B = Petter =>...

Dear All, I require a formula to count the respective colours for each employee as below:

Hi , I am trying to calculate running values for time based intervals My table is as follows Time Value 09:00 AM 100 09:15 AM 120 If current time is 09:00 AM It will calculate value from source data and display the value. For 09:15 AM no values will be calculated If...

I have this issue, I'm creating a form that must have a specific folio according to previous entries. I'm creating the form with ActiveX fields, I tried to link a textbox value from a cell where I have a simple excel formula that gives me the folio depending on the prveiously entered data...

I have an excel table with a cell that contains message data, and the message data is divided into multiple fields that can be easily identified using the field ID format, i.e., "FEILD NO." Now have two requirements: first, to pull the complete data content of a specific field; and second, from...

Hello i am trying to get this formula to work but i keep getting a "There is a problem with this formula" error, and i am not sure why that is =IF(AND($P$6=777(RIGHT(TRIM(AT6),3)="_CB","0777","NONE")))

As titled, I'm looking for a formula in column B that would do something like this: David 1 John 2 Rhys 1 Emma 1 Shepard 2 Margaret 3 Elise 4 I don't mind needing an extra column for the formula to work. Thanks in advance.