Can you recreate this formula using RAND instead of RANDBETWEEN?

F

fishoutofwater

New Member
Joined
Jul 20, 2011
Messages
38
I have this array formula (thanks to the wonderful mr. excel user Yahya-- thanks!)) and I am sure it is exactly what I want. But the problem is that it uses RANDBETWEEN and because I amusing excel2002 I only have RAND and not RANDBETWEEN.

Is there a way to modify this Array Formula so it uses RAND, and not RANDBETWEEN so I can use it with the excel that I have?

#VALUE!
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter these manually yourself

(...and here is the orginal thread that describes what I am trying to acomplish: http://www.mrexcel.com/forum/showthread.php?p=2818694#post2818694 )
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Sort by date Sort by votes
fishoutofwater said:
I have this array formula (thanks to the wonderful mr. excel user Yahya-- thanks!)) and I am sure it is exactly what I want. But the problem is that it uses RANDBETWEEN and because I amusing excel2002 I only have RAND and not RANDBETWEEN.

Is there a way to modify this Array Formula so it uses RAND, and not RANDBETWEEN so I can use it with the excel that I have?

#VALUE!
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter these manually yourself

(...and here is the orginal thread that describes what I am trying to acomplish: http://www.mrexcel.com/forum/showthread.php?p=2818694#post2818694 )
Click to expand...
This will generate a random number from 1 to 9:

=INT(1+9*RAND())
 
Upvote 0
That does indeed generate a random # between 1 and 9, but it doesn't really seem to help! My situation is that I want to pick a random item from a list in column b, but only if the same row has a code word in column a.

In other words, if I have a list of names in column a, I want to pick a random item from column b out of all the possible items tat match up to the name "Fred" from column A.

Using your INT and getting a random number from 1 to 9 doesn't help me with the central crux of this problem that is making me tear my hair out(!!!!) How do I pick a random item from a list that is filtered according to another column????? The answer is that array formula, but I don't have RANDBETWEEN and so I cannot use that array formula. Is there a way to do it without RANDBETWEEN???

Thanks, and I am desperate for help!!!
 
Upvote 0
Maybe this:

<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="text-align: center;;">1</td><td style="text-align: center;;">17</td><td style="text-align: center;;">1</td><td style="text-align: center;;"></td><td style="text-align: center;;">17</td><td style="text-align: center;;">17</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: center;;">2</td><td style="text-align: center;;">68</td><td style="text-align: center;;">2</td><td style="text-align: center;;"></td><td style="text-align: center;;">68</td><td style="text-align: center;;">68</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: center;;">3</td><td style="text-align: center;;">79</td><td style="text-align: center;;">3</td><td style="text-align: center;;"></td><td style="text-align: center;;">79</td><td style="text-align: center;;">79</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: center;;">4</td><td style="text-align: center;;">82</td><td style="text-align: center;;">4</td><td style="text-align: center;;"></td><td style="text-align: center;;">82</td><td style="text-align: center;;">82</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: center;;">5</td><td style="text-align: center;;">45</td><td style="text-align: center;;">5</td><td style="text-align: center;;"></td><td style="text-align: center;;">45</td><td style="text-align: center;;">45</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="text-align: center;;">6</td><td style="text-align: center;;">47</td><td style="text-align: center;;">6</td><td style="text-align: center;;"></td><td style="text-align: center;;">47</td><td style="text-align: center;;">47</td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: center;;">7</td><td style="text-align: center;;">12</td><td style="text-align: center;;">7</td><td style="text-align: center;;"></td><td style="text-align: center;;">12</td><td style="text-align: center;;">12</td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: center;;">8</td><td style="text-align: center;;">44</td><td style="text-align: center;;">8</td><td style="text-align: center;;"></td><td style="text-align: center;;">44</td><td style="text-align: center;;">44</td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: center;;">9</td><td style="text-align: center;;">75</td><td style="text-align: center;;">9</td><td style="text-align: center;;"></td><td style="text-align: center;;">75</td><td style="text-align: center;;">75</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">Randbetween</td><td style="text-align: center;;">Rand</td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="text-align: center;;">*****</td><td style="text-align: center;;">*****</td><td style="text-align: center;;">*****</td><td style="text-align: center;;">*****</td><td style="text-align: center;;">*****</td><td style="text-align: center;;">*****</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet7</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Array Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">E1</th><td style="text-align:left">{=INDEX(<font color="Blue">$B$1:$B$9,RANDBETWEEN(<font color="Red">MATCH(<font color="Green">C1,$A$1:$A$9,0</font>),MATCH(<font color="Green">1,IF(<font color="Purple">$A$1:$A$9=C1,1</font>)</font>)</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F1</th><td style="text-align:left">{=INDEX(<font color="Blue">$B$1:$B$9,ROUND(<font color="Red">RAND(<font color="Green"></font>)*(<font color="Green">MATCH(<font color="Purple">1,IF(<font color="Teal">$A$1:$A$9=C1,1</font>)</font>)-MATCH(<font color="Purple">C1,$A$1:$A$9,0</font>)</font>)+MATCH(<font color="Green">C1,$A$1:$A$9,0</font>),0</font>)</font>)}</td></tr></tbody></table><b>Entered with Ctrl+Shift+Enter.</b> If entered correctly, Excel will surround with curly braces {}.
<b>Note: Do not try and enter the {} manually yourself</b></td></tr></table><br />
Markmzz
 
Upvote 0
WOWOWOWOWOW

Thank you so much! That really works... you have no idea how much this helps me. Thank you, thank you, thank you!!!!!!!
 
Upvote 0
fishoutofwater said:
That does indeed generate a random # between 1 and 9, but it doesn't really seem to help! My situation is that I want to pick a random item from a list in column b, but only if the same row has a code word in column a.

In other words, if I have a list of names in column a, I want to pick a random item from column b out of all the possible items tat match up to the name "Fred" from column A.

Using your INT and getting a random number from 1 to 9 doesn't help me with the central crux of this problem that is making me tear my hair out(!!!!) How do I pick a random item from a list that is filtered according to another column????? The answer is that array formula, but I don't have RANDBETWEEN and so I cannot use that array formula. Is there a way to do it without RANDBETWEEN???

Thanks, and I am desperate for help!!!
Click to expand...
Try this...

Book1
ABCD
1FredI like ice creamJoeWhat's Up
2FredI like baseball__
3FredI like the color red__
4SallyI go hiking on Monday__
5SallyI go running on Tuesday__
6JoeHello__
7JoeGreetings__
8JoeHowdy__
9JoeWhat's Up__
Sheet1

This formula entered in D1:

=INDEX(B$1:B$9,INT(MATCH(C1,A$1:A$9,0)+COUNTIF(A$1:A$9,C1)*RAND()))
 
Upvote 0
fishoutofwater said:
I have this array formula (thanks to the wonderful mr. excel user Yahya-- thanks!)) and I am sure it is exactly what I want. But the problem is that it uses RANDBETWEEN and because I amusing excel2002 I only have RAND and not RANDBETWEEN.

Is there a way to modify this Array Formula so it uses RAND, and not RANDBETWEEN so I can use it with the excel that I have?

#VALUE!
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter these manually yourself

(...and here is the orginal thread that describes what I am trying to acomplish: http://www.mrexcel.com/forum/showthread.php?p=2818694#post2818694 )
Click to expand...
If you use RAND() or RANDBETWEEN(), the retrieval result will change. Is that what you want?
 
Upvote 0
But the problem is that it uses RANDBETWEEN and because I amusing excel2002 I only have RAND and not RANDBETWEEN.
Click to expand...

I'm using Excel 2002 and I have RANDBETWEEN. I believe you just need to activate the Analysis TookPak. (Tools Menu - Add Ins - Check Analysis TookPak.)
 
Upvote 0
A quick follow up question to this. If I am usig markmzz's solution (thank you so much markmzz!) and I want to ignore all 0 values in B, how would I modify the array formula? So from below...

I want to modify this array formula:
<table style="border: 1px solid rgb(166, 170, 182); text-align: center; background-color: rgb(255, 255, 255); border-collapse: collapse;" cellpadding="2.5px" rules="all" width="100%"><tbody><tr><tr><td style="text-align: left;">{=INDEX($B$1:$B$9,ROUND(RAND()*(MATCH(1,IF($A$1:$A$9=C1,1))-MATCH(C1,$A$1:$A$9,0))+MATCH(C1,$A$1:$A$9,0),0))}</td></tr></tr></tbody></table>such that it won't ever return a "0" In other words, since C2 is a "2" I want a random selection from the B column from all the rows that have a "2" in column A (ie, a random pick from A4,A5,A6, A7, A8, A9) but ignoring all 0 value possibilities in column B-- ie, a random pick from only B4, B7, B8, B9.

More simply, this array formula filters the output by column A. I need to add something to it to also filter out 0's from column B.


markmzz said:
Maybe this:

Excel 2007<table style="background-color: rgb(255, 255, 255); border: 1px solid rgb(166, 170, 182); border-collapse: collapse;" cellpadding="2.5px" rules="all"><colgroup><col style="background-color: rgb(224, 224, 240);" width="25px"><col><col><col><col><col><col></colgroup><thead><tr style="background-color: rgb(224, 224, 240); text-align: center; color: rgb(22, 17, 32);"><th>
</th><th>A</th><th>B</th><th>C</th><th>D</th><th>E
</th><th>F</th></tr></thead><tbody><tr><td style="color: rgb(22, 17, 32); text-align: center;">1</td><td style="text-align: center;">1</td><td style="text-align: center;">17</td><td style="text-align: center;">2
</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td><td style="text-align: center;">12</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">2</td><td style="text-align: center;">1
</td><td style="text-align: center;">0
</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">3</td><td style="text-align: center;">1
</td><td style="text-align: center;">79</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">4</td><td style="text-align: center;">2
</td><td style="text-align: center;">82</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">5</td><td style="text-align: center;">2
</td><td style="text-align: center;">0
</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">6</td><td style="text-align: center;">2
</td><td style="text-align: center;">0
</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">7</td><td style="text-align: center;">2
</td><td style="text-align: center;">12</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">8</td><td style="text-align: center;">2
</td><td style="text-align: center;">44</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">9</td><td style="text-align: center;">2
</td><td style="text-align: center;">75</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">10</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td><td style="text-align: center;">Rand</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">11</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td><td style="text-align: center;">
</td></tr><tr><td style="color: rgb(22, 17, 32); text-align: center;">12</td><td style="text-align: center;">*****</td><td style="text-align: center;">*****</td><td style="text-align: center;">*****</td><td style="text-align: center;">*****</td><td style="text-align: center;">
</td><td style="text-align: center;">*****</td></tr></tbody></table>
Sheet7​


<table style="border: 2px solid black; border-collapse: collapse; padding: 0.4em; background-color: rgb(255, 255, 255);" cellpadding="2.5px" rules="all" width="85%"><tbody><tr><td style="padding: 6px;">Array Formulas<table style="border: 1px solid rgb(166, 170, 182); text-align: center; background-color: rgb(255, 255, 255); border-collapse: collapse;" cellpadding="2.5px" rules="all" width="100%"><thead><tr style="background-color: rgb(224, 224, 240); color: rgb(22, 17, 32);"><th width="10px">Cell</th><th style="text-align: left; padding-left: 5px;">Formula</th></tr></thead><tbody><tr><th style="background-color: rgb(224, 224, 240); color: rgb(22, 17, 32);" width="10px">E1</th><td style="text-align: left;">{=INDEX($B$1:$B$9,RANDBETWEEN(MATCH(C1,$A$1:$A$9,0),MATCH(1,IF($A$1:$A$9=C1,1))))}</td></tr><tr><th style="background-color: rgb(224, 224, 240); color: rgb(22, 17, 32);" width="10px">F1</th><td style="text-align: left;">{=INDEX($B$1:$B$9,ROUND(RAND()*(MATCH(1,IF($A$1:$A$9=C1,1))-MATCH(C1,$A$1:$A$9,0))+MATCH(C1,$A$1:$A$9,0),0))}</td></tr></tbody></table>Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself</td></tr></tbody></table>

Markmzz
Click to expand...
 
Upvote 0
Try this:

<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">17</td><td style="text-align: right;;"></td><td style="text-align: right;;">2</td><td style="text-align: right;;">75</td><td style="text-align: right;;">75</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;">1</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: center;;"></td><td style="text-align: right;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;">1</td><td style="text-align: right;;">79</td><td style="text-align: right;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;;">2</td><td style="text-align: right;;">82</td><td style="text-align: right;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: right;;">2</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="text-align: right;;">2</td><td style="text-align: right;;">0</td><td style="text-align: right;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;">2</td><td style="text-align: right;;">12</td><td style="text-align: right;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;">2</td><td style="text-align: right;;">44</td><td style="text-align: right;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: right;;">2</td><td style="text-align: right;;">75</td><td style="text-align: right;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">Randbetween</td><td style="text-align: center;;">Rand</td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="text-align: center;;">*****</td><td style="text-align: center;;">*****</td><td style="text-align: center;;">*****</td><td style="text-align: center;;">*****</td><td style="text-align: center;;">*****</td><td style="text-align: center;;">*****</td></tr></tbody></table><p style="width:4.2em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet71</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Array Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">E1</th><td style="text-align:left">{=INDEX(<font color="Blue">B$1:B$9,LARGE(<font color="Red">IF(<font color="Green">(<font color="Purple">A$1:A$9=D$1</font>)*(<font color="Purple">B1:B9<>0</font>),ROW(<font color="Purple">A$1:A$9</font>)-ROW(<font color="Purple">A$1</font>)+1,0</font>),RANDBETWEEN(<font color="Green">1,COUNTIF(<font color="Purple">A1:A9,D1</font>)-COUNTIF(<font color="Purple">B1:B9,0</font>)+1</font>)</font>)</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F1</th><td style="text-align:left">{=INDEX(<font color="Blue">B$1:B$9,LARGE(<font color="Red">IF(<font color="Green">(<font color="Purple">A$1:A$9=D$1</font>)*(<font color="Purple">B1:B9<>0</font>),ROW(<font color="Purple">A$1:A$9</font>)-ROW(<font color="Purple">A$1</font>)+1,0</font>),ROUND(<font color="Green">RAND(<font color="Purple"></font>)*(<font color="Purple">COUNTIF(<font color="Teal">A1:A9,D1</font>)-COUNTIF(<font color="Teal">B1:B9,0</font>)</font>)+1,0</font>)</font>)</font>)}</td></tr></tbody></table><b>Entered with Ctrl+Shift+Enter.</b> If entered correctly, Excel will surround with curly braces {}.
<b>Note: Do not try and enter the {} manually yourself</b></td></tr></table><br />
Note: I don't know how to do that with the formula below.

{=INDEX($B$1:$B$9,ROUND(RAND()*(MATCH(1,IF($A$1:$A$9=C1,1))-MATCH(C1,$A$1:$A$9,0))+MATCH(C1,$A$1:$A$9,0),0))}

Markmzz
 
Upvote 0
You must log in or register to reply here.

Similar threads

T
  • Question Question
RANDBETWEEN Two decimal numbers to produced a decimal number
Replies
4
Views
850
SMK041
S
S
  • Solved
Table comparison using formulas
Replies
2
Views
146
sharshra
S
S
  • Question Question
Bug? Inserting Row (Keyboard Shortcut) doesn't add a row but instead moves all my formulas down one cell
Replies
7
Views
1K
smittymj
S
S
  • Question Question
is there a formula that can return multiple matches to criteria and put each match in its own cell
Replies
2
Views
668
supermom28115
S
N
  • Question Question
What should I do in order to solve an inconsistent reference error when using INDEX/MATCH?
Replies
1
Views
365
numbernoodle
N

Forum statistics

Threads
1,224,541
Messages
6,179,418
Members
452,912
Latest member
alicemil

Share this page

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