The easiest way is to uncheck the show zeroes in the Excel option.
Regards,
Sam Mathai Chacko
On Thu, Feb 9, 2012 at 6:31 PM, Shaik Waheed wrote:
> Thanks noorain
>
> thats wonderful,
>
> On Thu, Feb 9, 2012 at 6:12 PM, NOORAIN ANSARI
> wrote:
>
>> Dear waheed,
>>
>> It is also possible witho
Thanks noorain
thats wonderful,
On Thu, Feb 9, 2012 at 6:12 PM, NOORAIN ANSARI wrote:
> Dear waheed,
>
> It is also possible without Indirect function..
>
> =IF(ISBLANK(EMP.DATA),"",EMP.DATA)
>
> With ctrl+shift+Enter
>
> On Thu, Feb 9, 2012 at 6:00 PM, Shaik Waheed wrote:
>
>> Thank you Maris
Dear waheed,
It is also possible without Indirect function..
=IF(ISBLANK(EMP.DATA),"",EMP.DATA)
With ctrl+shift+Enter
On Thu, Feb 9, 2012 at 6:00 PM, Shaik Waheed wrote:
> Thank you Maris for ur reply.its working fine.
>
>
> On Thu, Feb 9, 2012 at 5:18 PM, Maries wrote:
>
>> Hi,
>>
Thank you Maris for ur reply.its working fine.
On Thu, Feb 9, 2012 at 5:18 PM, Maries wrote:
> Hi,
>
> Use this formula with CSE.
>
> *=IF(INDIRECT("EMP.DATA")="","",INDIRECT("EMP.DATA"))*
>
> Regards,
>
> MARIES.
>
> On Thu, Feb 9, 2012 at 3:42 PM, Shaik Waheed wrote:
>
>> Hi Experts
Hi,
Use this formula with CSE.
*=IF(INDIRECT("EMP.DATA")="","",INDIRECT("EMP.DATA"))*
Regards,
MARIES.
On Thu, Feb 9, 2012 at 3:42 PM, Shaik Waheed wrote:
> Hi Experts,
>
> I have an excel sheet with defined named ranges. When I am using Indirect
> array formula to capture the named range it
