KennyO’s Activity

Wed Dec 17

NL

Boards Post

KennyO replied to the Spreadsheet Advice board. 1:40 PM

Re: Location of a value in a worksheet

Thank you! My little list of Excel "try-em" functions and VBA is filling up. Between the holidays I'll spend a day to go through them. That's a recreational day for me but my wife says I'm nuts. Beats shoveling snow, though, [more]

NL

Boards Post

KennyO replied to the Spreadsheet Advice board. 1:57 AM

Re: Location of a value in a worksheet

rharmelink's INDEX() function does the deed I need, thanks. I'd used that function just once before, many years ago, so it simply didn't come to mind.

Radish, you're right, MATCH() returns #N/A because of the rectangular range, therefore [more]

Mon Dec 15

NL

Boards Post

KennyO replied to the Spreadsheet Advice board. 2:10 AM

Re: Location of a value in a worksheet

The function =MAX(H9:BL1866) returns the value of the cell with the maximum value in both the Win7 with Office 2007 system at the office and on my Win7 with Office XP here at home. I'm back at the office later this week so I'll try your MAXX VBA over [more]

Sun Dec 14

NL

Boards Post

KennyO posted to the Spreadsheet Advice board. 2:37 PM

Location of a value in a worksheet

We have a large worksheet that is populated with data in the course of a laboratory operation. Incoming values are entered in the cells corresponding to the column and row headings. At the end of the operation the data is tallied and graphed in a [more]

Sat Dec 13

NL

Boards Post

KennyO replied to the Owning Rental Property board. 5:02 PM

Re: Owner finance rental property to renter

Talk to a real estate lawyer before you take any action at all. This is a situation where your obvious lack of knowledge WRT real estate law can effortlessly dig you a costly and permanent hole.

KennyO

Fri Dec 12

NL

Boards Post

KennyO replied to the Ford Motor Company board. 12:46 AM

Re: So Long, Microsoft

I remain unimpressed.

KennyO

NL

Boards Post

KennyO replied to the Mutual Funds board. 12:25 AM

Re: Help understanding the 17% NAV drop for PSPAX

Given that it's December I'll bet they just made the mandatory distribution of dividends and capital gains. You now have either more shares or more cash than you had just before that NAV drop.

KennyO

Thu Dec 4

NL

Boards Post

KennyO replied to the Mutual Funds board. 9:25 PM

Re: Allocation of Mutual Funds in IRA

The very aggressive allocation for someone aged 61 is a bit telling, as is the "ugh" WRT bonds. It may be likely that you'll reach retirement before the market rains on your parade but, retirement being five years out, it's also likely [more]

Mon Nov 17

NL

Boards Post

KennyO replied to the Mutual Funds board. 3:56 PM

Re: Sector mutual fund vs ETF

The December events are distributions of dividends and capital gains. The total value of what you had didn't change but the character of it did: the distribution of cash to you reduced the NAV of your fund shares by the amount of that distribution. [more]

Thu Nov 13

NL

Boards Post

KennyO replied to the Ford Motor Company board. 6:04 PM

Re: Ford Europe Sales Up

Good to hear, particularly the "fifth straight" part.

KennyO

Fri Oct 31

NL

Boards Post

KennyO replied to the Spreadsheet Advice board. 1:04 PM

Re: help with a formula

1. The primary error is because AW needs a row number 2. The carat operator raises the number preceding the operator to the power following it. Much easier to understand than the POWER function. 3. Your given information has loose ends galore. [more]

Tue Sep 23

NL

Boards Post

KennyO replied to the Ford Motor Company board. 12:12 PM

Re: C-Max First Impressions

I'll bet the owner was as unhappy as you were. I'm glad he'll be taking care of you. Let us know if lunch is better than Shakey's Pizza.

KennyO

Sat Sep 20

NL

Boards Post

KennyO replied to the Ford Motor Company board. 2:33 PM

Re: C-Max First Impressions

Of course, most surveys are constructed to give the company the opinions it wants to hear. IMO the worst feature of online surveys is that you don't get to peruse all the questions in advance of answering any of them. You won't know that the deck is [more]

Fri Sep 19

NL

Boards Post

KennyO replied to the Ford Motor Company board. 11:14 PM

Re: C-Max First Impressions

Once you've signed the paperwork you have no leverage. Corporate knows that there will be a certain portion of customers who are unhappy, so griping to them is unlikely to do much. If you get a survey to fill out, by all means, do so. [more]

CAPS Stats & Trivia

CAPS Player Rating 49.74
Player Rank 37729 out of 75071
Score 105.68
Score Change Today -7.93
Accuracy 38.89%
Active Picks 9
Total Picks 19
Best Pick HOG (+257.81)
Worst Pick NAV (-112.28)
Average Score per Pick 5.56
Charms Earned 5
Highest Rated Favorite No Favorites Selected
Go to KennyO’s CAPS page

Boards Stats & Trivia

Big red star, 1000 posts Old School Fool
Board Posts 3676
Recs Received 3776
People who have rec'd these posts 1040
Recs to Posts Ratio (last 30 days) N/A
Threads Started 147
Threads Started Percentage 4.00 %
Most Frequent Board Foolish Collective
Very First Post My Portfolio (6/1/1999)
Percentage of Posts Rec'd 46.22 %
Show KennyO’s 10 Latest Posts