formula

Hello, I am trying to find a formula to return the value of the duplicated number in cells that are not right next to each other, but within the same row. In the below example, I need a formula in column I that does the following: If the variance to on-hand in column D is zero then return the...

I'm completely stumped on my current formula issue. No matter how I try and manipulate the data the result still ends the same with the dreaded #NA error. Worksheet 1: D E...

I have a pivot table and I have two numerical fields call enrol and total. I want to create a % of enrol by dividing enrol by total. Which is fine, but if enrol or total has 0, then #value is being returned. Rows in the Pivot Table is Location and columns has Main. I've tried the following...

Hi everyone, and thanks in advance. Looking for a formula that depending on the status selected (3 statuses available), calculates an employees FTE (0 to 1.0). 3 statuses are Active, Terminated and LOA (Leave of Absence). Format shown below: Let me know if I've missed anything critical...

Hi Team, This one is a bit complex, I've been working for a bit on it today but nothing seems to work. I am working in Excel 2016. Ideally I am looking at having two sheets, the first one which is the input sheet which shows the results of the second sheet import. The import sheet is data I...

I've looked around and have tried other solutions I've seen posted for similar questions but none have worked completely. This is a sample of the data. Formula for day hours currently is: =MAX(,MIN(D2,IF(B2<A2,1,)+B2)-MAX(A2,C2)) Night hours: =E2-F2 It appears to work in all day shift start...

Hello, im having a problem with my formula, i wanted multiple condition, and multiple result, here is what i got for now. Formula : =IF(C6="BADRUN",7000,IF(C6<>"BADRUN",8000,IF(RIGHT(C6,1)="E",12000,IF(RIGHT(C6,1)="C",5000)))) im putting this formula at "KILOAN" - "HARGA" My condition, if...

Picture 1: Picture 2: Hi, How can i convert concated formula in (Picture 1) into real formula so that it can call the data and change according to the choosen month and year (Picture 2). I tried INDIRECT with the concated but got reference error. Any help is much appreciated. Thank you

Hello helpful people! Here is my dilemma. I have a workbook that has a summary {Summary} page and ten worksheets {Employer #1, Employer #2, etc.} with specific data. Based on a Yes/No answer on the Employer sheets, I need data from two specific cells {B11 and F16} to transfer to a specific...

Hi guys, I've been trying to find a way to adopt conditional formatting for a cell which contains today's date. I've been able to do this successfully, but if I include other text in the cell (for example, a time - see image attached), the conditional formatting does not work. What would be...

I am trying to create a formula to find out if a certain word appears more than one time in a column with criteria. I have a PO# in column A and in column B the words DROP or MISC appear. I am trying to find out if the word DROP appears more than once for each PO#. I am currently using the...

Hi, like title says i need to take every 4 rows to average them and this average data put into 4 rows as a specific single result. I tried my formula in tab.1 but didnt work. My data needs to looks like tab2. Btw table2 continues to 175 000 rows.Can someone help me what i doing wrong? Thanks for...

Hi there, I am quite new to excel and currently have a list of times like this below for a timetable schedule. I am looking to have a formula that applies different iterations between each cell below depending on whether it is peak or off-peak hours. Peak hours = 7:30am to 9AM and 4:30PM to...

5/1/24, months of hand aren't even, 8.9, 4.6, 4.8. I can load 2 containers of widgets, with a max qty of units of 9,600,000. I need my months of inventory to be equal in 6/1/24. What formula do I use based on monthly avg, to fill the containers, yet not exceed 9,600,000 so that in 6/1, months is...

Is there a quick way to remove duplicates in a append formula? When I insert the formula in column E I get duplicates. =A1 & ", " & B1 & ", " & C1 I would like for column E to show Blue,Red for row 1 and Blue,Red,Green for row 2 thus removing the duplicates Thanks

Hi. I have following Command Button which executed following code in order to remove empty line breaks from a given cell: Private Sub CommandButton1_Click() Cells(24, "M").Select Selection.Replace What:="" & Chr(10) & "" & Chr(10) & "", Replacement:="" & Chr(10) & "" End Sub The problem...

Hello I am looking to find duplicates with a three column criteria: In this case, I want a formula to return TRUE for Channel 1, Video 1, Date 1/1/2000, because it had duplicates for the same row in these 3 different columns Channel Name Date Result Channel 1 Video 1 1/1/2000 TRUE...

Greetings, Ok so I'm trying to go from A to B....Need to split the data in the email address column, THEN, create additional line item.. Not sure if a formula would work, might have to try VBA...Please Help A Profile ID Request Type Change Type Email Address 1 Notification Yellow...

Hey Everyone, Sorry for the silly question but can someone help me with the VBA version of this formula: =IF($E13=TRUE,$B13,"") Basically I don't want to put the formula directly in the cell where it can be overwritten, I also need it to apply to all rows (columns are fixed). All this does...

I've written the following sub, but when i run it, it doesn't populate A1 and A2 with 2 as one would expect, but instead just places the formulas in the cells as text Sub Test() Dim dummyArr(0 To 1, 1 To 1) As String dummyArr(0, 1) = "=1+1" dummyArr(1, 1) = "=1+1"...