Search:

Type: Posts; User: kjktoo; Keyword(s):

Page 1 of 5 1

1. Thread: SUMPRODUCT PROBLEM (XL2K SR1)

by kjktoo
Replies
7
Views
386

Re: SUMPRODUCT PROBLEM (XL2K SR1)

Great solution, Hans. I didn't even think to use SUMIF for this. Funny thing is that I was playing around with the problem today, and came across a solution using LOOKUP instead of VLOOKUP or...
2. Thread: SUMPRODUCT PROBLEM (XL2K SR1)

by kjktoo
Replies
7
Views
386

Re: SUMPRODUCT PROBLEM (XL2K SR1)

Thanks to all for the input. Looks like I'll be using an intermediate column.

Ken
3. Thread: SUMPRODUCT PROBLEM (XL2K SR1)

by kjktoo
Replies
7
Views
386

SUMPRODUCT PROBLEM (XL2K SR1)

I'm having a problem with a sumproduct formula where I want to cross multiply two arrays. The first array is a range of six cells. The second is a six element array created with the offset command....
4. Thread: VBA UDF question (xl2k sr1)

by kjktoo
Replies
4
Views
382

Re: VBA UDF question (xl2k sr1)

Thanks Jezza, Rory, and Hans. Got lots of options now.

Ken
5. Thread: VBA UDF question (xl2k sr1)

by kjktoo
Replies
4
Views
382

VBA UDF question (xl2k sr1)

I have a UDF in my personal.xls. I wanted to call it from a module in another workbook, but couldn't figure out a syntax to make it work. How is this done?

Thanks,
Ken

by kjktoo
Replies
14
Views
561

Re: Trim-Parse troubleshoot (2003)

Here's an array formula that will find the last "/" no matter how many owners. Enter using Ctrl-Shift plus Enter
...
7. Thread: Excel number formatting trick (2000 sr1)

by kjktoo
Replies
1
Views
265

Excel number formatting trick (2000 sr1)

If you've ever wanted to or had to duplicate a paper form in Excel you are probably aware of how frustrating Excel's number formatting is when the cell is too narrow to hold the number (#####). You...

by kjktoo
Replies
15
Views
552

Re: Linking Question (Excel 2003 SP1)

An alternative would be to enter an apostrophe in the blank linked cell which forces excel to see null text.

by kjktoo
Replies
12
Views
822

for my verson of Excel (2000) if I append /e to the command in the shortcut Excel opens with no workbook.

Ken
10. Thread: =sum in variable (2003)

by kjktoo
Replies
6
Views
260

Re: =sum in variable (2003)

Here's a more generic version that I assigned a hot key to. Just select any group of cells, hit the hot key and paste the sum where you will.

Sub SelectionSumCopy()
'may need to create and...
11. Thread: Lookup 'close' to next row (any)

by kjktoo
Replies
14
Views
355

Re: Lookup 'close' to next row (any)

Fred

Here is a version with conditional formatting that highlights only grades just below the threshold of a higher grade.

Ken
12. Thread: File not saved (XL2000 SR-1)

by kjktoo
Replies
1
Views
160

File not saved (XL2000 SR-1)

Last night my wife opened an Excel file and made extensive changes to it. When she tried to save her work, she kept getting a message "File not saved." We were unable to save this file into any...

by kjktoo
Replies
2
Views
303

Thank you!

Ken
14. Thread: Lease Calculation (Exel 2000 sr1)

by kjktoo
Replies
2
Views
303

Lease Calculation (Exel 2000 sr1)

Hello. I've attached a SS with two lease proposals. I created an amortization table for each proposal and calculated the interest rate using Goal Seek.

I then calculated the interest rate using...
15. Thread: Eliminate Error Messages (Excel 2003)

by kjktoo
Replies
2
Views
355

Re: Eliminate Error Messages (Excel 2003)

See if this VBA subroutine will help.
AddISERROR will take a formula and wrap "=IF(ISERROR(FORMULA),"",FORMULA)" if there is no ISERROR already in the formula. If you have a really long formula...

by kjktoo
Replies
3
Views
226

Re: Upgrade 97 to XP Problem (Office XP)

Folluwup:
I emailed a copy of the troublesome template to MIS who checked it on his machine using the same printer driver as I had and he did not have a problem printing. Then, later I came across...

by kjktoo
Replies
3
Views
226

Upgrade 97 to XP Problem (Office XP)

I was upgraded by MIS today from Office 97 to Office XP. I have a journal entry template I have been using successfully for several years under XL97. Now with XP the Page Setup Scaling option "Fit...
18. Thread: Pasting Text (xl2000 sr1)

by kjktoo
Replies
5
Views
309

Re: Pasting Text (xl2000 sr1)

Indeed a more elegant solution. The problem is that the delimiter is (as far as I can tell, and I'm no expert in VBA) a "sticky" argument, but not an accessible property. If there's a way to do...
19. Thread: Pasting Text (xl2000 sr1)

by kjktoo
Replies
5
Views
309

Re: Pasting Text (xl2000 sr1)

Thank you for the response. Seems the retention of TextToColumns delimiter characters is another MS feature that can be a nuisance. To resolve the problem I decided to use the principle that a...
20. Thread: Pasting Text (xl2000 sr1)

by kjktoo
Replies
5
Views
309

Pasting Text (xl2000 sr1)

I have this handy macro that sums selected cells and puts the total into the clipboard using a shortcut key.:

Sub SelectionSumCopy()
Dim MyData As DataObject
Set MyData = New DataObject...
21. Thread: Extract Trendline Equation (2000 sr1)

by kjktoo
Replies
4
Views
505

Re: Extract Trendline Equation (2000 sr1)

Thanks Hans! Works Great.!
22. Thread: Extract Trendline Equation (2000 sr1)

by kjktoo
Replies
4
Views
505

Extract Trendline Equation (2000 sr1)

I have an XY scatterpoint graph with a logarithmic trendline. The trendline equation is displayed in this form:

y = a*ln(x) + b

How can I, using either functions or VBA, get the "a" and "b"...
23. Thread: Fiscal years and pivot tables (Excel 2000)

by kjktoo
Replies
2
Views
207

Re: Fiscal years and pivot tables (Excel 2000)

Thanks. I thought it would be something simple. Duh.
24. Thread: Fiscal years and pivot tables (Excel 2000)

by kjktoo
Replies
2
Views
207

Fiscal years and pivot tables (Excel 2000)

I deal with many budgets that are on an Oct 1 to Sep 30 fiscal year. When I pull a a database of accounts and monthly balances into a pivot table, the month columns appear in the correct order, that...

by kjktoo
Replies
20
Views
833

Re: Conditional Summing (2000)

Explanation in attachment.

Happy Thanksgiving!
Results 1 to 25 of 102
Page 1 of 5 1