Hello All,
Thank You very much..
On Mon, Jul 25, 2011 at 12:20 PM, Cab Boose wrote:
> Hi
>
> Get the PUP V3 utility on the J-Walk site. Do all errors on whole sheet
> in one click. Magic.
>
> Charlie
>
>
>
>
>
>
>
> On Mon, Jul 25, 2011 at 6:36 PM, NOORAIN ANSARI
> wrote:
>
>>
>>
>> De
Hi
Get the PUP V3 utility on the J-Walk site. Do all errors on whole sheet in
one click. Magic.
Charlie
On Mon, Jul 25, 2011 at 6:36 PM, NOORAIN ANSARI wrote:
>
>
> Dear Vijay,
>
> Please find Error remover technique.
>
> * Errors-World* Error Type
> Erro
Dear Vijay,
Please find Error remover technique.
* Errors-World* Error Type Error
Remover Functions *ISNA()* *ISREF()* *ISERR()* *ISERROR()* *IFERROR()*
#N/A YES YES NO YES YES #ISREF NO YES YES YES YES #NULL NO YES YES YES YES
#DIV/0! NO YES YE
use formula
=IF(iserror(ur formula),"",ur formula))
On Sun, Jul 24, 2011 at 5:50 PM, vijayajith VA wrote:
> Hi,
>
>
> I have one questions.Usually while doing reports what are errors you will
> get ?
>
>
> Thanks
>
> --
>
> -
1) Duplicate Unique Key
2) Blank Cells
3) Wrong Data/time format
4) Wrong Data Type (Number to String)
5)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of vijayajith VA
Sent: Sunday, July 24, 2011 5:51 PM
To: excel-macros@goo
It depends upon the mistakes u do.
On 7/24/11, vijayajith VA wrote:
> Hi,
>
>
> I have one questions.Usually while doing reports what are errors you will
> get ?
>
>
> Thanks
>
> --
> --
> Some important links for exc
Hi Vijayajith,
It depends which report having what kind of formula / function /
macros you are working on.
I have came across following errors so far:-
1) Excel Function errors -> Can be corrected using ISError function(s)
2) VBA Macros -> Can be prevented using Error handlers
3) Linking errors
http://www.ozgrid.com/Excel/formula-errors.htm
http://chandoo.org/wp/2009/04/20/excel-formula-errors/
On Sun, Jul 24, 2011 at 6:12 PM, Venkat CV wrote:
> Hi Vijay,
>
> In Excel You May get errors are
>
> #NULL!, #DIV/0!, #VALUE!,#REF!,#NAME?, #NUM! and #N/A
> if u want avoid this Tou may us IF
Hi Vijay,
In Excel You May get errors are
#NULL!, #DIV/0!, #VALUE!,#REF!,#NAME?, #NUM! and #N/A
if u want avoid this Tou may us IFERROR or IFERROR ISERROR Function
*Best Regards,*
*Venkat*
On Sun, Jul 24, 2011 at 5:50 PM, vijayajith VA wrote:
> Hi,
>
>
> I have one questions.Usually while do
