Search results

What application to save as pdf do you have? WHat version of Excel?

Have you got Excel 2007, or some application for saving as PDF?

Excel protection is notoriously poor, it has always been easy to crack long before Star Office. If you need real security, Excel cannot provide it.

Try this http://www.mediafire.com/file/4chl1cyqn7x3esg/Chandoo%20-%20Secret%20Santa.xlsm

I have many workbooks where I protect the sheets and I protect the project, and I don't need to unprotect it to run macros. I think that is n ot your problem.

Try =A2*24*3600

pls ask a meaningful question

What does the input data look like?

Assuming the city list is in M2:M5, try this array formula =INDEX(M:M,MIN(IF(ISNUMBER(FIND($M$2:$M$5,A2)),ROW($M$2:$M$5))))

Why not add a helper column to work out the distance from zero and use CF on that.

Offset is commonly used to create a dynamic range, that is one that is not statically defined, but grows (and shrinks) as the data grows and shrinks. This is achieved by embedding a function within offset that counts how many items are in the data. For instance...

Put a list of names in say M1:M10 Then, ensure cell A1 is empty and goto Tools>Options and on the Calculation tab check the Iteration checkbox to stop the Circular Reference message. Next, type this formula into cell B1...

PowerPivot only works with Excel 2010, you can't access the reports in 2007 because PP is their data source.

Why not just enter =Sheet2!A1 in B1, and copy down.

You can simplify that formula a tad =K2*(INT(D4/K2)+(MOD(D4,K2)<>0))

Use this array formula as an example =IF(ISERROR(SMALL(IF(Sheet1!$B$2:$B$20>2,ROW(Sheet1!$B$2:$B$20)),ROW(A1))),"", INDEX(Sheet1!$A:$A,SMALL(IF(Sheet1!$B$2:$B$20>2,ROW(Sheet1!$B$2:$B$20)),ROW(A1))))

Assuming you added a new column B for the dates Option Explicit <br /> Private Sub Worksheet_Change(ByVal Target As Range)<br /> Const WS_RANGE As String = "B6:B1000" '<<<< change to suit</p> <p> On Error GoTo...

Can you show the code?

Does conditional formatting with this formula do what you want? =SUMPRODUCT(--($A$2:$A$6=A2),--($E$2:$E$6=E2),--($F$2:$F$6<>F2))=1

Use this array formula for F4 =IF(ISERROR(SMALL(IF($A$4:$A$10=$F$2,ROW($A$4:$A$10)-ROW($A$4)+1),ROW(A1))),"", INDEX(B$4:B$10,SMALL(IF($A$4:$A$10=$F$2,ROW($A$4:$A$10)-ROW($A$4)+1),ROW(A1)))) and copy down and across

Amit, It is not better per se, but if you have a variable column, Cells can take a numeric column, which may be better when assigning via a variable, whereas Range must have a column letter(s).

Amit, Try this Sub CreateLoginDetails() Dim i As Long Dim lps As Long lps = Range("C1").Value For i = lps To 1 Step -1 With ActiveSheet .Range("A" & i).Insert xlShiftDown .Range("A" & i).Formula = "TAG POS=1 TYPE=A ATTR=TXT:Log<SP>Out" .Range("A" & i).Insert xlShiftDown...

Okay, try =SUMPRODUCT(--(LEFT(Sheet2!$A$1:$A$20,LEN(A1))=A1),Sheet2!$B$1:$B$20)

You can use a formula =SUMPRODUCT(--(Sheet1!A1&"."&Sheet1!B1=Sheet2!$A$1:$A$20),Sheet2!$B$1:$B$20)

Try this =INDEX(Sheet2!$C:$C,MATCH(1,(Sheet1!$A$1=Sheet2!$B$1:$B$20)*(Sheet1!$A2=Sheet2!$A$1:$A$20),0)) This is an array formula, so commit with Ctrl-Shift-Enter