Friends,

I am trying to compare cells of 9 seperate worksheets to evaulate if the
cell is an non-blank and store it in a master sheet. I will then drag and
expand the cell in master and map it with other cells in the 9 sheets.


It is very easy to accomplish using nested if, however excel will allow for
only 7 levels.

the formula is as follows:

=if(isblank('c:\[WBK1.xls]sheet1'!A1), 'c:\[WBK1.xls]sheet1'!A1,

if(isblank('c:\[WBK2.xls]sheet1'!A1), 'c:\[WBK2.xls]sheet1'!A1,
....
....
(isblank('c:\[WBK9.xls]sheet1'!A1), 'c:\[WBK9.xls]sheet1'!A1,


Can anyone suggest an alternative to accomplish this solution.

I think I responded to this yeserday - check your earlier posts.

Pete

On Aug 21, 12:11*pm, Harish Sharma
wrote:
Friends,

I am trying to compare cells of 9 seperate worksheets to evaulate if the
cell is an non-blank and store it in a master sheet. I will then drag and
expand the cell in master and map it with other cells in the 9 sheets.

It is very easy to accomplish using nested if, however excel will allow for
only 7 levels.

the formula is as follows:

=if(isblank('c:\[WBK1.xls]sheet1'!A1), 'c:\[WBK1.xls]sheet1'!A1,

if(isblank('c:\[WBK2.xls]sheet1'!A1), 'c:\[WBK2.xls]sheet1'!A1,
...
...
(isblank('c:\[WBK9.xls]sheet1'!A1), 'c:\[WBK9.xls]sheet1'!A1,

Can anyone suggest an alternative to accomplish this solution.