Combing Index, match, small, with multiple criteria

M

mavs149

New Member
Joined
Sep 13, 2013
Messages
23
Hello all,

This formula works: =INDEX(P2P!A:A,MATCH(SMALL(P2P!L:L,1),P2P!L:L,0))

What it's doing is pulling the carrier name that has the lowest rate in the master data table. The only problem is there are multiple lanes so it's only giving me the lowest rate out of all of them.

I created a identifier column in the master data table and the sheet that has the output. I need to figure out how to give match more criteria so that it also checks the identifier so that it will return the lowest rate in that specific lane.

I'm new to excel, and any advice is greatly appreciated.
 
Sort by date Sort by votes
Re: (SOLVED) Combing Index, match, small, with multiple criteria

[TABLE="width: 346"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Origin[/TD]
[TD]Destination[/TD]
[TD]Key[/TD]
[TD]Top carr[/TD]
[TD]Rate[/TD]
[/TR]
[TR]
[TD]TX[/TD]
[TD]NY[/TD]
[TD]TX-NY[/TD]
[TD]APEX[/TD]
[TD="align: right"]1.25[/TD]
[/TR]
[TR]
[TD]OK [/TD]
[TD]NY[/TD]
[TD]OK-NY[/TD]
[TD]Coyote[/TD]
[TD="align: right"]3[/TD]
[/TR]
</tbody>[/TABLE]
formula: =INDEX('Master data'!A2:A7,MATCH(SMALL(INDEX(('Master data'!D2:D7=RankOutput!C2)*'Master data'!E2:E7+('Master data'!D2:D7<>RankOutput!C2)*10^7,),1),'Master data'!E2:E7,0))

I made this test file so that I could post some data. Honestly, your provided formula works for pulling both the carrier name and the rate. The formula is not working in my actual analysis file for work. It's the same layout just there are around 5000 rows of data. The formula works perfectly in pulling the rates, but for some reason its not pulling the carrier names correctly.

I have tried re-formatting, re-pasting, everything I can think of, it's almost like the column containing the carrier name data is corrupt somewhere.
 
Upvote 0

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Re: (SOLVED) Combing Index, match, small, with multiple criteria

mavs149 said:
[TABLE="width: 346"]
<tbody>[TR]
[TD]Origin
[/TD]
[TD]Destination
[/TD]
[TD]Key
[/TD]
[TD]Top carr
[/TD]
[TD]Rate
[/TD]
[/TR]
[TR]
[TD]TX
[/TD]
[TD]NY
[/TD]
[TD]TX-NY
[/TD]
[TD]APEX
[/TD]
[TD="align: right"]1.25
[/TD]
[/TR]
[TR]
[TD]OK
[/TD]
[TD]NY
[/TD]
[TD]OK-NY
[/TD]
[TD]Coyote
[/TD]
[TD="align: right"]3
[/TD]
[/TR]
</tbody>[/TABLE]
formula: =INDEX('Master data'!A2:A7,MATCH(SMALL(INDEX(('Master data'!D2:D7=RankOutput!C2)*'Master data'!E2:E7+('Master data'!D2:D7<>RankOutput!C2)*10^7,),1),'Master data'!E2:E7,0))

I made this test file so that I could post some data. Honestly, your provided formula works for pulling both the carrier name and the rate. The formula is not working in my actual analysis file for work. It's the same layout just there are around 5000 rows of data. The formula works perfectly in pulling the rates, but for some reason its not pulling the carrier names correctly.

I have tried re-formatting, re-pasting, everything I can think of, it's almost like the column containing the carrier name data is corrupt somewhere.
Click to expand...

Could you post only the formula for the 5000 rows (the formula that you used with your data)?

Markmzz
 
Upvote 0
Re: (SOLVED) Combing Index, match, small, with multiple criteria

markmzz said:
Could you post only the formula for the 5000 rows (the formula that you used with your data)?

Markmzz
Click to expand...

This is the one that won't pull the carrier names correctly:
=INDEX(P2P!A2:A5943,MATCH(SMALL(INDEX((P2P!D2:D5943='Top P2P'!B2)*P2P!L2:L5943+(P2P!D2:D5943<>'Top P2P'!B2)*10^7,),1),P2P!L2:L5943,0))

And this one works for pulling the rates:
=INDEX(P2P!L2:L5943,MATCH(SMALL(INDEX((P2P!D2:D5943='Top P2P'!B2)*P2P!L2:L5943+(P2P!D2:D5943<>'Top P2P'!B2)*10^7,),1),P2P!L2:L5943,0))

It's very strange, it pulls a carrier name, just the incorrect one. The fact that it works fine in the test file means that it has to have something to do with that column of data. I would think at least.

I appreciate all the help, I'm very new to excel so anything you guys provide is teaching me a lot.
 
Upvote 0
Re: (SOLVED) Combing Index, match, small, with multiple criteria

I just noticed that sorting the carrier column A to Z or Z to A causes the carrier names pulled for each lane to change. Still the incorrect ones.
 
Upvote 0
Re: (SOLVED) Combing Index, match, small, with multiple criteria

mavs149 said:
This is the one that won't pull the carrier names correctly:
=INDEX(P2P!A2:A5943,MATCH(SMALL(INDEX((P2P!D2:D5943='Top P2P'!B2)*P2P!L2:L5943+(P2P!D2:D5943<>'Top P2P'!B2)*10^7,),1),P2P!L2:L5943,0))

And this one works for pulling the rates:
=INDEX(P2P!L2:L5943,MATCH(SMALL(INDEX((P2P!D2:D5943='Top P2P'!B2)*P2P!L2:L5943+(P2P!D2:D5943<>'Top P2P'!B2)*10^7,),1),P2P!L2:L5943,0))

It's very strange, it pulls a carrier name, just the incorrect one. The fact that it works fine in the test file means that it has to have something to do with that column of data. I would think at least.

I appreciate all the help, I'm very new to excel so anything you guys provide is teaching me a lot.
Click to expand...

Try the array formulas below and tell me if works:

Code: 
Use Ctrl+Shift+Enter and not only Enter to enter the formula

=INDEX(P2P!$A$2:$A$5943,MATCH(SMALL(IF(P2P!$D$2:$D$5943='Top P2P'!$B2,P2P!$L$2:$L$5943),1),IF(P2P!$D$2:$D$5943='Top P2P'!$B2,P2P!$L$2:$L$5943),0))

=SMALL(IF(P2P!$D$2:$D$5943='Top P2P'!$B2,P2P!$L$2:$L$5943),1)

Layout

[TABLE="width: 462"]
<tbody>[TR]
[TD="class: xl65, width: 47, bgcolor: transparent"]Origin
[/TD]
[TD="class: xl65, width: 67, bgcolor: transparent"]Key
[/TD]
[TD="class: xl65, width: 67, bgcolor: transparent"]Destination
[/TD]
[TD="class: xl65, width: 67, bgcolor: transparent"]Top carrier1
[/TD]
[TD="class: xl65, width: 57, bgcolor: transparent"]Top Rate1
[/TD]
[TD="class: xl65, width: 67, bgcolor: transparent"]Top carrier2
[/TD]
[TD="class: xl65, width: 57, bgcolor: transparent"]Top Rate2
[/TD]
[TD="class: xl65, width: 67, bgcolor: transparent"]Top carrier3
[/TD]
[TD="class: xl65, width: 57, bgcolor: transparent"]Top Rate3
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]Top P2P
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]TX
[/TD]
[TD="class: xl65, bgcolor: transparent"]TX-NY
[/TD]
[TD="class: xl65, bgcolor: transparent"]NY
[/TD]
[TD="class: xl66, bgcolor: yellow"]APEX
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]1,25
[/TD]
[TD="class: xl66, bgcolor: yellow"]Coyote
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]1,29
[/TD]
[TD="class: xl66, bgcolor: yellow"]Merit
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]1,48
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]OK
[/TD]
[TD="class: xl65, bgcolor: transparent"]OK-NY
[/TD]
[TD="class: xl65, bgcolor: transparent"]NY
[/TD]
[TD="class: xl66, bgcolor: yellow"]Coyote
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]3,00
[/TD]
[TD="class: xl66, bgcolor: yellow"]APEX
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]3,60
[/TD]
[TD="class: xl66, bgcolor: yellow"]Merit
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]5,00
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]TK
[/TD]
[TD="class: xl65, bgcolor: transparent"]TK-NY1
[/TD]
[TD="class: xl65, bgcolor: transparent"]NY1
[/TD]
[TD="class: xl66, bgcolor: yellow"]Carrier678
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]1,00
[/TD]
[TD="class: xl66, bgcolor: yellow"]Carrier678
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]1,00
[/TD]
[TD="class: xl66, bgcolor: yellow"]Carrier678
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]1,00
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]TK
[/TD]
[TD="class: xl65, bgcolor: transparent"]TK-NY2
[/TD]
[TD="class: xl65, bgcolor: transparent"]NY2
[/TD]
[TD="class: xl66, bgcolor: yellow"]Carrier103
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]1,00
[/TD]
[TD="class: xl66, bgcolor: yellow"]Carrier544
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]1,02
[/TD]
[TD="class: xl66, bgcolor: yellow"]Carrier544
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]1,02
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]OK
[/TD]
[TD="class: xl65, bgcolor: transparent"]OK-NY2
[/TD]
[TD="class: xl65, bgcolor: transparent"]NY2
[/TD]
[TD="class: xl66, bgcolor: yellow"]Carrier702
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]1,02
[/TD]
[TD="class: xl66, bgcolor: yellow"]Carrier702
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]1,02
[/TD]
[TD="class: xl66, bgcolor: yellow"]Carrier702
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]1,02
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]OK
[/TD]
[TD="class: xl65, bgcolor: transparent"]OK-NY1
[/TD]
[TD="class: xl65, bgcolor: transparent"]NY1
[/TD]
[TD="class: xl66, bgcolor: yellow"]Carrier374
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]1,00
[/TD]
[TD="class: xl66, bgcolor: yellow"]Carrier374
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]1,00
[/TD]
[TD="class: xl66, bgcolor: yellow"]Carrier314
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]1,01
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]********
[/TD]
[TD="class: xl65, bgcolor: transparent"]************
[/TD]
[TD="class: xl65, bgcolor: transparent"]************
[/TD]
[TD="class: xl65, bgcolor: transparent"]************
[/TD]
[TD="class: xl65, bgcolor: transparent"]**********
[/TD]
[TD="class: xl65, bgcolor: transparent"]************
[/TD]
[TD="class: xl65, bgcolor: transparent"]**********
[/TD]
[TD="class: xl65, bgcolor: transparent"]************
[/TD]
[TD="class: xl65, bgcolor: transparent"]**********
[/TD]
[TD="class: xl69, bgcolor: transparent"]********
[/TD]
[/TR]
</tbody>[/TABLE]


Markmzz
 
Upvote 0
Re: (SOLVED) Combing Index, match, small, with multiple criteria

markmzz said:
Try the array formulas below and tell me if works:

Code: 
Use Ctrl+Shift+Enter and not only Enter to enter the formula

=INDEX(P2P!$A$2:$A$5943,MATCH(SMALL(IF(P2P!$D$2:$D$5943='Top P2P'!$B2,P2P!$L$2:$L$5943),1),IF(P2P!$D$2:$D$5943='Top P2P'!$B2,P2P!$L$2:$L$5943),0))

=SMALL(IF(P2P!$D$2:$D$5943='Top P2P'!$B2,P2P!$L$2:$L$5943),1)

Layout

[TABLE="width: 462"]
<TBODY>[TR]
[TD="class: xl65, width: 47, bgcolor: transparent"]Origin
[/TD]
[TD="class: xl65, width: 67, bgcolor: transparent"]Key
[/TD]
[TD="class: xl65, width: 67, bgcolor: transparent"]Destination
[/TD]
[TD="class: xl65, width: 67, bgcolor: transparent"]Top carrier1
[/TD]
[TD="class: xl65, width: 57, bgcolor: transparent"]Top Rate1
[/TD]
[TD="class: xl65, width: 67, bgcolor: transparent"]Top carrier2
[/TD]
[TD="class: xl65, width: 57, bgcolor: transparent"]Top Rate2
[/TD]
[TD="class: xl65, width: 67, bgcolor: transparent"]Top carrier3
[/TD]
[TD="class: xl65, width: 57, bgcolor: transparent"]Top Rate3
[/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"]Top P2P
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]TX
[/TD]
[TD="class: xl65, bgcolor: transparent"]TX-NY
[/TD]
[TD="class: xl65, bgcolor: transparent"]NY
[/TD]
[TD="class: xl66, bgcolor: yellow"]APEX
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]1,25
[/TD]
[TD="class: xl66, bgcolor: yellow"]Coyote
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]1,29
[/TD]
[TD="class: xl66, bgcolor: yellow"]Merit
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]1,48
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]OK
[/TD]
[TD="class: xl65, bgcolor: transparent"]OK-NY
[/TD]
[TD="class: xl65, bgcolor: transparent"]NY
[/TD]
[TD="class: xl66, bgcolor: yellow"]Coyote
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]3,00
[/TD]
[TD="class: xl66, bgcolor: yellow"]APEX
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]3,60
[/TD]
[TD="class: xl66, bgcolor: yellow"]Merit
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]5,00
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]TK
[/TD]
[TD="class: xl65, bgcolor: transparent"]TK-NY1
[/TD]
[TD="class: xl65, bgcolor: transparent"]NY1
[/TD]
[TD="class: xl66, bgcolor: yellow"]Carrier678
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]1,00
[/TD]
[TD="class: xl66, bgcolor: yellow"]Carrier678
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]1,00
[/TD]
[TD="class: xl66, bgcolor: yellow"]Carrier678
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]1,00
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]TK
[/TD]
[TD="class: xl65, bgcolor: transparent"]TK-NY2
[/TD]
[TD="class: xl65, bgcolor: transparent"]NY2
[/TD]
[TD="class: xl66, bgcolor: yellow"]Carrier103
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]1,00
[/TD]
[TD="class: xl66, bgcolor: yellow"]Carrier544
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]1,02
[/TD]
[TD="class: xl66, bgcolor: yellow"]Carrier544
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]1,02
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]OK
[/TD]
[TD="class: xl65, bgcolor: transparent"]OK-NY2
[/TD]
[TD="class: xl65, bgcolor: transparent"]NY2
[/TD]
[TD="class: xl66, bgcolor: yellow"]Carrier702
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]1,02
[/TD]
[TD="class: xl66, bgcolor: yellow"]Carrier702
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]1,02
[/TD]
[TD="class: xl66, bgcolor: yellow"]Carrier702
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]1,02
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]OK
[/TD]
[TD="class: xl65, bgcolor: transparent"]OK-NY1
[/TD]
[TD="class: xl65, bgcolor: transparent"]NY1
[/TD]
[TD="class: xl66, bgcolor: yellow"]Carrier374
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]1,00
[/TD]
[TD="class: xl66, bgcolor: yellow"]Carrier374
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]1,00
[/TD]
[TD="class: xl66, bgcolor: yellow"]Carrier314
[/TD]
[TD="class: xl67, bgcolor: yellow, align: right"]1,01
[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"]********
[/TD]
[TD="class: xl65, bgcolor: transparent"]************
[/TD]
[TD="class: xl65, bgcolor: transparent"]************
[/TD]
[TD="class: xl65, bgcolor: transparent"]************
[/TD]
[TD="class: xl65, bgcolor: transparent"]**********
[/TD]
[TD="class: xl65, bgcolor: transparent"]************
[/TD]
[TD="class: xl65, bgcolor: transparent"]**********
[/TD]
[TD="class: xl65, bgcolor: transparent"]************
[/TD]
[TD="class: xl65, bgcolor: transparent"]**********
[/TD]
[TD="class: xl69, bgcolor: transparent"]********
[/TD]
[/TR]
</TBODY>[/TABLE]


Markmzz
Click to expand...

So far these two array formulas seem to be working as intended! I'm going to run through it all and spot check it. Thanks for the help, and I'll let you know if I notice anything wrong.
 
Upvote 0
Re: (SOLVED) Combing Index, match, small, with multiple criteria

Alright, I've run into one problem. Carriers that have the same rate seem to be the root of the problem. For example, on the first lane, the 1st and 2nd carrier are correct, but the third and fourth carriers both have 1.02 as their rate so depending on if the list is in ascending or descending order it displays the first one twice and skips the second one all together.

So it would list: Apex 1.0 - Coyote 1.01 - Merit 1.02 - Merit 1.02 instead of Merit 1.02 - Command 1.02 like it should.
 
Upvote 0
Re: (SOLVED) Combing Index, match, small, with multiple criteria

mavs149 said:
Alright, I've run into one problem. Carriers that have the same rate seem to be the root of the problem. For example, on the first lane, the 1st and 2nd carrier are correct, but the third and fourth carriers both have 1.02 as their rate so depending on if the list is in ascending or descending order it displays the first one twice and skips the second one all together.

So it would list: Apex 1.0 - Coyote 1.01 - Merit 1.02 - Merit 1.02 instead of Merit 1.02 - Command 1.02 like it should.
Click to expand...

Try this;

Code: 
Use Ctrl+Shift+Enter and not only Enter to enter the formula

=INDEX(P2P!$A$2:$A$5943,MATCH(SMALL(IF(P2P!$D$2:$D$5943='Top P2P'!$B2,P2P!$L$2:$L$5943+ROW(P2P!$L$2:$L$5943)/10^7),1),
IF(P2P!$D$2:$D$5943='Top P2P'!$B2,P2P!$L$2:$L$5943+ROW(P2P!$L$2:$L$5943)/10^7),0))

=SMALL(IF(P2P!$D$2:$D$5943='Top P2P'!$B2,P2P!$L$2:$L$5943),1)

Markmzz
 
Upvote 0
Re: (SOLVED) Combing Index, match, small, with multiple criteria

If you have Excel 2010+, you can try this:

Code: 
Use only Enter to enter the formulas

=INDEX(P2P!$A$2:$A$5943,MATCH(AGGREGATE(15,6,(P2P!$D$2:$D$5943='Top P2P'!$B2)*
(P2P!$L$2:$L$5943+ROW(P2P!$L$2:$L$5943)/10^7)+(P2P!$D$2:$D$5943<>'Top P2P'!$B2)*10^7,1),
INDEX(P2P!$L$2:$L$5943+ROW(P2P!$L$2:$L$5943)/10^7,),0))

=AGGREGATE(15,6,(P2P!$D$2:$D$5943='Top P2P'!$B2)*P2P!$L$2:$L$5943+(P2P!$D$2:$D$5943<>'Top P2P'!$B2)*10^7,1)

Markmzz
 
Upvote 0
Re: (SOLVED) Combing Index, match, small, with multiple criteria

markmzz said:
Try this;

Code: 
Use Ctrl+Shift+Enter and not only Enter to enter the formula

=INDEX(P2P!$A$2:$A$5943,MATCH(SMALL(IF(P2P!$D$2:$D$5943='Top P2P'!$B2,P2P!$L$2:$L$5943+ROW(P2P!$L$2:$L$5943)/10^7),1),
IF(P2P!$D$2:$D$5943='Top P2P'!$B2,P2P!$L$2:$L$5943+ROW(P2P!$L$2:$L$5943)/10^7),0))

=SMALL(IF(P2P!$D$2:$D$5943='Top P2P'!$B2,P2P!$L$2:$L$5943),1)

Markmzz
Click to expand...

These worked great! Thank you
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Solved
Index Match With Multiple Criteria
Replies
3
Views
170
acool
A
M
  • Solved
Finding cell with highest/lowest index from dropdown list?
Replies
9
Views
363
dreid1011
dreid1011
B
  • Question Question
Closest Match in a Range
Replies
1
Views
187
Rijnsent
Rijnsent
JenniferMurphy
  • Question Question
Is there a way to emulate a junction table in Excel?
Replies
1
Views
127
alansidman
A
J
  • Solved
Combining FILTER, MID, and RIGHT functions
Replies
3
Views
368
Joe4
Joe4

Forum statistics

Threads
1,223,099
Messages
6,170,111
Members
452,302
Latest member
TaMere

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