Search results

Take a look at http://xldynamic.com/source/xld.xlFAQ0004.html

Can you illustrate what you mean with an example or two?

As an aside, when you upgrade, insist on 2010, 2007 is a waste of time and energy.

You need to coerce the True/False values to numbers =SUM(--(A1:A4=A3)) But there is no need for an array formula, you can simply use COUNTIF =COUNTIF(A1:A4,A3)

So it is CF or is it not CF? Your last post made no sense to me.

Select the source range, then click the format painter button (the paintbrush) and select the target range.

Try this array formula =AVERAGE(IF((rng<>MAX(rng))*(rng<>MIN(rng)),rng))

How about a UDF Public Function CountDuplicates(rng As Range) As Boolean Dim TextLen As Long Dim WordCount As Long Dim WordLen As Long Dim UniqueWordCount As Long Dim NextWord As String Dim coll As Collection Dim i As Long TextLen = Len(rng.Value) WordCount = TextLen - Len(Replace(rng.Value...

http://xldynamic.com/source/xld.CFConditions.html shows how to check CF conditions.

Try this =IF(ISNUMBER(FIND("-",A2)),LEFT(A2,FIND("-",A2)-1)+FLOOR((RIGHT(A2,LEN(A2)-FIND("-",A2))-LEFT(A2,FIND("-",A2)-1))/2,1),A2)

Private prevCell As Range Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not prevCell Is Nothing Then If prevCell.Address = "$A$2" Then Call myMacro End If End If Set prevCell = Target End Sub This is worksheet event code. To implement it, select the sheet tab, right...

If you have Excel 2003 as well, it is best to develop and save in 2003, thus ensuring compatibility

Why do you need to unhide them? Do you edit them manually or in code?

Sad?

Normally a class module would be used to abstract a specific part of the design. Say for instance that you wanted to create a custom object that would be used throughout your code. You would create a class with all of the required methods and properties, test this within a simple test harness...

Mine does select the worksheets, which is unnecessary. So, what does it do?

This will be quicker still Sub CLEAN() Dim xLong As Long, csht As Long Application.Calculation = xlCalculationManual Application.ScreenUpdating = False Application.EnableEvents = False With ActiveWorkbook For csht = 1 To .Worksheets.Count With .Worksheets(csht).UsedRange xLong =...

Maybe the code didn't come out too well, it should be Equals single quote single quote double quotes. Us APPL-ID text or numeric?

Dim Appl_ID Appl_ID = Inputbox ("Please enter the Appl_ID") rst.Open "Select * From Table1 where [Table1].[APPL_ID] = ''", cnt

Isn't it just =IF(CTS!H2:DO2=Invoicing Total!C4,SUM(CTS!H3:DO200 ),0)

Create another named range called countries with this data Australia AU Canada CA France FR Germany DE United Kingdom UK United States US and use =IF(ISERROR(VLOOKUP(fl,INDIRECT(VLOOKUP(countryLink,countries,2,FALSE)&"pp"),2,FALSE)),""...

Another try =IF(SUM(A1:F1),SUM(A1:F1),IF(COUNTIF(A1:F1,"A"),"A",IF(COUNTIF(A1:F1,"V"),"V","")))

Try =IF(COUNTIF(A1:F1,"A"),"A",IF(COUNTIF(A1:F1,"V"),"V",SUM(A1:F1)))

The problem is that M46 is trying to sum text values, change M14 (and the rest) to =IF(B14="",B14,IF(B14>0,--"10:00"))

Try using $H$3