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
Hi Experts,
I have an excel sheet with defined named ranges. When I am using Indirect
array formula to capture the named range it is showing zeros (0's) in place
of blanks that are available in my named range. Is there any way to get
only blanks as result because i dont want zeros.
Please find th