formula

Hi.... I have made this macro in VBA: Sub ErstattTxt() 'definitions Dim i As Long Dim OldFormula As String Dim OldFormula2 As String Dim NewFormula As String 'loopstart i = 1 'grabbing exsisting formula in active cell OldFormula = ActiveCell.Formula 'Remove the =character in exisiting...

I'm having an issue with a FILTER function that is just sending back a value of #N/A and the error help obviously doesn't say too much. Hoping someone here can help. My formula is =FILTER(TimetrackedLogs!$A$2:$N$200000,TimetrackedLogs!$N$2:$N$200000="my_value","No results") Column N in the...

Can somebody help me fill in the green column. Please also put what is missing the the formula and show me where to put the correct functions in row 1 too. I was using Clearbit V1 API. initially. GET https://autocomplete./companies/suggest?query= name...

Hey everyone! I need some help tweaking my formula to get rid of the #VALUE error it's generating. Formula Goal: if range 1 (date format) is a Saturday, then sum the relevant cell in range 2 (number format) >> count how many of something is being done on Saturdays specifically out of all the...

Hi there, I am looking for an Excel formula that will will sum fractional values (test scores) in cells based on whether the column headings in the range equals the heading in the summation column. I need to sum the numerator and denominator separately (i.e. 5/6 + 2/2 = 7/8) Below is an...

Greetings excel community, I have some cells that contain a zero and I would like to replace the zero value with the value from the preceding row (the cell above). I saw a formula online which is as follows:=INDIRECT(ADDRESS(ROW()-1|COLUMN())). However, I would have to copy and paste this value...

I have two worksheets, sheet1 is a table to list tasks with the unit number named "task" and sheet2 is a table to list the task handling progress named "progress" . and i need to color the task row in sheet1 in red if the same task is mentioned in sheet2 and date is mentioned as done in sheet2...

I have a worksheet table with 4 columns containing employee name and 4 columns for ID number for this employee simply and I need a formula to add the employee ID number which is next to the name if the cell match any cell of the employees names in the 4 columns ("B , D , F or H") for example as...

I've got a range of letters, and I want to calculate how many unique values occur in it, excluding the letter A and empty cells. I've used the formula =COUNTA(UNIQUE(FILTER(A1:A10,(A1:A10<>"A")*(A1:A10<>"")))) which works fine, except when the result should be zero. Here are some examples...

I have this line of code that I require an excel macro to type out, and drag and drop down. =IF(AND(E3>C3,G3>E3,F3>D3,H3>F3),"UP",IF(AND(C3>E3,E3>G3,D3>F3,F3>H3),"DOWN",IF(AND(E3>C3,G3>E3,D3>F3,F3>H3),"LEFT",IF(AND(C3>E3,E3>G3,F3>D3,H3>F3),"RIGHT","NO")))) Recording an excel macro it turned out...

Good Morning, I am looking to generate a formula that will show the name and number of projects a team member is working on. From the screenshot provided I want to know how many projects from column A are associated with a name from Column D (Project Team). An issue I am coming across is that...

Hi there, Is there an excel formula or VBA code that can highlight the 2nd occurrence of a specific character in cell? For example, the letter "B" appears twice in the cell, how can I highlight the second "B" in blue? BATBML Thanks, Ching

I am looking for help creating a sum function for my attached spreadsheet. In column G (Total Activity) I would like to show the sum of column D (Quote Count) and column F (Modification Count). However, in the formula I would like it to be crafted so that column G only populates once column D...

We manufacture products and then cut to them to the length customers ask for. I have a sheet containing all our orders, and I'm trying to write a formula to calculate what length 90% of our orders for each product are over. So if we have any offcuts, we know if it's worth saving them or not...

Im sure this may be a bit confusing, but i have a database similar to the first image. What i want to do is, based on the data on "Info" ranges, apply a value to the "Value" ranges. For that i had formulas such as "=if(A1 = "A",1,0)" or "=if(and(B1 = "red",C1 = "pear"),1,0)" which would get me...

I have the following formula that I am using to count the number of occurrences of there being a value of 0 out of a number (i.e. 0/2 , 0/5, 0/1, etc...) =COUNTIF(Z7:Z30,"0/*") This works fine as long as the data in the above range (Z7:Z30) is formatted as the above i.e. 0/3, however there...

Hi all, Thanks to some of your great earlier contributions I was able to set up with this formula: =IFERROR(LET(mpos;MATCH(1E+100;G7:K7); mval;INDEX(G7:K7;mpos); IF(mval>V7; RIGHT(INDEX($G$3:$K$3;mpos);2) & " TPC is bigger than TPC MEC by " & TEXT(ROUND(mval-V7;0);"#.##0") & " USD"; ""));"")...

I am trying to get the extract date to be put under the "Last Use of Body Scanner" in the last image. But before that, I need to match criteria, such as name match, most recent deployment with that equipment in use, and if that personnel is certified in that equipment before the date is...

Hello to all who might be able to assist me and my colleagues with this. I am trying to find a way to split the ranges of numbers apart and to get each individual number that would be in that range. For instance, some of the data I am working with is: 120751.120754 120760.120764...

In excel I have sheet 1 and 2. Basically if the cell value in sheet 1 is either (s) or (c) I want to pull a value from sheet 2 based on the (s) or (c). So to break it down in sheet one I have the baseplate geometry and it can either be sqaure (s) or circular (c), based on if that cell says (s)...