Search:

Or you could set up a small table elsewhere and use the LOOKUP function, or for more versatility, INDEX/MATCH combo.

My dream job (totally unexpected but a 30 year dream) recently became a reality, nothing in anlysis or Excel or... I am now President of our Seminary. My primary responsibilities in the first two...

Note, I updated my post after you posted. If possible you can change the headers in row 3, to be the first day of month, then use those as references in your formula.

Then change the formatting to...

Howdy. You can add an IF wrapper around it (simplified) (Sorry, after looking at sheet, you have that)

I changed the SUMPRODUCT, and changed the headers in row 3. This is in G4
...

Office for Mac is always behind the Windows versions. One critical area is VBA for Office 2004, which is based on VB 5 the same as used for XL 97. And with 2008, there will not be any VBA at all....

Howdy. Bill Jelen/Tracy Syrstad published a book, VBA and Macros for Microsoft Excel. One chapter is devoted to VBA and Pivot Tables. They strongly recommend using VBA for Pivot Tables, but creating...

EDIT: Finally figured out how to format the code. This sets up a table with each color and the number on the palette.

Try this code:

<pre>Sub ColorTable()
' variables
Dim i As Integer
Dim j As Integer
Dim k As Integer
Dim sColorOrder As String
Dim sLightColors As String
Dim...

Ah, no that persistent thing is a pain!

I put this one line code and attached to a toolbar button to get rig of it. Or you could assign a keyboard shortcut.

<code>
Sub HideReviewBar()
...

Appreciate the solution Hans.

I wonder, though, what happens with the MIN when one of the top 10 has a zero value. OP didn't indicate one way or the other, but I know that on some projects I have...

Post deleted by shades

I agree, you can setup the connections between the db and Excel. Almost none of our people have Access. I have a four step (with four files) process, with Excel VBA to pull data through EssBase from...

Howdy. In Tools > Options > Edit, the box next to "Fixed decimal" (on left side) should be unchecked. It might be checked and set to 2. This would be your system causing it. When I opened the...

I appreciate this hint on not activating the worksheet. It really is more efficient (and easier to understand).

Thanks

To avoid the "subtract 1" problem, I set up the data with an extra column between row headers and data, and columns headers and data. Then it is automatically adjusted. Then I also include one extra...

In regard to the second, you can use a work around.

Add a row above the data, below the headings. Then put 5 in cell D2. Also, put 5 in cell D7. Then extend the data source from row 2 to row 7.
...

The one time that using the Forms toolbar for this is when you exchange files with the Mac versions of Excel. MS did not include ActiveX support on the Mac versions.

I think it comes from J. Walkenbach.

I know I use it frequently.

For middle name put (checks to see whether there is a middle name):

=IF(ISERR(MID(A1,FIND(" ",A1)+1,IF(ISERR(FIND(" ",A1,FIND(" ",A1)+1)),FIND(" ",A1),FIND(" ",A1,FIND(" ",A1)+1))-FIND("...

I think, if you have already formatted one worksheet, you can select that area, and click on the Format Painter, then select all worksheets as Hans suggested, and click once where the upper left...

And as an occasional visitor, it would be better to title the thread something like "Conditional Formatting" rather than "Please see the Attachment" (which is not very helpful when browsing).
...

Thanks, Hans.

My view on merged cells is that they should be avoided whenever possible. My alternative is to use "Center Across Selection" which effectively does the same, without the negatives of...

For filling all of column H (as far as Column G extends)

Range("H1").AutoFill Destination:=Range("H1:H" & Range("G65536").End(xlUp).Row)

I will try to locate the source of the code, also. [EDIT: I included the links to Jon Peltier's web site). I modified it to use XL2002 rather than XL97.]

Since I use a Mac at home, I tried these...

Here is the corresponding one for charts:
(Source: at the bottom of the page http://peltiertech.com/Excel/XL_PPT.html )
<pre>Sub ChartToPresentation()
' Set a VBE reference to Microsoft PowerPoint...