Interesting problem, Dreamboat
dschomburg,
Excel wil not allow you to specify two ranges residing on different sheets for a single series.
You can try the following workaround:
1. Use two series
2. Series 1 is the 'Months' series. Specify the correct ranges from Sheet2. I presume the no...
Suppose your data is contained in cols. A thru F and the formula in col G. I presume the fistrow contains field headers. Let this be in a sheet called "MySht"
Insert a module in the VBA project of the Workbook and enter the following module
Let the name of the formula be 'MyFormula' -...
if divisibility by 1000 is what u're looking for u can simply use the condition:
if(right(x,3)="000",val1,val2)
This is a beautiful feature Excel has - of coercing a number to a string and vice versa depending upon the usage context - try it out.
Hello friends,
I joined the forum today.
A simple way to print non-contiguous ranges is to (either manually or programmatically) copy pictures of the ranges to be printed next to each other on a blank sheet and print the range containing the pictures.
If the configuration of the printing of the...
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.