Filter columns with criteria

GMC The Macro Man

Board Regular
Joined
Mar 23, 2023
Messages
104
Office Version
  1. 2021
Platform
  1. Windows
Hello there
The spreadsheet below shows a list of pupils with some of the subjects they are going to sit this year.
The values under the subjects, represent the expected result they will achieve. The scale is 1 = Excellent and 8 = Very Poor.
I needed to filter out (on a separate sheet) any pupil who has a 7 or 8 listed in their expected results.
Thanks to FLUFF (Mr Excel MVP) he was able to assist me using the formula below which worked perfectly.
=LET(f,FILTER(Grading!A2:N11,MMULT(--(Grading!D2:N11>=7),SEQUENCE(COLUMNS(Grading!D1:N1),,,0))),IF(f="","",f))

The client has now asked if they could add another column after each subject with a Grading value of either 4,5,6 or 7.
On the 2nd image you can see I have added the extra columns (Shaded) but because this could also contain a "7" in the column, it follows the above formula and brings over data in that row.
Using Fluffs formula, I tried to pick just the columns that i required but i am failing big time
I need the formula that FLUFF gave me but only to filter on these columns, D15,F15,H15,J15,L15,N15,P15,R15,T15,V15, W15,X15,Y15

Can anyone help?
TIA
George

Grading.xlsx
ABCDEFGHIJKLMN
1NameClassGenderArt & Design Business Chemistry Dance Design Drama English French Geography Graphics History
2George4AMale426782
3Larry4AMale33333
4Divya4AFemale11187
5Urvesh4AMale54772
6Suzie4BFemale78583
7Beth4BFemale33333
8Tom4BMale35222
9Simone4CFemale22728
10Colin4CMale53553
11Stephanie4CFemale66666
Grading



Grading.xlsx
ABCDEFGHIJKLMNOPQRSTUVWXY
14NameClassGenderArt & Design A&D GradeBusiness Bus GradeChemistry Chem GradeDance Dance GradeDesign Des GradeDrama Drama GradeEnglish Eng GradeFrench French GradeGeography Geo GradeGraphics Graph GradeHistory Hist Grade
15George4AMale45266745872
16Larry4AMale4335436363
17Divya4AFemale571611845774
18Urvesh4AMale7545747726
19Suzie4BFemale7865845377
20Beth4BFemale6363434337
21Tom4BMale35627244247
22Simone4CFemale226757286
23Colin4CMale653655345576
24Stephanie4CFemale666667
Grading
 
Try
Excel Formula:
=LET(r,SEQUENCE(ROWS(Grading!D2:DH600)),d,INDEX(Grading!D2:DH600,r,SEQUENCE(,27,4,4)),c,COLUMNS(d),s,SEQUENCE(,c+3),f,FILTER(Grading!A2:DH600,MMULT(--(d>=7),SEQUENCE(c,,,0))),IF(f=0,"",f))
 
Upvote 0
Solution

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Try
Excel Formula:
=LET(r,SEQUENCE(ROWS(Grading!D2:DH600)),d,INDEX(Grading!D2:DH600,r,SEQUENCE(,27,4,4)),c,COLUMNS(d),s,SEQUENCE(,c+3),f,FILTER(Grading!A2:DH600,MMULT(--(d>=7),SEQUENCE(c,,,0))),IF(f=0,"",f))

Hi Fluff
You have been great in helping me with this build for my school, but I've now entered the latest data and I'm getting a #N/A error because I have been playing about with it and I have now screwed it up.

This is my latest formula that I'm using on this page
=(LET(r,SEQUENCE(ROWS('Student Data'!Q12:GI600)),d,INDEX('Student Data'!Q12:GI600,r,SEQUENCE(,25,6,7)),c,COLUMNS(d),s,SEQUENCE(,c+16),f,FILTER(IF(s<=16,'Student Data'!A12:P600,INDEX(d,r,s-16)),MMULT(--(d>=7),SEQUENCE(c,,,0))),IF(f=0,"",f)))

Student Data'!A12:P600 - this is the 16 columns of student personal data, i.e, ID number , name, DOB etc..
Student Data'!Q12:GI600 - This is the 25 Subjects the students can choose from, each with 7 columns, cols 4,5,6,7 represent their grades in Oct, Dec, Jan, Mar
r,SEQUENCE(,25,6,7)
- this is the 25 subjects. I have chosen column 6 (JAN) to return and there are 7 columns in each subject.

MMULT(--(d>=7) - On this sheet, I only want to see any grades that are >=7 (THIS IS NO LONGER THE CASE) . I want to see ALL the students grade for all subjects for the given criteria (In this case r,SEQUENCE(,25,7,7) for MARCH

I now want to replace the sequence for the latest data, so change the 6 (JAN) to a 7 (MAR), r,SEQUENCE(,25,7,7)) I can change this to a 1,2,3,4,5 or 6 and it will always return the corresponding data, but when I change it to a 7 it gives me the #N/A error.
I hope this makes sense

Any ideas?
George

St Maurice High School - June 2024.xlsx
ABCDHQRSTUVWXYZAAABAC
1Number of Subjects sittingTotal Amount of Grade 7,8 or 9Scottish Candidate NumberFull NameReg ClassAverage AttendanceLate to DateA&D Working GradeBiology Working GradeBus Working GradeChemistry Working GradeDesign Working GradeDrama Working GradeEnglish Working GradeFrench Working GradeGeography Working GradeGraphics Working GradeH&F Working Grade
2Subject3+Scottish Candidate NumberFull NameReg ClassAverage AttendanceLate to DateA&D DecBiology DecBus DecChemistry DecDesign DecDrama DecEnglish DecFrench DecGeography DecGraphics DecH&F Dec
343121524856Christina Obidiwe6D81.7158
431121526174Christopher Punter6D43.346
541121526069Colleen Teresa McCrae6D93.2558
632121513706Daniel McCann6D88.876
732121525763Daniel Thomas Currie6D84.01
831121525852Elise Susan Love6D95.73
93 121524872Erin Catherine Tourish6D46.72
1021121525984Jack Lewis6D6
1131121526107Jacob Wilson6D98.72
1241121513749Kaci Nimmo6D91.66
134 121542013Kaiden McCreery6D89.814
1442121542218Kian-Francis Lawther6D83.918
1531121524902Leah Marie Henderson6D98.172
1632121541785Liam Alan McVay6D98.48
Focus Student
Cell Formulas
RangeFormula
A3:A16A3=COUNT(S3:AQ3)
B3:B16B3=LET(f,COUNTIFS(S3:AQ3,">6"),IF(f=0,"",f))
C3:AQ385C3=(LET(r,SEQUENCE(ROWS('Student Data'!Q12:GI600)),d,INDEX('Student Data'!Q12:GI600,r,SEQUENCE(,25,6,7)),c,COLUMNS(d),s,SEQUENCE(,c+16),f,FILTER(IF(s<=16,'Student Data'!A12:P600,INDEX(d,r,s-16)),MMULT(--(d>=7),SEQUENCE(c,,,0))),IF(f=0,"",f)))
Dynamic array formulas.
Named Ranges
NameRefers ToCells
Full_Name='Student Data'!$B$12:$B$410C3
Cells with Conditional Formatting
CellConditionCell FormatStop If True
B3:B599Cell Valuebetween 3 and 9textNO
Q3:Q261Cell Valuebetween 1 and 89.99textNO
S3:AQ339Cell Valuebetween 5 and 6textNO
S3:AQ339Cell Valuebetween 1 and 4textNO
S3:AQ599Cell Valuebetween 7 and 9textNO


St Maurice High School - June 2024.xlsx
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAK
11Scottish Candidate NumberFull NameForenameSurnameYear GroupReg ClassSIMDSexFSMECare ExperienceStudent Attendance OctoberStudent Attendance DecemberStudent Attendance JanuaryStudent Attendance MarchAverage AttendanceLate to DateArt & Design Nat LevelArt & Design TeacherA&D Target GradeA&D OctA&D DecA&D JanA&D MarBiology Nat LevelBiology TeacherBiology Target GradeBiology OctBiology DecBiology JanBiology MarBusiness Nat LevelBusiness TeacherBusiness Target GradeBus OctBus DecBus JanBus Mar
12121524856Christina ObidiweChristinaObidiweS66D6FYesNone100.094.6281.71
13121837137Christopher O'RourkeChristopherO'RourkeS66DMNoNone100.0error90.0#N/A#N/A#N/A#N/A#N/A#N/A
14121526174Christopher PunterChristopherPunterS66D2MNoNone91.186.5643.34
15121526069Colleen Teresa McCraeColleen TeresaMcCraeS66D2FNoNone95.687.6393.25
16121513706Daniel McCannDanielMcCannS66D6MNoNone93.386.5688.80Nat 6Tracy Anne McGee44478
17121525763Daniel Thomas CurrieDaniel ThomasCurrieS66D7MNoNone95.693.0184.01
18121525852Elise Susan LoveElise SusanLoveS66D9FNoNone93.386.0295.70Nat 5Hannah Coakley45535
19121524872Erin Catherine TourishErin CatherineTourishS66D8FNoNone97.894.0946.70
20121525984Jack LewisJackLewisS66DM87.63Nat 7Scott Singer34465
21121526107Jacob WilsonJacobWilsonS66D3MNoNone95.686.0298.70
22121513749Kaci NimmoKaciNimmoS66D3FNoNone100.099.4691.60Nat 6Georgia Galloway66666
23121542013Kaiden McCreeryKaidenMcCreeryS66D3MNoNone100.095.789.81
24121542218Kian-Francis LawtherKian-FrancisLawtherS66D7MNoNone100.096.7783.91
25121524902Leah Marie HendersonLeah MarieHendersonS66D5FNoNone100.097.3198.10
26121541785Liam Alan McVayLiam AlanMcVayS66D2MNoNone100.096.2498.40
27121541947Liam Anthony SandemanLiam AnthonySandemanS66DM98.92
28211306955Liliana Soares Fernandes CotuLilianaSoares Fernandes CotuS66D3FNoNone95.680.1195.20
29121541912Lucie ClarkLucieClarkS66D3FNoNone73.380.1181.70
30121525941Luke Joseph JoyceLuke JosephJoyceS66DM93.55Nat 7Scott Singer34475
31121525909Mark HeronMarkHeronS66D9MNoNone100.092.4799.21Nat 7Scott Singer34442
32121524880Sky WardSkyWardS66D6FNoNone93.387.196.80
33121513978Tyler McTierTylerMcTierS66D6MNoNone100.094.0998.90Nat 6Georgia Galloway66677
34211306939Zara RahimZaraRahimS66D7FNoNone95.691.9446.81Nat 6Marie Claire McCallum54687
35121541866Aaron Craig GillanAaron CraigGillanS66C7MNoNone84.480.6594.62
36121513951Zoe McLeodZoeMcLeodS66C2FNoNone100.097.3198.10
37121513889Aidan JacksonAidanJacksonS66C8MNoNone82.281.1899.71Nat 6Tracy Anne McGee64657
38121513986Aidan MaxwellAidanMaxwellS66C8MNoNone46.7error87.80Hannah Coakley0000
39121513927Aiden McDermottAidenMcDermottS66C4MYesNone100.093.5597.90Nat 6Tracy Anne McGee22224
40121526042Aimee Louise McConnellAimee LouiseMcConnellS66C9FNoNone100.096.2499.70Nat 6Tracy Anne McGee44454
41121541793Carla Jacqueline RaeCarla JacquelineRaeS66C7FNoNone64.479.0366.71Nat 6Tracy Anne McGee44455
42121524619Declan Anthony RoseDeclan AnthonyRoseS66C4MYesNone93.383.8793.62Nat 7Scott Singer34447
43121513684Dominic LintonDominicLintonS66C8MNoNone100.090.86100.03
Student Data
Cell Formulas
RangeFormula
O12O12=AVERAGE('Student Data'!$K37:$N37)
O13O13=AVERAGE('Student Data'!$K104:$N104)
O14O14=AVERAGE('Student Data'!$K75:$N75)
O15O15=AVERAGE('Student Data'!$K70:$N70)
O16O16=AVERAGE('Student Data'!$K14:$N14)
O17O17=AVERAGE('Student Data'!$K53:$N53)
O18O18=AVERAGE('Student Data'!$K57:$N57)
O19O19=AVERAGE('Student Data'!$K38:$N38)
O21O21=AVERAGE('Student Data'!$K72:$N72)
O22O22=AVERAGE('Student Data'!$K15:$N15)
O23O23=AVERAGE('Student Data'!$K92:$N92)
O24O24=AVERAGE('Student Data'!$K96:$N96)
O25O25=AVERAGE('Student Data'!$K40:$N40)
O26,O29O26=AVERAGE('Student Data'!$K83:$N83)
O28O28=AVERAGE('Student Data'!$K404:$N404)
O31O31=AVERAGE('Student Data'!$K59:$N59)
O32O32=AVERAGE('Student Data'!$K39:$N39)
O33O33=AVERAGE('Student Data'!$K27:$N27)
O34O34=AVERAGE('Student Data'!$K403:$N403)
O35O35=AVERAGE('Student Data'!$K85:$N85)
O36,O38O36=AVERAGE('Student Data'!$K26:$N26)
O37O37=AVERAGE('Student Data'!$K22:$N22)
O39O39=AVERAGE('Student Data'!$K23:$N23)
O40O40=AVERAGE('Student Data'!$K69:$N69)
O41O41=AVERAGE('Student Data'!$K84:$N84)
O42O42=AVERAGE('Student Data'!$K30:$N30)
O43O43=AVERAGE('Student Data'!$K13:$N13)
Cells with Conditional Formatting
CellConditionCell FormatStop If True
AK12Cell Valuebetween 7 and 9textNO
AK12Cell Valuebetween 5 and 6textNO
AK12Cell Valuebetween 3 and 4textNO
AK12Cell Valuebetween 1 and 2textNO
AK12Cell Valuebetween 7 and 9textNO
AK12Cell Valuebetween 5 and 6textNO
AK12Cell Valuebetween 3 and 4textNO
AK12Cell Valuebetween 1 and 2textNO
AD12Cell Valuebetween 7 and 9textNO
AD12Cell Valuebetween 5 and 6textNO
AD12Cell Valuebetween 3 and 4textNO
AD12Cell Valuebetween 1 and 2textNO
AD12Cell Valuebetween 7 and 9textNO
AD12Cell Valuebetween 5 and 6textNO
AD12Cell Valuebetween 3 and 4textNO
AD12Cell Valuebetween 1 and 2textNO
AJ12:AJ411Cell Valuebetween 7 and 9textNO
AJ12:AJ411Cell Valuebetween 5 and 6textNO
AJ12:AJ411Cell Valuebetween 3 and 4textNO
AJ12:AJ411Cell Valuebetween 1 and 2textNO
AJ12:AJ411Cell Valuebetween 7 and 9textNO
AJ12:AJ411Cell Valuebetween 5 and 6textNO
AJ12:AJ411Cell Valuebetween 3 and 4textNO
AJ12:AJ411Cell Valuebetween 1 and 2textNO
AG12:AG411Cell Valuebetween 7 and 9textNO
AG12:AG411Cell Valuebetween 5 and 6textNO
AG12:AG411Cell Valuebetween 3 and 4textNO
AG12:AG411Cell Valuebetween 1 and 2textNO
AG12:AG411Cell Valuebetween 7 and 9textNO
AG12:AG411Cell Valuebetween 5 and 6textNO
AG12:AG411Cell Valuebetween 3 and 4textNO
AG12:AG411Cell Valuebetween 1 and 2textNO
AC12:AC411Cell Valuebetween 7 and 9textNO
AC12:AC411Cell Valuebetween 5 and 6textNO
AC12:AC411Cell Valuebetween 3 and 4textNO
AC12:AC411Cell Valuebetween 1 and 2textNO
AC12:AC411Cell Valuebetween 7 and 9textNO
AC12:AC411Cell Valuebetween 5 and 6textNO
AC12:AC411Cell Valuebetween 3 and 4textNO
AC12:AC411Cell Valuebetween 1 and 2textNO
Z12:Z411Cell Valuebetween 7 and 9textNO
Z12:Z411Cell Valuebetween 5 and 6textNO
Z12:Z411Cell Valuebetween 3 and 4textNO
Z12:Z411Cell Valuebetween 1 and 2textNO
Z12:Z411Cell Valuebetween 7 and 9textNO
Z12:Z411Cell Valuebetween 5 and 6textNO
Z12:Z411Cell Valuebetween 3 and 4textNO
Z12:Z411Cell Valuebetween 1 and 2textNO
AI12Cell Valuebetween 7 and 9textNO
AI12Cell Valuebetween 5 and 6textNO
AI12Cell Valuebetween 3 and 4textNO
AI12Cell Valuebetween 1 and 2textNO
AI12Cell Valuebetween 7 and 9textNO
AI12Cell Valuebetween 5 and 6textNO
AI12Cell Valuebetween 3 and 4textNO
AI12Cell Valuebetween 1 and 2textNO
AB12Cell Valuebetween 7 and 9textNO
AB12Cell Valuebetween 5 and 6textNO
AB12Cell Valuebetween 3 and 4textNO
AB12Cell Valuebetween 1 and 2textNO
AB12Cell Valuebetween 7 and 9textNO
AB12Cell Valuebetween 5 and 6textNO
AB12Cell Valuebetween 3 and 4textNO
AB12Cell Valuebetween 1 and 2textNO
X12:X421,AE12:AE421,AL12:AL421,AS12:AS421,AZ12:AZ421,BG12:BG421,BN12:BN421,BU12:BU421,CB12:CB421,CI12:CI421,CP12:CP421,CW12:CW421,DD12:DD421,DK12:DK421,DR12:DR421,DY12:DY421,EF12:EF421,EM12:EM421,ET12:ET421,FA12:FA421,FH12:FH421,FO12:FO421,FV12:FV421Cell Value="Nat 7"textNO
X12:X421,AE12:AE421,AL12:AL421,AS12:AS421,AZ12:AZ421,BG12:BG421,BN12:BN421,BU12:BU421,CB12:CB421,CI12:CI421,CP12:CP421,CW12:CW421,DD12:DD421,DK12:DK421,DR12:DR421,DY12:DY421,EF12:EF421,EM12:EM421,ET12:ET421,FA12:FA421,FH12:FH421,FO12:FO421,FV12:FV421Cell Value="Nat 5"textNO
X12:X421,AE12:AE421,AL12:AL421,AS12:AS421,AZ12:AZ421,BG12:BG421,BN12:BN421,BU12:BU421,CB12:CB421,CI12:CI421,CP12:CP421,CW12:CW421,DD12:DD421,DK12:DK421,DR12:DR421,DY12:DY421,EF12:EF421,EM12:EM421,ET12:ET421,FA12:FA421,FH12:FH421,FO12:FO421,FV12:FV421Cell Value="Nat 6"textNO
X12:X421,AE12:AE421,AL12:AL421,AS12:AS421,AZ12:AZ421,BG12:BG421,BN12:BN421,BU12:BU421,CB12:CB421,CI12:CI421,CP12:CP421,CW12:CW421,DD12:DD421,DK12:DK421,DR12:DR421,DY12:DY421,EF12:EF421,EM12:EM421,ET12:ET421,FA12:FA421,FH12:FH421,FO12:FO421,FV12:FV421Cell Value="Nat 4"textNO
X12:X421,AE12:AE421,AL12:AL421,AS12:AS421,AZ12:AZ421,BG12:BG421,BN12:BN421,BU12:BU421,CB12:CB421,CI12:CI421,CP12:CP421,CW12:CW421,DD12:DD421,DK12:DK421,DR12:DR421,DY12:DY421,EF12:EF421,EM12:EM421,ET12:ET421,FA12:FA421,FH12:FH421,FO12:FO421,FV12:FV421Cell Value="Nat 3"textNO
AH12,AK13:AK411Cell Valuebetween 7 and 9textNO
AH12,AK13:AK411Cell Valuebetween 5 and 6textNO
AH12,AK13:AK411Cell Valuebetween 3 and 4textNO
AH12,AK13:AK411Cell Valuebetween 1 and 2textNO
DZ412:EA421,FR12:FS411,FU13:FU411,FY13:FZ411,GB13:GB411,FW412:GB421,AA12,AD13:AD411,CX12:CX411,DE12:DE411,DZ12:DZ411,EG12:EG411,EN12:EN411,EU12:EU411,FB12:FB411,FI12:FI411,FW12:FW411,AA13:AB411,AH13:AI411,AO13:AP411,AV13:AW411,BC13:BD411,BJ13:BK411Cell Valuebetween 7 and 9textNO
AA12,AD13:AD411,CX12:CX411,DE12:DE411,DZ12:DZ411,EG12:EG411,EN12:EN411,EU12:EU411,FB12:FB411,FI12:FI411,FR12:FS411,FU13:FU411,FW12:FW411,AA13:AB411,AH13:AI411,AO13:AP411,AV13:AW411,BC13:BD411,BJ13:BK411,BQ13:BR411,BX13:BY411,CE13:CF411,CL13:CM411,CS13:CT411Cell Valuebetween 5 and 6textNO
AA12,AD13:AD411,CX12:CX411,DE12:DE411,DZ12:DZ411,EG12:EG411,EN12:EN411,EU12:EU411,FB12:FB411,FI12:FI411,FR12:FS411,FU13:FU411,FW12:FW411,AA13:AB411,AH13:AI411,AO13:AP411,AV13:AW411,BC13:BD411,BJ13:BK411,BQ13:BR411,BX13:BY411,CE13:CF411,CL13:CM411,CS13:CT411Cell Valuebetween 3 and 4textNO
AA12,AD13:AD411,CX12:CX411,DE12:DE411,DZ12:DZ411,EG12:EG411,EN12:EN411,EU12:EU411,FB12:FB411,FI12:FI411,FR12:FS411,FU13:FU411,FW12:FW411,AA13:AB411,AH13:AI411,AO13:AP411,AV13:AW411,BC13:BD411,BJ13:BK411,BQ13:BR411,BX13:BY411,CE13:CF411,CL13:CM411,CS13:CT411Cell Valuebetween 1 and 2textNO
Q12:Q421Cell Value="Nat 7"textNO
Q12:Q421Cell Value="Nat 5"textNO
Q12:Q421Cell Value="Nat 6"textNO
Q12:Q421Cell Value="Nat 4"textNO
Q12:Q421Cell Value="Nat 3"textNO
S12:W421Cell Valuebetween 7 and 9textNO
S12:W421Cell Valuebetween 5 and 6textNO
S12:W421Cell Valuebetween 3 and 4textNO
S12:W421Cell Valuebetween 1 and 2textNO
S12:W421Cell Valuebetween 7 and 9textNO
S12:W421Cell Valuebetween 5 and 6textNO
S12:W421Cell Valuebetween 3 and 4textNO
S12:W421Cell Valuebetween 1 and 2textNO
K12:P411Cell Value="error"textNO
K12:O421Cell Valuebetween 1 and 89.9textNO
 
Upvote 0
How about
Excel Formula:
=LET(r,SEQUENCE(ROWS('Student Data'!Q12:GI600)),d,INDEX('Student Data'!Q12:GI600,r,SEQUENCE(,25,7,7)),c,COLUMNS(d),s,SEQUENCE(,c+16),x,IF(s<=16,'Student Data'!A12:P600,INDEX(d,r,s-16)),f,FILTER(x,INDEX(x,,1)<>0),IF(f=0,"",f))
 
Upvote 1
How about
Excel Formula:
=LET(r,SEQUENCE(ROWS('Student Data'!Q12:GI600)),d,INDEX('Student Data'!Q12:GI600,r,SEQUENCE(,25,7,7)),c,COLUMNS(d),s,SEQUENCE(,c+16),x,IF(s<=16,'Student Data'!A12:P600,INDEX(d,r,s-16)),f,FILTER(x,INDEX(x,,1)<>0),IF(f=0,"",f))
Hey bud,
You are an absolute star, I played about with this for Hours as I didn't want to trouble you but in the end I had to give in.
Thats another pint I owe you

Thanks again
George
 
Upvote 0
You're welcome & thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,223,888
Messages
6,175,219
Members
452,620
Latest member
dsubash

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