basically

Hey all, Seems easy but I can't quite get it all together. I'm looking for a way to have this vba used in row J only if there is text in row B. Sub Test1() If (Range("I6").Value = Range("I2").Value Then Range("J6").Value = "Y" End If End Sub Basically having 2 cells (I6 and I2) checked if...

I need to a formula which takes the 00:30 number from the 00:00, the 00:00 from the 00:30 on the next day and so on. Basically I don't want to include the 00:15 or 00:45 in my formula when I take one number from the other. I sure there is an easy way. <colgroup><col></colgroup><tbody>...

I am trying to create a summary page (bill of materials) for items that need to be ordered taking the information from multiple worksheets. Basically if the qty column in any of the worksheets is >0 then we need to populate with the information on the bill of materials page (supplier, part...

I need to get up to speed with formulas, but I'm battling to meet a deadline to draw out key info on a 30,000 row spreadheet. Basically I currently have a formula in U2 as follows: =IF(E2="","In Scope","Out of Scope") I want to expand it do do other things but have no idea where to start...

is there a formula I can use to change the formats of addresses I pulled down in a data dump? I have a ton of addresses that show up like this in Excel: "20 LONESOME DR " I need them to look normal like this: 20 LONESOME DR even with doing a find/replace for the parentheses it...

Hi, so i'm trying to work out a formula but i'm stumped because I don't really know what it does! Basically, I have an old worksheet which successfully uses this formula pointing to a sheet called "Caravaggio"...

I am trying to use Sum Offset to sum a range based on the "offset target value" of cell L4 which is "20" for example. =SUM(OFFSET(M$9,0,$L$4)) However this doesnt work. Basically I would like to sum 20 columns from M$9 starting position. many thanks for your help Andrew

Hi, i have a spreadsheet with 4 columns with headings and many lines. Each line per column contains either a Y or a N, ie Col1-N, Col2-Y, Col3-Y, Col4-N. I'm trying to determine (total) across all 4 columns how many lines contains ALL-Y and/or Col1&2-Y or Col2,3-Y or All Columns = N, etc. The 4...

I'm trying to create a warning formula to tell me if C2 is within 2.25 of the value of A2 divided by 2. I think it will be an IF AND combination but could be wrong. To explain further here is an example; if A2 is 110 and C2 is any number equal to or between 52.75 and 57.25; basically if C2...

Hi all, New to the forum and couldn't find anything on this one. I have the following basic average formula that I need to add some sort of IF to. =AVERAGE(I3,I8,I13,I21,I27) Goal is to take the above and only include cells that = 100% in cells E8, E13, E21, E27. Basically, I only want...

So I have values such as "SAW", "BP", "MILL", "LATHE" in the range of G2:O250 in WORKSHEET1. What I want to do is create a new worksheet tab called "SAW" & have it import the any row from A:O on WORKSHEET1 that has that has the cell value of "SAW"in it. This will basically show me all jobs...

I'm trying to come up with a formula that gives TRUE if the reference cells have 0 or 90 as the value. I tried =IF(OR(CSV!Z5=0,CSV!Z5=90,CSV!AA5=0,CSV!AA5=90),TRUE,FALSE) but it doesn't seem to be working - or at least it's not giving me the results I need. Basically, I want it to tell me...

Hi everyone, Been a while since I posted.. but need some help please. I would like to rename / remove all non letters/numbers in a name file basically remove all symbols from it. in a given folder on the computer.. Anyone help please.. Thank you in advance :)

are they basically the same ?

I am not good at VBA but usually fumble my way through. Trying to translate this which works if I simply paste it into a Cell =FLOOR(D11*3,1)&" Days and "&TEXT(SUM(D11,-TIME(8,0,0)*FLOOR(D11*3,1))," h") & " Hours " & MINUTE(A1) & " Minutes "& SECOND(D11) & " Seconds" Into This for my VBA - &...

Hi, I am creating a Index/Match formula that requires certain criteria to be met. I have tried both index and match as well as a vlookup but what I have keeps returning #Ref error. A screenshot of my sheet is here: http://tinypic.com/r/ncha0x/9 Basically I want the formula in the yellow box...

Hi, Is there a possible formula for this? I have been going throug SUMIF's and SUMPRODUCTS but both seem to be for a positive criteria. I am trying to get a formula that would basically be: If Column C is not equal to "Complete" then Add columd D = AB + Column E =CD Thanks

Hi all, Little hard to explain, I Will add an image to show the sort of array I am working on: So each column contains omly the duplicate values. Each row will contain the letters correlating to each number, with blanks if that number has no link to a specific letter.

I posted this up a few minutes ago, but for some reason the post fails when you click on it...I didn't put anything spurious in there...very strange I'm basically able to do a VLOOKUP in VBA using: filetype = Application.WorksheetFunction.VLookup(filename...

Hi all I am looking for pointers on how to write a code to copy data from IE to Excel and then from excel into another program. Basically I need to copy a reference number from IE then paste this into excel and then copy into another program. If possible I would like the code or pointer to...