remove #N/A in excel

aivijardin_09

New Member
Joined
Mar 26, 2010
Messages
37
Hi,

i am using these formula below;

=IF(ISERROR(VLOOKUP(A2,Sheet2!A:F,2,FALSE)),
VLOOKUP(B2,Sheet2!A:F,2,FALSE),VLOOKUP(A2,Sheet2!A:F,2,FALSE))

sheet 1
<table style="border-collapse: collapse; width: 375pt;" border="0" cellpadding="0" cellspacing="0" width="500"><col style="width: 48pt;" width="64"> <col style="width: 87pt;" width="116"> <col style="width: 48pt;" width="64" span="5"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 48pt;" width="64" height="20">Item</td> <td class="xl64" style="border-left: medium none; width: 87pt;" width="116">Alternative Items</td> <td class="xl65" style="border-left: medium none; width: 48pt;" width="64">Jun-09</td> <td class="xl65" style="border-left: medium none; width: 48pt;" width="64">Jul-09</td> <td class="xl65" style="border-left: medium none; width: 48pt;" width="64">Aug-09</td> <td class="xl65" style="border-left: medium none; width: 48pt;" width="64">Sep-09</td> <td class="xl65" style="border-left: medium none; width: 48pt;" width="64">Oct-09</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="border-top: medium none; height: 15pt;" height="20">12345</td> <td class="xl63" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="border-top: medium none; height: 15pt;" height="20">12398</td> <td class="xl63" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="border-top: medium none; height: 15pt;" height="20">12455</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">45678</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="border-top: medium none; height: 15pt;" height="20">004A166</td> <td class="xl63" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="border-top: medium none; height: 15pt;" height="20">004A167</td> <td class="xl63" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="border-top: medium none; height: 15pt;" height="20">00510R0810</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">510R081</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="border-top: medium none; height: 15pt;" height="20">00675R0140</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">675R014</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0</td> </tr> </tbody></table>
sheet 2
<table style="border-collapse: collapse; width: 299pt;" border="0" cellpadding="0" cellspacing="0" width="398"><col style="width: 59pt;" width="78"> <col style="width: 48pt;" width="64" span="5"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; width: 59pt;" width="78" height="20">Item</td> <td class="xl67" style="border-left: medium none; width: 48pt;" width="64">Jun-09</td> <td class="xl67" style="border-left: medium none; width: 48pt;" width="64">Jul-09</td> <td class="xl67" style="border-left: medium none; width: 48pt;" width="64">Aug-09</td> <td class="xl67" style="border-left: medium none; width: 48pt;" width="64">Sep-09</td> <td class="xl67" style="border-left: medium none; width: 48pt;" width="64">Oct-09</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="border-top: medium none; height: 15pt;" height="20">12345</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="border-top: medium none; height: 15pt;" height="20">12378</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="border-top: medium none; height: 15pt;" height="20">45678</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">0</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="border-top: medium none; height: 15pt;" height="20">004A166</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="border-top: medium none; height: 15pt;" height="20">004A167</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="border-top: medium none; height: 15pt;" height="20">510R081</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">0</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="border-top: medium none; height: 15pt;" height="20">675R014</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">0</td> </tr> </tbody></table>

how can i remove the #N/A without using Replace?

Thanks
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
As the #N/A is the result of a formula, Replace wouldnt work anyway.

As the "true" part of your Iserror() function, return 0 if the formula evaluates to an error.
 
Upvote 0
If the formula is expected to return a number, try on Excel versions prior to 2007...

Code:
=LOOKUP(9.99999999999999E+307,CHOOSE({1,2,3},0,
    VLOOKUP(B2,Sheet2!A:F,2,0),VLOOKUP(A2,Sheet2!A:F,2,0)))

If so desired, custom format the formula cell as:

[=0]"";General
 
Upvote 0
Hi Aladin,

i tried the formula you gave.
lookup(9.99999999999999E+307,CHOOSE((1,2,3,),0,VLOOKUP(B2,Sheet2!A:F,2,0),VLOOKUP(Sheet1!A2,Sheet2!A:F,2,0)))

there is an error that say

"The formula that you typed contains an error."

Is there another formula that you can recommend?

thanks,
 
Upvote 0
Your original formula basically says that if it can't find A2 in your lookup table, then try looking up B2.

So the only time you would be getting #N/As is if it cannot find B2 in your lookup table either.

Someone will probably add something less cumbersome but you should be able to add another error trap inside your error trap.

=IF(ISERROR(VLOOKUP(A2,Sheet2!A:F,2,FALSE)),
IF(ISERROR(VLOOKUP(B2,Sheet2!A:F,2,FALSE)),"ERROR",VLOOKUP(B2,Sheet2!A:F,2,FALSE)),VLOOKUP(A2,Sheet2!A:F,2,FALSE))

Should return the text string of "Error" when neither A2 or B2 appear in your lookup tables. Much easier to replace. Or you can make it return blank ("") or whatever you like.
 
Upvote 0
Hi Aladin,

i tried the formula you gave.
lookup(9.99999999999999E+307,CHOOSE((1,2,3,),0,VLOOKUP(B2,Sheet2!A:F,2,0),VLOOKUP(Sheet1!A2,Sheet2!A:F,2,0)))

there is an error that say

"The formula that you typed contains an error."

Is there another formula that you can recommend?

thanks,

It's {1,2,3}, not (1,2,3,) as you have it... Thus:

=LOOKUP(9.99999999999999E+307,CHOOSE({1,2,3},0,VLOOKUP(B2,Sheet2!A:F,2,0),VLOOKUP(Sheet1!A2,Sheet2!A:F,2,0)))
 
Upvote 0
hi Beezkneez,

i tried your formula there is an error that says "you've entered to many arguments for this function".

what should i do?

Sorry i'm not that good in excel.

Thanks.
 
Upvote 0
hi yogeshmaney,

i used the formula below;

=IF(ISERROR(VLOOKUP(A2,Sheet2!A:F,2,FALSE)),"",VLOOKUP(B2,Sheet2!A:F,2,FALSE))

and the result is this (i used the formula in Jun-09 only);

<table style="border-collapse: collapse; width: 375pt;" border="0" cellpadding="0" cellspacing="0" width="500"><col style="width: 48pt;" width="64"> <col style="width: 87pt;" width="116"> <col style="width: 48pt;" width="64" span="5"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl64" style="height: 15pt; width: 48pt;" width="64" height="20">Item</td> <td class="xl64" style="border-left: medium none; width: 87pt;" width="116">Alternative Items</td> <td class="xl65" style="border-left: medium none; width: 48pt;" width="64">Jun-09</td> <td class="xl65" style="border-left: medium none; width: 48pt;" width="64">Jul-09</td> <td class="xl65" style="border-left: medium none; width: 48pt;" width="64">Aug-09</td> <td class="xl65" style="border-left: medium none; width: 48pt;" width="64">Sep-09</td> <td class="xl65" style="border-left: medium none; width: 48pt;" width="64">Oct-09</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="border-top: medium none; height: 15pt;" height="20">12345</td> <td class="xl63" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl63" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="border-top: medium none; height: 15pt;" height="20">12398</td> <td class="xl63" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl63" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="border-top: medium none; height: 15pt;" height="20">12455</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">45678</td> <td class="xl63" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="border-top: medium none; height: 15pt;" height="20">004A166</td> <td class="xl63" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl63" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="border-top: medium none; height: 15pt;" height="20">004A167</td> <td class="xl63" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl63" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="center">#N/A</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="border-top: medium none; height: 15pt;" height="20">00510R0810</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">510R081</td> <td class="xl63" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl63" style="border-top: medium none; height: 15pt;" height="20">00675R0140</td> <td class="xl63" style="border-top: medium none; border-left: medium none;">675R014</td> <td class="xl63" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl63" style="border-top: medium none; border-left: medium none;" align="right">0</td> </tr> </tbody></table>
but when i added a value on sheet 2 (see below table), the item 12455 should have a value of 12. there should be a value in Jun-09 which is 12.

<table style="border-collapse: collapse; width: 299pt;" border="0" cellpadding="0" cellspacing="0" width="398"><col style="width: 59pt;" width="78"> <col style="width: 48pt;" width="64" span="5"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl66" style="height: 15pt; width: 59pt;" width="78" height="20">Item</td> <td class="xl67" style="border-left: medium none; width: 48pt;" width="64">Jun-09</td> <td class="xl67" style="border-left: medium none; width: 48pt;" width="64">Jul-09</td> <td class="xl67" style="border-left: medium none; width: 48pt;" width="64">Aug-09</td> <td class="xl67" style="border-left: medium none; width: 48pt;" width="64">Sep-09</td> <td class="xl67" style="border-left: medium none; width: 48pt;" width="64">Oct-09</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="border-top: medium none; height: 15pt;" height="20">12345</td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="border-top: medium none; height: 15pt;" height="20">12378</td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="border-top: medium none; height: 15pt;" height="20">45678</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">12</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">0</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="border-top: medium none; height: 15pt;" height="20">004A166</td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="border-top: medium none; height: 15pt;" height="20">004A167</td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl65" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="border-top: medium none; height: 15pt;" height="20">510R081</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">0</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="border-top: medium none; height: 15pt;" height="20">675R014</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">0</td> <td class="xl65" style="border-top: medium none; border-left: medium none;" align="right">0</td> </tr> </tbody></table>
thanks,
aivi
 
Upvote 0
your formula:
=IF(ISERROR(VLOOKUP(A2,Sheet2!A:F,2,FALSE)),"",VLOOKUP(B2,Sheet2!A:F,2,FALSE))

says if there's an error looking for A2, then try B2. So you need to capture an error looking for B2, as well:


=IF(ISERROR(VLOOKUP(A2,Sheet2!A:F,2,FALSE)),"",IF(ISERROR(VLOOKUP(B2,Sheet2!A:F,2,FALSE)),"",VLOOKUP(B2,Sheet2!A:F,2,FALSE)))
 
Upvote 0

Forum statistics

Threads
1,213,506
Messages
6,114,027
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top