formula

I am creating a SKU system for a huge catalogue of items that will grow and grow over time, I'm looking to future proof with a SKU that can create over a billion variations so I will never run out and is easy to understand I'm looking at the following: AA0A0AA AA0A0AB AA0A0AC up to: ZZ9Z9ZX...

I am using Excel 365. I cannot use mini-sheets, because of security reasons. What I am trying to accomplish is write a formula that uses the table to the right as the array. I want it to return only the last and first names of the people that have amounts due. The right hand table is named...

I need an Excel formula that checks for value between 2 seperate ranges. Check if value is between (.0406 and .0483) or between values (-.0483 and -.0406). Either value is OK in the Same Cell I tried and if statement. This one Didnt work however. This is what I have. However the code only...

Hello everyone,I'm currently working on an Excel project where I need to copy data from one sheet to another using the VLOOKUP function. I have two sheets: Sheet1contains the following columns: Column G: CODE Column F: CUSTOMER Column E: UNITS I want to retrieve the CUSTOMER name based on a...

I am just brain dead after the whole new years, I need a formula that will count Column A together for everything that is the same in column B. Example so i would want all of the records with ABC to be added together so 170 for abc.com and 90 for DEF.com to show up in total hit counts for...

Hi Community members, I am compiling a spreadsheet to list the department meeting schedule for the year, retain records of past meetings, and record statistics for meeting presenters. Sheet "DC-80 Outlines" contains a table listing talk outlines prepared by my company's WHS department. Several...

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...