"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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.