This is kind of a hack, but you could do this: Paste both columns into the same column (A). Sort column A. Create a new column (B) beside it and put the formula =IF(A2=A1, "", A2), and drag down. This will print out the word only if it is different...
This is simply what you want Remove Blanks. Credits to Oscar Cronquist. If the link is somehow broken, you use this formula in B1. Copy or auto-fill to other cells. Change the range to suit. =IFERROR(INDEX($A$1:$A$30, SMALL(IF(ISBLANK($A$1:$A$30), "", ROW($A$1:$A$30)-MIN(ROW($A$1:$A$30))+1), ROW(A1))),"") This is an array formula entered by Ctrl+Shift+Enter. Edit1: ISERROR...
You could declare a String, and construct the string to display the characters. Something like, Dim tmpRes As String If Len(res1) > 0 Then _ tmpRes = tmpRes & res1 & vbCrLf If Len(res2) > 0 Then _ tmpRes = tmpRes & res2 & vbCrLf If Len(res3) > 0 Then...
vba,excel-vba,ms-word,word-vba,excel-2003
Your idea is a good one but this is what you might use when the application you want to send information to does not "allow access". The good thing about MS Office is you do get to automate it. So I would suggest you automate Word from your Excel. First...
excel,vba,excel-vba,excel-2003
The problem comes when the ranges aren't the same size. You should resize appropriately: With Workbooks(strFile).Sheets(strSource).UsedRange ThisWorkbook.Sheets(strTarget).UsedRange.Resize(.Rows.count, .Columns.count).Value = .Value End With It's probably safer to clear the target sheet first using: ThisWorkbook.Sheets(strTarget).UsedRange.ClearContents ...
excel,vba,excel-vba,vlookup,excel-2003
That isn't hard at all. Since you have a nice layout especially and the values actually match up from sheet to sheet, it makes it very easy. Here is the flow: Loop through the rows on Sheet1 Get the Temp Day. Loop through the columns on that row. Assign the...
c#,excel-2007,compatibility,excel-2003,excel-interop
Found a solution! within vs2013, they offer excel 2007 addin, within that predefined interoperability, there is a way to create a file from a template, the part that was throwing me off was the part of the parameters which shows: "Type.missing". an example of this code structure would be as...
You did it correctly. However ISBLANK function fails because the data you're working with are not really blank but zero length strings.So ISBLANK always evaluates to FALSE and thus just mimics how your data is arranged. To make the formula work, replace your ISBLANK formula IF(ISBLANK($E$5:$E$80),"",ROW($E$5:$E$80)-MIN(ROW($E$5:$E$80))+1) with below formula: IF(E$5:E$80<>"",ROW(E$5:E$80)-MIN(ROW(E$5:E$80))+1,"")...
variables,excel-vba,excel-2003
Here's a possible formula-based solution: Once you've filled down the formula you can copy/paste values. In VBA: Sub Tester() Dim rowToTest As Long, header As String, sht As Worksheet Dim lastRow As Long, rw As Range Set sht = ActiveSheet lastRow = sht.Cells(Rows.Count, 1).End(xlUp).Row header = "" For rowToTest =...
vba,macros,excel-2003,delete-row
I'm all about brevity. Sub DeleteRowBasedOnCriteria() Dim RowToTest As Long For RowToTest = Cells(Rows.Count, 4).End(xlUp).Row To 2 Step -1 With Cells(RowToTest, 4) If .Value <> "VFIRE" _ And .Value <> "ILBURN" _ And .Value <> "SMOKEA" _ And .Value <> "ST3" _ And .Value <> "TA1PED" _ And .Value <>...
Excel 2007 and higher: =COUNTIFS(A2:A17,"4/13",B2:B17,"") Excel 2003 and lower: =SUMPRODUCT(--(A2:A17=--"4/13/2014"),--(B2:B17="")) ...