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