-
Problem with that approach is that a date format of dd mmmm yyyy returns a G, not Dn, and D6-D9 are time formats.
-
You can do it, but it requires an array formula. You use the * operator for the two conditions, to create an array f 0/1 (range1=value1)*(range2=value2) and then compare 1 against that array to match =MATCH(1,(range1=value1)*(range2=value2),0)
-
See http://blog.contextures.com/archives/2011/05/20/dynamic-dependent-excel-drop-downs/
-
Wouldn't you just change the gap width? BTW, why use Word for invoices, Excel is much better?
-
Can you post the workbooks?
-
With Activesheet lastrow = .Cells(.Rows.Count,"A").End(xlUp).Ro For i = lastrow To 2 If .Cells(i, "A").Value = "failure" Then .Rows(i).Dellete End If Next i End With
-
Simple INDEX/MATCH formulae =INDEX(ODList,MATCH(ODThickness+2*InsulationThickness,ODList,1)+1) =INDEX(IDList,MATCH(ODThickness+2*InsulationThickness,IDList,1)+1)
-
Google Excel data validation, that will help with the time inputs.
-
[quote user="XLer8"]Even have a few Pom's here! [/quote] I know, my daughter is a Pom over there
-
You mean there is more than 1 Kiwi? Nowhere near perfect, but Sub SplitAddress() Dim arr As Variant Dim arrCnt As Long Dim lastrow As Long Dim i As Long Application.ScreenUpdating = False With ActiveSheet .Columns(2).Resize(, 12).Insert .Columns(1).Replace What:=Chr(13), Replacement:="_", SearchOrder:=xlByColumns lastrow = .Cells(.Rows.Count