Index formula

M

mattbird

Active Member
Joined
Oct 15, 2013
Messages
305
Office Version
  1. 2016
Hi,

I am have a table (Excel 2003) that I would like to return an answer from another table, but it needs to take into consideration gender and age. I have written a Index formula that works for age 0-29 male & Female, but am now stuck as I can't work out how to make it return an answer is the person is ie 30-34, 35-39, 40-44, 45-49, 50-54, 55-59, 60-64 as well as taking their gender into consideration.

The formula I am working with is:
Code: 
=IF($F312="M",(IF(P312=0,0,IF(E312<=30,IF(P312>=8.25,(INDEX('PFA Conv Table - 1.5 Mile Run'!$A5:$A55,MATCH(P312,'PFA Conv Table - 1.5 Mile Run'!$B5:$B55))),100)))),(IF(P312=0,0,(IF(P312>=10,(INDEX('PFA Conv Table - 1.5 Mile Run'!$A5:$A55,MATCH(P312,'PFA Conv Table - 1.5 Mile Run'!$F5:$F55))),100)))))

It is frustrating as everything I have tried doesn't work.

Any help would be greatly appreciated.

Matt
 
Sort by date Sort by votes
Hi Matt,

Based on the example data, it looks like:

Code: 
=INDEX(A5:A6,MATCH(P15,INDEX(B5:BM6,0,MATCH(1,IF(B2:BM2>=E15,IF(B4:BM4=F15,1)),0)-2),1))

Commit with CTRL+SHIFT+ENTER and adjust ranges to suit your real data.

For the formula to work, you need to stipulate the UPPER bounds in Table 2 in each column. For example, B:I would be 29 and J:Q would be 34. The row where this data resides can be hidden if needs be.

Post back if anything is unclear.

Matty
 
Upvote 0

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.
Matty,

I have tried using the same formula for a slightly different table to return a result but can'y get it to work. This time age is the only factor so I modified the formula slightly.

Code: 
=INDEX('PFA Conv Table - Sit Ups'!$A$6:$A$57,MATCH(PFA!M15,INDEX('PFA Conv Table - Sit Ups'!$B$6:$I$57,0,MATCH(1,IF('PFA Conv Table - Sit Ups'!$B$3:$I$3>=PFA!E15,1),0)-2),1))

The input table (Table 1) is the same as before, the results table (Table 2) is different.

Table 1:

​
Excel 2007
DEFGHIJKLMNO
11DOBAGEM/FSQNDate ofDate of NextPRESS - UPSSIT - UPS
12COYAssessmentAssessmentSCOREPOINTSRESULTSCOREPOINTSRESULT
13
1411/04/9025M 
1511/04/5164M 670F
PFA
Cell Formulas
RangeFormula
E14=IF(D14="","",DATEDIF(D14,NOW(),"Y"))
E15=IF(D15="","",DATEDIF(D15,NOW(),"Y"))
I14=IF(H14="","",DATE(YEAR(H14),MONTH(H14)+IF(Y14="Fail",0,6),DAY(H14)+IF(Y14="Fail",7,0)))
I15=IF(H15="","",DATE(YEAR(H15),MONTH(H15)+IF(Y15="Fail",0,6),DAY(H15)+IF(Y15="Fail",7,0)))
O15=IF(M15=0,"",IF(N15>=70,"P","F"))
N15{=INDEX('PFA Conv Table - Sit Ups'!$A$6:$A$57,MATCH(PFA!M15,INDEX('PFA Conv Table - Sit Ups'!$B$6:$I$57,0,MATCH(1,IF('PFA Conv Table - Sit Ups'!$B$3:$I$3>=PFA!E15,1),0)-2),1))}
Press CTRL+SHIFT+ENTER to enter array formulas.
Named Ranges
NameRefers ToCells
PF=List!$E$2:$E$3
PFA=List!#REF!



Table 2 is in the next post
 
Last edited:
Upvote 0
Table 2


Excel 2007
ABCDEFGHIJ
3Upper Bounds2934394449545964
4Age Group
5Points< 3030 - 3435 - 3940 - 4445 - 4950 - 5455 - 5960 - 64Points
61007772716762615753100
799767170666160565299
8987069656059555198
997756968645958545097
1096746867635857534996
PFA Conv Table - Sit Ups


I put the upper bounds in as before. The table points go down to 50 point as before.


I have two more table I need to do the same with a press up and blep test after this one if you don't mine helping

Matt
 
Last edited:
Upvote 0
Hi,

The following should work:

Code: 
=INDEX('PFA Conv Table - Sit Ups'!A$6:A$10,MATCH(M14,INDEX('PFA Conv Table - Sit Ups'!B$6:I$10,0,MATCH(1,IF('PFA Conv Table - Sit Ups'!B$3:I$3>=E14,1),0)),1))

Committed with CTRL+SHIFT+ENTER.

However, your data needs sorting in ascending order for the MATCH function to work, meaning it needs to be like this:

Excel 2012
ABCDEFGHI

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]3[/TD]
[TD="bgcolor: #FFFFFF"]Upper Bounds[/TD]
[TD="bgcolor: #FFFFFF, align: right"]29[/TD]
[TD="bgcolor: #FFFFFF, align: right"]34[/TD]
[TD="bgcolor: #FFFFFF, align: right"]39[/TD]
[TD="bgcolor: #FFFFFF, align: right"]44[/TD]
[TD="bgcolor: #FFFFFF, align: right"]49[/TD]
[TD="bgcolor: #FFFFFF, align: right"]54[/TD]
[TD="bgcolor: #FFFFFF, align: right"]59[/TD]
[TD="bgcolor: #FFFFFF, align: right"]64[/TD]

[TD="align: center"]4[/TD]
[TD="bgcolor: #969696, align: center"]Age Group[/TD]
[TD="bgcolor: #969696, align: center"][/TD]
[TD="bgcolor: #969696, align: center"][/TD]
[TD="bgcolor: #969696, align: center"][/TD]
[TD="bgcolor: #969696, align: center"][/TD]
[TD="bgcolor: #969696, align: center"][/TD]
[TD="bgcolor: #969696, align: center"][/TD]
[TD="bgcolor: #969696, align: center"][/TD]
[TD="bgcolor: #969696, align: center"][/TD]

[TD="align: center"]5[/TD]
[TD="bgcolor: #969696, align: center"]Points[/TD]
[TD="bgcolor: #969696, align: center"]< 30[/TD]
[TD="bgcolor: #969696, align: center"]30 - 34[/TD]
[TD="bgcolor: #969696, align: center"]35 - 39[/TD]
[TD="bgcolor: #969696, align: center"]40 - 44[/TD]
[TD="bgcolor: #969696, align: center"]45 - 49[/TD]
[TD="bgcolor: #969696, align: center"]50 - 54[/TD]
[TD="bgcolor: #969696, align: center"]55 - 59[/TD]
[TD="bgcolor: #969696, align: center"]60 - 64[/TD]

[TD="align: center"]6[/TD]
[TD="bgcolor: #969696, align: center"]96[/TD]
[TD="bgcolor: #FFFFFF, align: center"]74[/TD]
[TD="bgcolor: #FFFFFF, align: center"]68[/TD]
[TD="bgcolor: #FFFFFF, align: center"]67[/TD]
[TD="bgcolor: #FFFFFF, align: center"]63[/TD]
[TD="bgcolor: #FFFFFF, align: center"]58[/TD]
[TD="bgcolor: #FFFFFF, align: center"]57[/TD]
[TD="bgcolor: #FFFFFF, align: center"]53[/TD]
[TD="bgcolor: #FFFFFF, align: center"]49[/TD]

[TD="align: center"]7[/TD]
[TD="bgcolor: #969696, align: center"]97[/TD]
[TD="bgcolor: #FFFFFF, align: center"]75[/TD]
[TD="bgcolor: #FFFFFF, align: center"]69[/TD]
[TD="bgcolor: #FFFFFF, align: center"]68[/TD]
[TD="bgcolor: #FFFFFF, align: center"]64[/TD]
[TD="bgcolor: #FFFFFF, align: center"]59[/TD]
[TD="bgcolor: #FFFFFF, align: center"]58[/TD]
[TD="bgcolor: #FFFFFF, align: center"]54[/TD]
[TD="bgcolor: #FFFFFF, align: center"]50[/TD]

[TD="align: center"]8[/TD]
[TD="bgcolor: #969696, align: center"]98[/TD]
[TD="bgcolor: #FFFFFF, align: center"]0[/TD]
[TD="bgcolor: #FFFFFF, align: center"]70[/TD]
[TD="bgcolor: #FFFFFF, align: center"]69[/TD]
[TD="bgcolor: #FFFFFF, align: center"]65[/TD]
[TD="bgcolor: #FFFFFF, align: center"]60[/TD]
[TD="bgcolor: #FFFFFF, align: center"]59[/TD]
[TD="bgcolor: #FFFFFF, align: center"]55[/TD]
[TD="bgcolor: #FFFFFF, align: center"]51[/TD]

[TD="align: center"]9[/TD]
[TD="bgcolor: #969696, align: center"]99[/TD]
[TD="bgcolor: #FFFFFF, align: center"]76[/TD]
[TD="bgcolor: #FFFFFF, align: center"]71[/TD]
[TD="bgcolor: #FFFFFF, align: center"]70[/TD]
[TD="bgcolor: #FFFFFF, align: center"]66[/TD]
[TD="bgcolor: #FFFFFF, align: center"]61[/TD]
[TD="bgcolor: #FFFFFF, align: center"]60[/TD]
[TD="bgcolor: #FFFFFF, align: center"]56[/TD]
[TD="bgcolor: #FFFFFF, align: center"]52[/TD]

[TD="align: center"]10[/TD]
[TD="bgcolor: #969696, align: center"]100[/TD]
[TD="bgcolor: #FFFFFF, align: center"]77[/TD]
[TD="bgcolor: #FFFFFF, align: center"]72[/TD]
[TD="bgcolor: #FFFFFF, align: center"]71[/TD]
[TD="bgcolor: #FFFFFF, align: center"]67[/TD]
[TD="bgcolor: #FFFFFF, align: center"]62[/TD]
[TD="bgcolor: #FFFFFF, align: center"]61[/TD]
[TD="bgcolor: #FFFFFF, align: center"]57[/TD]
[TD="bgcolor: #FFFFFF, align: center"]53[/TD]

</tbody>
PFA Conv Table - Sit Ups​
Matty
 
Upvote 0
Hi,

The formula works thanks. I have another where I have used the above formula but its not working and I think it is because of the format I am after. It for a blep test and the result is shown as eg 10'2 which stands for level 10, lap 2.

Formula:
Code: 
= INDEX('PFA Conv Table - MSFT'!$A$7:$A$58,MATCH(U14,INDEX('PFA Conv Table - MSFT'!$B$7:$Q$58,0,MATCH(1,IF('PFA Conv Table - MSFT'!$B$3:$Q$3>=E14,IF('PFA Conv Table - MSFT'!$B$5:$Q$5=F14,1)),0)),1)))

Input table:
Excel 2007
DEFGHIJKLMNOQRSTUVW

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]11[/TD]
[TD="bgcolor: #C0C0C0, align: center"]DOB[/TD]
[TD="bgcolor: #C0C0C0, align: center"]AGE[/TD]
[TD="bgcolor: #C0C0C0, align: center"]M/F[/TD]
[TD="bgcolor: #C0C0C0, align: center"]SQN[/TD]
[TD="bgcolor: #C0C0C0, align: center"]Date of[/TD]
[TD="bgcolor: #C0C0C0, align: center"]Date of Next[/TD]
[TD="bgcolor: #C0C0C0, align: center"]PRESS - UPS[/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"]SIT - UPS[/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"]MSFT[/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]

[TD="align: center"]12[/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"]COY[/TD]
[TD="bgcolor: #C0C0C0, align: center"]Assessment [/TD]
[TD="bgcolor: #C0C0C0, align: center"]Assessment[/TD]
[TD="bgcolor: #C0C0C0, align: center"]SCORE[/TD]
[TD="bgcolor: #C0C0C0, align: center"]POINTS[/TD]
[TD="bgcolor: #C0C0C0, align: center"]RESULT[/TD]
[TD="bgcolor: #C0C0C0, align: center"]SCORE[/TD]
[TD="bgcolor: #C0C0C0, align: center"]POINTS[/TD]
[TD="bgcolor: #C0C0C0, align: center"]RESULT[/TD]
[TD="bgcolor: #C0C0C0, align: center"]MIN[/TD]
[TD="bgcolor: #C0C0C0, align: center"]SEC[/TD]
[TD="bgcolor: #C0C0C0, align: center"]POINTS[/TD]
[TD="bgcolor: #C0C0C0, align: center"]RESULT[/TD]
[TD="bgcolor: #C0C0C0, align: center"]SCORE[/TD]
[TD="bgcolor: #C0C0C0, align: center"]POINTS[/TD]
[TD="bgcolor: #C0C0C0, align: center"]RESULT[/TD]

[TD="align: center"]13[/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]
[TD="bgcolor: #C0C0C0, align: center"][/TD]

[TD="align: center"]14[/TD]
[TD="bgcolor: #FFFF99, align: center"]11/04/90[/TD]
[TD="align: center"]25[/TD]
[TD="bgcolor: #FFFF99, align: center"]M[/TD]
[TD="bgcolor: #FFFF99, align: center"][/TD]
[TD="bgcolor: #FFFF99, align: center"][/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #FFFF99, align: center"][/TD]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #FFFF99, align: center"][/TD]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #FFFF99, align: center"][/TD]
[TD="bgcolor: #FFFF99, align: center"][/TD]
[TD="bgcolor: #FFFFFF, align: center"]0[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #FFFF99, align: center"]11'11[/TD]
[TD="align: center"]85[/TD]
[TD="align: center"]P[/TD]

[TD="align: center"]15[/TD]
[TD="bgcolor: #FFFF99, align: center"]11/04/51[/TD]
[TD="align: center"]64[/TD]
[TD="bgcolor: #FFFF99, align: center"]M[/TD]
[TD="bgcolor: #FFFF99, align: center"][/TD]
[TD="bgcolor: #FFFF99, align: center"][/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #FFFF99, align: center"][/TD]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #FFFF99, align: center"][/TD]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #FFFF99, align: center"][/TD]
[TD="bgcolor: #FFFF99, align: center"][/TD]
[TD="bgcolor: #FFFFFF, align: center"]0[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #FFFF99, align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

</tbody>
PFA​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #E0E0F0"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]L14[/TH]
[TD="align: left"]=IF(J14="","",IF(K14>=70,"P","F"))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]L15[/TH]
[TD="align: left"]=IF(J15="","",IF(K15>=70,"P","F"))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]O14[/TH]
[TD="align: left"]=IF(M14="","",IF(N14>=70,"P","F"))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]O15[/TH]
[TD="align: left"]=IF(M15="","",IF(N15>=70,"P","F"))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]E14[/TH]
[TD="align: left"]=IF(D14="","",DATEDIF(D14,NOW(),"Y"))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]E15[/TH]
[TD="align: left"]=IF(D15="","",DATEDIF(D15,NOW(),"Y"))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]I14[/TH]
[TD="align: left"]=IF(H14="","",DATE(YEAR(H14),MONTH(H14)+IF(Y14="Fail",0,6),DAY(H14)+IF(Y14="Fail",7,0)))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]I15[/TH]
[TD="align: left"]=IF(H15="","",DATE(YEAR(H15),MONTH(H15)+IF(Y15="Fail",0,6),DAY(H15)+IF(Y15="Fail",7,0)))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]T14[/TH]
[TD="align: left"]=IF(Q14="","",IF(S14>=70,"P","F"))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]T15[/TH]
[TD="align: left"]=IF(Q15="","",IF(S15>=70,"P","F"))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]W14[/TH]
[TD="align: left"]=IF(U14="","",IF(V14>=70,"P","F"))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Array Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #E0E0F0"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]K14[/TH]
[TD="align: left"]{=IF(J14="",0,INDEX('PFA Conv Table - Press Ups'!$A$6:$A$57,MATCH(J14,INDEX('PFA Conv Table - Press Ups'!$B$6:$Q$57,0,MATCH(1,IF('PFA Conv Table - Press Ups'!$B$3:$Q$3>=E14,IF('PFA Conv Table - Press Ups'!$B$5:$Q$5=F14,1)),0)),1)))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]K15[/TH]
[TD="align: left"]{=IF(J15="",0,INDEX('PFA Conv Table - Press Ups'!$A$6:$A$57,MATCH(J15,INDEX('PFA Conv Table - Press Ups'!$B$6:$Q$57,0,MATCH(1,IF('PFA Conv Table - Press Ups'!$B$3:$Q$3>=E15,IF('PFA Conv Table - Press Ups'!$B$5:$Q$5=F15,1)),0)),1)))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]N14[/TH]
[TD="align: left"]{=IF(M14="",0,INDEX('PFA Conv Table - Sit Ups'!A$6:A$57,MATCH(M14,INDEX('PFA Conv Table - Sit Ups'!B$6:I$57,0,MATCH(1,IF('PFA Conv Table - Sit Ups'!B$3:I$3>=E14,1),0)),1)))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]N15[/TH]
[TD="align: left"]{=IF(M15="",0,INDEX('PFA Conv Table - Sit Ups'!A$6:A$57,MATCH(M15,INDEX('PFA Conv Table - Sit Ups'!B$6:I$57,0,MATCH(1,IF('PFA Conv Table - Sit Ups'!B$3:I$3>=E15,1),0)),1)))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]S14[/TH]
[TD="align: left"]{=IF(P14=0,0,INDEX('PFA Conv Table - 1.5 Mile Run'!$A$6:$A$57,MATCH(PFA!P14,INDEX('PFA Conv Table - 1.5 Mile Run'!$B$6:$BM$57,0,MATCH(1,IF('PFA Conv Table - 1.5 Mile Run'!$B$3:$BM$3>=PFA!E14,IF('PFA Conv Table - 1.5 Mile Run'!$B$5:$BM$5=PFA!F14,1)),0)-2),1)))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]S15[/TH]
[TD="align: left"]{=IF(P15=0,0,INDEX('PFA Conv Table - 1.5 Mile Run'!$A$6:$A$57,MATCH(PFA!P15,INDEX('PFA Conv Table - 1.5 Mile Run'!$B$6:$BM$57,0,MATCH(1,IF('PFA Conv Table - 1.5 Mile Run'!$B$3:$BM$3>=PFA!E15,IF('PFA Conv Table - 1.5 Mile Run'!$B$5:$BM$5=PFA!F15,1)),0)-2),1)))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]V14[/TH]
[TD="align: left"]{=IF(U14="",0,INDEX('PFA Conv Table - MSFT'!$A$7:$A$58,MATCH(U14,INDEX('PFA Conv Table - MSFT'!$B$7:$Q$58,0,MATCH(1,IF('PFA Conv Table - MSFT'!$B$3:$Q$3>=E14,IF('PFA Conv Table - MSFT'!$B$5:$Q$5=F14,1)),0)),1)))}[/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]

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Workbook Defined Names[TABLE="width: 100%"]
<thead>[TR="bgcolor: #E0E0F0"]
[TH="width: 10px"]Name[/TH]
[TH="align: left"]Refers To[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]PF[/TH]
[TD="align: left"]=List!$E$2:$E$3[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #E0E0F0"]PFA[/TH]
[TD="align: left"]=List!#REF![/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]






The results table in the next post.
 
Last edited:
Upvote 0
Results Table:
Excel 2007
ABCDEFGHIJKLMNOPQ

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]4[/TD]
[TD="bgcolor: #969696, align: center"]Age Group[/TD]
[TD="bgcolor: #969696, align: center"]< 30[/TD]
[TD="bgcolor: #969696, align: center"][/TD]
[TD="bgcolor: #969696, align: center"]30 - 34[/TD]
[TD="bgcolor: #969696, align: center"][/TD]
[TD="bgcolor: #969696, align: center"]35 - 39[/TD]
[TD="bgcolor: #969696, align: center"][/TD]
[TD="bgcolor: #969696, align: center"]40 - 44[/TD]
[TD="bgcolor: #969696, align: center"][/TD]
[TD="bgcolor: #969696, align: center"]45 - 49[/TD]
[TD="bgcolor: #969696, align: center"][/TD]
[TD="bgcolor: #969696, align: center"]50 - 54[/TD]
[TD="bgcolor: #969696, align: center"][/TD]
[TD="bgcolor: #969696, align: center"]55 - 59[/TD]
[TD="bgcolor: #969696, align: center"][/TD]
[TD="bgcolor: #969696, align: center"]60 - 64[/TD]
[TD="bgcolor: #969696, align: center"][/TD]

[TD="align: center"]5[/TD]
[TD="bgcolor: #969696, align: center"]Gender[/TD]
[TD="bgcolor: #969696, align: center"]M[/TD]
[TD="bgcolor: #969696, align: center"]F[/TD]
[TD="bgcolor: #969696, align: center"]M[/TD]
[TD="bgcolor: #969696, align: center"]F[/TD]
[TD="bgcolor: #969696, align: center"]M[/TD]
[TD="bgcolor: #969696, align: center"]F[/TD]
[TD="bgcolor: #969696, align: center"]M[/TD]
[TD="bgcolor: #969696, align: center"]F[/TD]
[TD="bgcolor: #969696, align: center"]M[/TD]
[TD="bgcolor: #969696, align: center"]F[/TD]
[TD="bgcolor: #969696, align: center"]M[/TD]
[TD="bgcolor: #969696, align: center"]F[/TD]
[TD="bgcolor: #969696, align: center"]M[/TD]
[TD="bgcolor: #969696, align: center"]F[/TD]
[TD="bgcolor: #969696, align: center"]M[/TD]
[TD="bgcolor: #969696, align: center"]F[/TD]

[TD="align: center"]6[/TD]
[TD="bgcolor: #969696, align: center"]Points[/TD]
[TD="bgcolor: #969696, align: center"]Level/Lap[/TD]
[TD="bgcolor: #969696, align: center"]Level/Lap[/TD]
[TD="bgcolor: #969696, align: center"]Level/Lap[/TD]
[TD="bgcolor: #969696, align: center"]Level/Lap[/TD]
[TD="bgcolor: #969696, align: center"]Level/Lap[/TD]
[TD="bgcolor: #969696, align: center"]Level/Lap[/TD]
[TD="bgcolor: #969696, align: center"]Level/Lap[/TD]
[TD="bgcolor: #969696, align: center"]Level/Lap[/TD]
[TD="bgcolor: #969696, align: center"]Level/Lap[/TD]
[TD="bgcolor: #969696, align: center"]Level/Lap[/TD]
[TD="bgcolor: #969696, align: center"]Level/Lap[/TD]
[TD="bgcolor: #969696, align: center"]Level/Lap[/TD]
[TD="bgcolor: #969696, align: center"]Level/Lap[/TD]
[TD="bgcolor: #969696, align: center"]Level/Lap[/TD]
[TD="bgcolor: #969696, align: center"]Level/Lap[/TD]
[TD="bgcolor: #969696, align: center"]Level/Lap[/TD]

[TD="align: center"]7[/TD]
[TD="bgcolor: #969696, align: center"]0[/TD]
[TD="bgcolor: #D8D8D8, align: center"]0'0[/TD]
[TD="align: center"]0[/TD]
[TD="bgcolor: #D8D8D8, align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="bgcolor: #D8D8D8, align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="bgcolor: #D8D8D8, align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="bgcolor: #D8D8D8, align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="bgcolor: #D8D8D8, align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="bgcolor: #D8D8D8, align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="bgcolor: #D8D8D8, align: center"]0[/TD]
[TD="align: center"]0[/TD]

[TD="align: center"]8[/TD]
[TD="bgcolor: #969696, align: center"]50[/TD]
[TD="bgcolor: #D8D8D8, align: center"]8'10[/TD]
[TD="align: center"]6'5[/TD]
[TD="bgcolor: #D8D8D8, align: center"]8'4[/TD]
[TD="align: center"]6'1[/TD]
[TD="bgcolor: #D8D8D8, align: center"]7'9[/TD]
[TD="align: center"]5'6[/TD]
[TD="bgcolor: #D8D8D8, align: center"]7'4[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"]6'9[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"]5'8[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"]9[/TD]
[TD="bgcolor: #969696, align: center"]51[/TD]
[TD="bgcolor: #D8D8D8, align: center"]9'0[/TD]
[TD="align: center"]6'6[/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"]6'2[/TD]
[TD="bgcolor: #D8D8D8, align: center"]8'0[/TD]
[TD="align: center"]5'7[/TD]
[TD="bgcolor: #D8D8D8, align: center"]7'5[/TD]
[TD="align: center"]5'3[/TD]
[TD="bgcolor: #D8D8D8, align: center"]7'0[/TD]
[TD="align: center"]4'8[/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"]10[/TD]
[TD="bgcolor: #969696, align: center"]52[/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"]8'5[/TD]
[TD="align: center"]6'3[/TD]
[TD="bgcolor: #D8D8D8, align: center"]8'1[/TD]
[TD="align: center"]5'8[/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"]5'4[/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"]5'0[/TD]
[TD="bgcolor: #D8D8D8, align: center"]6'0[/TD]
[TD="align: center"]4'0[/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"]11[/TD]
[TD="bgcolor: #969696, align: center"]53[/TD]
[TD="bgcolor: #D8D8D8, align: center"]9'1[/TD]
[TD="align: center"]6'7[/TD]
[TD="bgcolor: #D8D8D8, align: center"]8'6[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"]6'0[/TD]
[TD="bgcolor: #D8D8D8, align: center"]7'6[/TD]
[TD="align: center"]5'5[/TD]
[TD="bgcolor: #D8D8D8, align: center"]7'1[/TD]
[TD="align: center"]5'1[/TD]
[TD="bgcolor: #D8D8D8, align: center"]6'1[/TD]
[TD="align: center"]4'1[/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"]12[/TD]
[TD="bgcolor: #969696, align: center"]54[/TD]
[TD="bgcolor: #D8D8D8, align: center"]9'2[/TD]
[TD="align: center"]6'8[/TD]
[TD="bgcolor: #D8D8D8, align: center"]8'7[/TD]
[TD="align: center"]6'4[/TD]
[TD="bgcolor: #D8D8D8, align: center"]8'2[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"]7'7[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"]7'2[/TD]
[TD="align: center"]5'2[/TD]
[TD="bgcolor: #D8D8D8, align: center"]6'2[/TD]
[TD="align: center"]4'2[/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"]13[/TD]
[TD="bgcolor: #969696, align: center"]55[/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"]6'9[/TD]
[TD="bgcolor: #D8D8D8, align: center"]8'8[/TD]
[TD="align: center"]6'5[/TD]
[TD="bgcolor: #D8D8D8, align: center"]8'3[/TD]
[TD="align: center"]6'1[/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"]5'6[/TD]
[TD="bgcolor: #D8D8D8, align: center"]7'3[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"]6'3[/TD]
[TD="align: center"]4'3[/TD]
[TD="bgcolor: #D8D8D8, align: center"]5'8[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"]14[/TD]
[TD="bgcolor: #969696, align: center"]56[/TD]
[TD="bgcolor: #D8D8D8, align: center"]9'3[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"]6'6[/TD]
[TD="bgcolor: #D8D8D8, align: center"]8'4[/TD]
[TD="align: center"]6'2[/TD]
[TD="bgcolor: #D8D8D8, align: center"]7'8[/TD]
[TD="align: center"]5'7[/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"]5'3[/TD]
[TD="bgcolor: #D8D8D8, align: center"]6'4[/TD]
[TD="align: center"]4'4[/TD]
[TD="bgcolor: #D8D8D8, align: center"]6'0[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"]15[/TD]
[TD="bgcolor: #969696, align: center"]57[/TD]
[TD="bgcolor: #D8D8D8, align: center"]9'4[/TD]
[TD="align: center"]7'0[/TD]
[TD="bgcolor: #D8D8D8, align: center"]8'9[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"]6'3[/TD]
[TD="bgcolor: #D8D8D8, align: center"]7'9[/TD]
[TD="align: center"]5'8[/TD]
[TD="bgcolor: #D8D8D8, align: center"]7'4[/TD]
[TD="align: center"]5'4[/TD]
[TD="bgcolor: #D8D8D8, align: center"]6'5[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"]6'1[/TD]
[TD="align: center"]4'0[/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"][/TD]

[TD="align: center"]16[/TD]
[TD="bgcolor: #969696, align: center"]58[/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"]7'1[/TD]
[TD="bgcolor: #D8D8D8, align: center"]8'10[/TD]
[TD="align: center"]6'7[/TD]
[TD="bgcolor: #D8D8D8, align: center"]8'5[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"]8'0[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"]7'5[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"]6'6[/TD]
[TD="align: center"]4'5[/TD]
[TD="bgcolor: #D8D8D8, align: center"]6'2[/TD]
[TD="align: center"]4'1[/TD]
[TD="bgcolor: #D8D8D8, align: center"]5'8[/TD]
[TD="align: center"][/TD]

[TD="align: center"]17[/TD]
[TD="bgcolor: #969696, align: center"]59[/TD]
[TD="bgcolor: #D8D8D8, align: center"]9'5[/TD]
[TD="align: center"]7'2[/TD]
[TD="bgcolor: #D8D8D8, align: center"]9'0[/TD]
[TD="align: center"]6'8[/TD]
[TD="bgcolor: #D8D8D8, align: center"]8'6[/TD]
[TD="align: center"]6'4[/TD]
[TD="bgcolor: #D8D8D8, align: center"]8'1[/TD]
[TD="align: center"]6'0[/TD]
[TD="bgcolor: #D8D8D8, align: center"]7'6[/TD]
[TD="align: center"]5'5[/TD]
[TD="bgcolor: #D8D8D8, align: center"]6'7[/TD]
[TD="align: center"]4'6[/TD]
[TD="bgcolor: #D8D8D8, align: center"]6'3[/TD]
[TD="align: center"]4'2[/TD]
[TD="bgcolor: #D8D8D8, align: center"]6'1[/TD]
[TD="align: center"][/TD]

[TD="align: center"]18[/TD]
[TD="bgcolor: #969696, align: center"]60[/TD]
[TD="bgcolor: #D8D8D8, align: center"]9'6[/TD]
[TD="align: center"]7'3[/TD]
[TD="bgcolor: #D8D8D8, align: center"]9'1[/TD]
[TD="align: center"]6'9[/TD]
[TD="bgcolor: #D8D8D8, align: center"]8'7[/TD]
[TD="align: center"]6'5[/TD]
[TD="bgcolor: #D8D8D8, align: center"]8'2[/TD]
[TD="align: center"]6'1[/TD]
[TD="bgcolor: #D8D8D8, align: center"]7'7[/TD]
[TD="align: center"]5'6[/TD]
[TD="bgcolor: #D8D8D8, align: center"]6'8[/TD]
[TD="align: center"]4'7[/TD]
[TD="bgcolor: #D8D8D8, align: center"]6'4[/TD]
[TD="align: center"]4'3[/TD]
[TD="bgcolor: #D8D8D8, align: center"]6'2[/TD]
[TD="align: center"]4'0[/TD]

[TD="align: center"]19[/TD]
[TD="bgcolor: #969696, align: center"]61[/TD]
[TD="bgcolor: #D8D8D8, align: center"]9'7[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"]6'6[/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"]6'2[/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"]5'7[/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"]4'8[/TD]
[TD="bgcolor: #D8D8D8, align: center"]6'5[/TD]
[TD="align: center"]4'4[/TD]
[TD="bgcolor: #D8D8D8, align: center"]6'3[/TD]
[TD="align: center"][/TD]

[TD="align: center"]20[/TD]
[TD="bgcolor: #969696, align: center"]62[/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"]7'4[/TD]
[TD="bgcolor: #D8D8D8, align: center"]9'2[/TD]
[TD="align: center"]7'0[/TD]
[TD="bgcolor: #D8D8D8, align: center"]8'8[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"]8'3[/TD]
[TD="align: center"]6'3[/TD]
[TD="bgcolor: #D8D8D8, align: center"]7'8[/TD]
[TD="align: center"]5'8[/TD]
[TD="bgcolor: #D8D8D8, align: center"]6'9[/TD]
[TD="align: center"]5'0[/TD]
[TD="bgcolor: #D8D8D8, align: center"]6'6[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"]6'4[/TD]
[TD="align: center"][/TD]

[TD="align: center"]21[/TD]
[TD="bgcolor: #969696, align: center"]63[/TD]
[TD="bgcolor: #D8D8D8, align: center"]9'8[/TD]
[TD="align: center"]7'5[/TD]
[TD="bgcolor: #D8D8D8, align: center"]9'3[/TD]
[TD="align: center"]7'1[/TD]
[TD="bgcolor: #D8D8D8, align: center"]8'9[/TD]
[TD="align: center"]6'7[/TD]
[TD="bgcolor: #D8D8D8, align: center"]8'4[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"]7'9[/TD]
[TD="align: center"]6'0[/TD]
[TD="bgcolor: #D8D8D8, align: center"]7'0[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"]6'7[/TD]
[TD="align: center"]4'5[/TD]
[TD="bgcolor: #D8D8D8, align: center"]6'5[/TD]
[TD="align: center"][/TD]

[TD="align: center"]22[/TD]
[TD="bgcolor: #969696, align: center"]64[/TD]
[TD="bgcolor: #D8D8D8, align: center"]9'9[/TD]
[TD="align: center"]7'6[/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"]7'2[/TD]
[TD="bgcolor: #D8D8D8, align: center"]8'10[/TD]
[TD="align: center"]6'8[/TD]
[TD="bgcolor: #D8D8D8, align: center"]8'5[/TD]
[TD="align: center"]6'4[/TD]
[TD="bgcolor: #D8D8D8, align: center"]8'0[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"]7'1[/TD]
[TD="align: center"]5'1[/TD]
[TD="bgcolor: #D8D8D8, align: center"]6'8[/TD]
[TD="align: center"]4'6[/TD]
[TD="bgcolor: #D8D8D8, align: center"]6'6[/TD]
[TD="align: center"]4'1[/TD]

[TD="align: center"]23[/TD]
[TD="bgcolor: #969696, align: center"]65[/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"]7'7[/TD]
[TD="bgcolor: #D8D8D8, align: center"]9'4[/TD]
[TD="align: center"]7'3[/TD]
[TD="bgcolor: #D8D8D8, align: center"]9'0[/TD]
[TD="align: center"]6'9[/TD]
[TD="bgcolor: #D8D8D8, align: center"]8'6[/TD]
[TD="align: center"]6'5[/TD]
[TD="bgcolor: #D8D8D8, align: center"]8'1[/TD]
[TD="align: center"]6'1[/TD]
[TD="bgcolor: #D8D8D8, align: center"]7'2[/TD]
[TD="align: center"]5'2[/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"]4'7[/TD]
[TD="bgcolor: #D8D8D8, align: center"]6'7[/TD]
[TD="align: center"]4'2[/TD]

[TD="align: center"]24[/TD]
[TD="bgcolor: #969696, align: center"]66[/TD]
[TD="bgcolor: #D8D8D8, align: center"]9'10[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"]9'5[/TD]
[TD="align: center"][/TD]
[TD="bgcolor: #D8D8D8, align: center"][/TD]
[TD="align: center"]7'0[/TD]
[TD="bgcolor: #D8D8D8, align: center"]8'7[/TD]
[TD="align: center"]6'6[/TD]
[TD="bgcolor: #D8D8D8, align: center"]8'2[/TD]
[TD="align: center"]6'2[/TD]
[TD="bgcolor: #D8D8D8, align: center"]7'3[/TD]
[TD="align: center"]5'3[/TD]
[TD="bgcolor: #D8D8D8, align: center"]6'9[/TD]
[TD="align: center"]4'8[/TD]
[TD="bgcolor: #D8D8D8, align: center"]6'8[/TD]
[TD="align: center"]4'3[/TD]

</tbody>
PFA Conv Table - MSFT​



I have also tried 11/11 as a format but this doesn't work either. I know it works if I use 11.11 but this will be an issue when using 10.10 (level 10, lap 10) as it will show as 10.1 (level 10, lap 1) if you see what i mean. Any ideas how I can get this to work with either formats???

Your continued help is greatly appreciated

Matt
 
Last edited:
Upvote 0
Hi,

Is there a unique Level/Lap for each Point available per Age Group and Gender? Your data suggests not, but could there be?

This would be the only way I think you could do this.

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

Similar threads

J
  • Solved
Google Sheets Formula Help
Replies
5
Views
439
Jewells0905
J
1
  • Question Question
Index + Match on a table: when sorting table options, I+M breaks
Replies
1
Views
1K
Fluff
Fluff
T
  • Solved
Sumproduct data on different sheets and multiple criteria
Replies
3
Views
843
Fluff
Fluff
J
  • Solved
Named ranges/functions formula trouble with Google Sheets
Replies
1
Views
401
Jewells0905
J
W
  • Solved
Removing Data Validation List Items Once Selected In Another Cell
Replies
3
Views
788
James006
James006

Forum statistics

Threads
1,224,798
Messages
6,181,038
Members
453,014
Latest member
Chris258

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