Thanks once again,I am greatful to you.

"Max" wrote:

"TUNGANA KURMA RAJU" wrote:
Thanks Mr.Max, its working fine.

Glad it worked ! (Go easy, pl drop the "Mr" bit <g)

Is there any other way to switchoff display of zero values? ..

We could use an IF construct:
=IF(OFFSET(..)=0,"",OFFSET(..))
to return blanks: "" if the OFFSET returns a zero
(but at an increase to the calc load, of course)

Put instead in M1, and fill across/down:
=IF(OFFSET(INDIRECT("'"&$A$1&"'!A1"),ROWS($A$1:A1)-1,COLUMNS($A$1:A1)-1)=0,"
",OFFSET(INDIRECT("'"&$A$1&"'!A1"),ROWS($A$1:A 1)-1,COLUMNS($A$1:A1)-1))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---