excel formula

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.

Hello, as per the below, i have a sheet showing a page of info about different people. On a second sheet i have a list of the people: Person1, Person 2 etc and want to be able to quickly pull through the "Actual" result. Is there a way to lookup (for example) "person 6" across multiple columns...

Hi, I am using Office 365. I've tried the Concatenation approach and using a Vlookup, but I think it isn't working because the cell contains both numbers and text. I spent a while trying to sort that out, but I think my files have formatting issues, even after using the TEXT function, so would...

Hi, I'm trying to calculate a formula that if the result is less than zero then it returns the delta value but is capped at zero instead of the negative result and to then show the residual amount in the cell next to it. For instance cell A2=+20, cell B2=-70, cell C2 should be A1+B1 which...

Hello everyone, I am desperate with this challenge. 1 3 4 3 4 3 6 5 5 2 I need to sum the above column with the below criteria: 1. Sum values only once (as some values will be duplicated) 2. The value must be more than 3. So I need it as 4+5+6=15 I was able to satisfy the first condition by...

Instead of =COUNTA(A11:A5000) below formula automatically adjusts to however many rows with data, instead of limiting to 5000 rows, or putting a million rows: =MATCH("zzz",A:A)-10 Tried to incorporate same solution into =SUBTOTAL(103,A11:A5000) with =SUBTOTAL(103,(MATCH("zzz",A:A)-10)) and...

Hello all Racking my brain trying to create an Excel formula that gets the outputs on the two right columns. I want column C to only SUM the positive numbers within each Group under Column A, otherwise populate a $0 if it runs into a negative value. Then column D would be the inverse - SUM...

I have three columns in sheet1, Name ( in Column A), Secret code (Column B), and Secret Name (Column C). If any part of the name ( in Column A) matches with the Secret code ( in Column B), and Secret Name (in Column C).then partially color the matches. If a cell or row is empty then jump to the...

I have a question about what formula I should use for the following: I have a spreadsheet (similar to below). Across the columns are values such as A, B, C etc. Down the rows are item numbers. I have one table which has these items down the rows and ticks next to the relevant column value. E.g...

Hi Team, I am trying to create a price calculator. It is a bit tough and i am not good at these complex logics. kind of subscription model. Can you please help. Logic : 1. Select a product ( there are 10 different products) 2. Select the type of agreement ( three are 5 different options) 3...