Recent content by mala

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.

Try =IF(MIN(B17:D17)=B17,B6,"")&IF(MIN(B17:D17)=C17,C6,"")&IF(MIN(B17:D17)=D17,D6,"") It'll work!!

Linking of cells applies to data only - it is not possible to directly link comments in Excel - you have to comment the cells individually.

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