Recent content by wrbnoh

Thanks Skip

=INDEX($B$1:$G$1,1,MATCH((LARGE($B2:$G2,1)),$B2:$F2,0)) Is the winner. Thanks all.

a b c d e f g h i 1 2000 1999 1998 1997 1996 1995 High Sales HS Yr 2 apple 50 20 10 30 60 40 60 ? 3 pear 10 80 90 30 20...

"How did you get the VALUE?" I used the @Large function. "Where do you want the COLUMN HEADING returned to?" Example: Columns C through J contain Sales Figures Column K contains the @large value of C:J I want Column L to contain the Column Name Range from the result of...

How can I return the column name range from a row where I have found the highest vaule? Example I have rows of products and columns of years. The data is sales. I have returned the highest sales value and want to return the corresponding year in which those sales occurred.

Try this: 1. Under the View menu go to Header and Footer 2. Choose custom header 3. Choose where you want your picture - left, center or right 4. Choose the picture icon 5. Choose the picture file 6. Click OK 7. Click OK That's it Note: Because the picture is in the header, you won't see it...

I gave you the Star - Blue - you earned it

Jeep, I'm no programming expert either, but based on your information, Blue's suggestion is what you want. IE.. a $5000 asset Purchased on 1/1/99 with a 5 year replacement date of 1/1/2004 @ 4% appreciation per year would result in a replacement cost of $6,083.27 Pur Date Orig Cost Life...

I would like to create a custom user entry form similar to the standard form under "Data" in Excel(r). Actually, I have done this. But, my problem is that when I use the VBA form, for data entry, my formulas for the calulated fields don't automaticly fill. (Example: I have five...