Search:

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

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

Ken

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

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

Ken

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

Here's an array formula that will find the last "/" no matter how many owners. Enter using Ctrl-Shift plus Enter
...

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

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

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

Ken

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

Fred

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

Ken

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

Thank you!

Ken

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

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

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

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

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

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

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

Thanks Hans! Works Great.!

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

Thanks. I thought it would be something simple. Duh.

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

Explanation in attachment.

Happy Thanksgiving!