statements

I am having an issue with getting this to work. I have tried multiple functions that do various things, match seems to be the best option. I do apologize for my code as it is very sloppy while I work, I tend to go back and clean it up once it is all working. I have noted in the code what it does...

Hello everyone! I have got a excel file that looks the one below: Now I need a loop that check each cell in Column "H", if there is two cells in column "H" that matches each other (in this case Cell 1 and Cell 6). Check in Column "i" if there is any data in any of these cells, remove the cell...

Good morning! I'm so grateful this website is here! I hope someone out there can help me. Based on the table below, I want to create an if/then statement in the cell to the right of the Total cell subtracting all Orange values from Apple values. I know this can be done, just don't know how...

Im trying to find all the max and the min in the data set by the slopes and for some reason my if statement wont work If 0 > ((Cells(i + 1, 2).Value - Cells(i, 2).Value) / (Cells(i + 1, 1).Value - Cells(i, 1).Value)) And 0 < ((Cells(i + 2, 2).Value - Cells(i + 1, 2).Value) / (Cells(i + 2...

Hello All, We use Avaya for our time tracking that records our technicians login/logoff time on the phone. I can get a report that shows their login/logoff punches as well as the total time for that day. My staff has a hard time figuring out 100'ths for minutes which is what Avaya records the...

Hey guys, I have a query based on visual basic coding in Excel. I am creating a user form for a piece of work, and there is a certain bit of the coding I am having an issue with. Here is my coding so far below: Private Sub cmdAdd_Click() 'Copy input values to sheet. Dim lRow As Long...

Hello people, I have made a simple for loop if the value is greater than 0 then do something, but I need add few statements if the value is equal "0" or more then do something here is my code For i = 1 To ActiveSheet.UsedRange.SpecialCells(xlCellTypeLastCell).Row If Cells(x...

Hello all VB Members, I should need help with a code, The thing is I have got a workbook that contains two sheets “Statistics” and “Prices” and I need a function that check for certain values. For each Row in Sheet “Statistics” Check the values in each row for Column H and I and J Example...

How would I combine these 4 IF statements into one? =IF(A2="A",IF(ISNUMBER(MATCH("B",$A$2:$A$21,0)),"B",A2),A2) =IF(B2="D",IF(ISNUMBER(MATCH("E",$A$2:$A$21,0)),"E",B2),B2) =IF(C2="L",IF(ISNUMBER(MATCH("O",$A$2:$A$21,0)),"O",C2),C2) =IF(D2="F",IF(ISNUMBER(MATCH("K",$A$2:$A$21,0)),"K",D2),D2)...

Using Excel 2003 We have a spreadsheet set up showing a list of sales invoices, each invoice has the customer name and a customer reference assigned to it i.e B1, B2 etc We want to set up another sheet that takes the sales invoice information but only picks up that which relates to a...

Hi Hopefully somebody can help me as my eyes are beginning to burn I have been looking at this so long! Basically I am exporting data from another programme in to Excel and need to perform a less than ordinary (for me) VLOOKUP to another workbook. The aim is to look up the value of column H...

Hi All, I've got a single-tab, 30+ column, Excel sheet with numbers (product cost, shipping, retail, etc.). These cells are both manually and simple-formula populated. What I am trying to do is compare the "original" retail price with the actual "sold" price, THEN before populating a...

Hi there, newbie here... Having a nightmare trying to get a if/nesting statement working. Please help - see what i have so far and let me know where im going wrong. =IF(D2>1,15,IF(D2>=30,25,IF(D2>=40,35,IF(D2>=50,45)))) Please help, someone, anyone... Regards Toast

I created a production tracking worksheet (see attachment), that breaks down everything that we want. But we need something visually that shows how far along they are while working. On their desk they have a Standard Production Job Aid (see 2nd tab) that's laminated so they can use it multiple...