# Search:

Page 1 of 5 1

1. ## Thread: length of formula

Replies
3
Views
274

### Or you could set up a small table elsewhere and...

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

Replies
5
Views
479

### Farewell and Thanks

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...
3. ## Thread: Sumproduct Problem (2003)

Replies
5
Views
304

### Re: Sumproduct Problem (2003)

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...
4. ## Thread: Sumproduct Problem (2003)

Replies
5
Views
304

### Re: Sumproduct Problem (2003)

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
...
5. ## Thread: Excel for Mac--Incredibly Slow? (2004)

Replies
3
Views
346

### Re: Excel for Mac--Incredibly Slow? (2004)

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....
6. ## Thread: Using Macros to format a pivot table (2003 SP2)

Replies
6
Views
522

### Re: Using Macros to format a pivot table (2003 SP2

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...
7. ## Thread: Formatting ColorIndex (2003)

Replies
3
Views
242

### Re: Formatting ColorIndex (2003)

EDIT: Finally figured out how to format the code. This sets up a table with each color and the number on the palette.
8. ## Thread: Formatting ColorIndex (2003)

Replies
3
Views
242

### Re: Formatting ColorIndex (2003)

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...
9. ## Thread: Reviewing Toolbar (2002 SP3)

Replies
3
Views
230

### Re: Reviewing Toolbar (2002 SP3)

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()
...
10. ## Thread: Macro for conditional formatting, ranking, etc. (Excel 2003)

Replies
5
Views
855

### Re: Macro for conditional formatting, ranking, etc. (Excel 2003)

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...

Replies
6
Views
300

12. ## Thread: fake Access in Excel (2000+)

Replies
24
Views
742

### Re: fake Access in Excel (2000+)

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...
13. ## Thread: weird numbers (XP)

Replies
2
Views
232

### Re: weird numbers (XP)

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...
14. ## Thread: Setting Range? (Excel 2003)

Replies
11
Views
480

### Re: Setting Range? (Excel 2003)

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

Thanks
15. ## Thread: Vlookup to the left... (Two double zero three)

Replies
8
Views
323

### Re: Vlookup to the left... (Two double zero three)

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...
16. ## Thread: 2 Q's on a chart (Excel 2002)

Replies
15
Views
473

### Re: 2 Q's on a chart (Excel 2002)

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.
...
17. ## Thread: Drop Down List Question (Excel 2003)

Replies
8
Views
1,539

### Re: Drop Down List Question (Excel 2003)

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.
18. ## Thread: Extract Text ? (Excel 2002)

Replies
11
Views
407

### Re: Extract Text ? (Excel 2002)

I think it comes from J. Walkenbach.

I know I use it frequently.
19. ## Thread: Extract Text ? (Excel 2002)

Replies
11
Views
407

### Re: Extract Text ? (Excel 2002)

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("...
20. ## Thread: Row Conditional Formatting (2002)

Replies
4
Views
210

### Re: Row Conditional Formatting (2002)

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...
21. ## Thread: How does conditional formatting work? (2003)

Replies
4
Views
389

### Re: Please see the Attached (2003)

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).
...
22. ## Thread: Merged Cells (2000)

Replies
6
Views
506

### Re: Merged Cells (2000)

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...
23. ## Thread: VBA Calculations (Excel 2K)

Replies
11
Views
458

### Re: VBA Calculations (Excel 2K)

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

Range("H1").AutoFill Destination:=Range("H1:H" & Range("G65536").End(xlUp).Row)
24. ## Thread: Excel Worksheet to PPT (Office XP)

Replies
7
Views
449

### Re: Excel Worksheet to PPT (Office XP)

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...