Forcing Moving down the Array

V

vincecodegreeen

New Member
Joined
Jan 17, 2014
Messages
39
[TABLE="width: 594"]
<tbody>[TR]
[TD][/TD]
[TD]Meal 1[/TD]
[TD]Meal 2[/TD]
[TD]Meal 3[/TD]
[TD]Meal 4[/TD]
[TD]Meal 5[/TD]
[TD]Meal 6[/TD]
[TD]Meal 7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Tot Meal Cals[/TD]
[TD]710[/TD]
[TD]479[/TD]
[TD]710[/TD]
[TD]479[/TD]
[TD]710[/TD]
[TD]231[/TD]
[TD]231[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Protein[/TD]
[TD]142[/TD]
[TD]311[/TD]
[TD]284[/TD]
[TD]311[/TD]
[TD]497[/TD]
[TD]185[/TD]
[TD]115[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Carbs[/TD]
[TD]355[/TD]
[TD]168[/TD]
[TD]284[/TD]
[TD]120[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]115[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Fat[/TD]
[TD]106[/TD]
[TD]0[/TD]
[TD]106[/TD]
[TD]48[/TD]
[TD]106[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Fruits/Vegs[/TD]
[TD]106[/TD]
[TD]0[/TD]
[TD]35[/TD]
[TD]0[/TD]
[TD]106[/TD]
[TD]46[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]array[/TD]
[TD="colspan: 7"]CELL("address",OFFSET(B5:H5,0,MATCH(LARGE(B5:H5,4),B5:H5,0)-1))[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]$B$5[/TD]
[TD]Largest[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]$B$5[/TD]
[TD="colspan: 2"]2nd Largest[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]$B$5[/TD]
[TD="colspan: 2"]3rd Largest[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]$E$5[/TD]
[TD="colspan: 2"]4th Largest[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

This Array {= CELL("address",OFFSET(B5:H5,0,MATCH(LARGE(B5:H5,4),B5:H5,0)-1))} returns the cell address $B$5, whether the k value is 1, 2 or 3. Only when it is 4 does it select another address..
Since there is another condition that needs to be met outside this formula I need it to select the next large value in the array even though it is the same value. I had hoped that by changing the k value it would move down the array but it doesn’t.
Can anyone help?
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Sort by date Sort by votes
I've pasted your info and formula into a spread sheet to see what your formula does. I know you see that the reason your cell address doesn't change until you pick the 4th. largest is because there are 3 X 106's in the range you are searching.
When you say move down the array do you mean go down to the next row for a value, because you have a 0 in the row offset argument in your formula. If you could be more specific as to exactly what your doing and hope to achieve I would be glad to help you.

Also I don't know if you know this, but you don't have to hit Control Shift Enter for this formula, it works fine with Enter.
 
Last edited:
Upvote 0
Thanks Skywriter,
As I hit the post button I realised I should have said "across the array", "down" just being a colloquialism.
Yes there are three 106's but the first is associated with another factor related to that meal outside this code and I need to progress the selection to the next "106". So I tested for that condition and instructed the code to change the k factor to 2, 3, and then 4 should that factor be found. But I found is it always selects the first of duplicates.

Yes, I noticed it works without the ctl, shift, enter but I originally wrote this in VBA and there it required activecell.FormulaArray.

I hope that explains it. Any Ideas?
 
Upvote 0
How about a custom function. I plugged it in and it seems to work, let me know if you need any more help.

Sheet17

*
ABCDEFGH
*Meal 1Meal 2Meal 3Meal 4
Meal 5Meal 6Meal 7
Tot Meal Cals
Protein
Carbs
Fat
Fruits/Vegs
********
Row 2 Test$F$2******
Row 3 Test$F$3******
Row 5 Test$B$4******
Row 6 Test$F$5******

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:113px;"><col style="width:113px;"><col style="width:113px;"><col style="width:113px;"><col style="width:113px;"><col style="width:113px;"><col style="width:113px;"><col style="width:113px;"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]

[TD="align: right"]710[/TD]
[TD="align: right"]479[/TD]
[TD="align: right"]710[/TD]
[TD="align: right"]479[/TD]
[TD="bgcolor: #ffff00, align: right"]710[/TD]
[TD="align: right"]231[/TD]
[TD="align: right"]231[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]

[TD="align: right"]142[/TD]
[TD="align: right"]311[/TD]
[TD="align: right"]284[/TD]
[TD="align: right"]311[/TD]
[TD="bgcolor: #ffff00, align: right"]497[/TD]
[TD="align: right"]185[/TD]
[TD="align: right"]115[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]

[TD="bgcolor: #ffff00, align: right"]355[/TD]
[TD="align: right"]168[/TD]
[TD="align: right"]284[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]115[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]

[TD="align: right"]106[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]106[/TD]
[TD="align: right"]48[/TD]
[TD="bgcolor: #ffff00, align: right"]106[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]

[TD="align: right"]106[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]0[/TD]
[TD="bgcolor: #ffff00, align: right"]106[/TD]
[TD="align: right"]46[/TD]
[TD="align: right"]0[/TD]

[TD="bgcolor: #cacaca, align: center"]7[/TD]

[TD="bgcolor: #cacaca, align: center"]8[/TD]

[TD="bgcolor: #cacaca, align: center"]9[/TD]

[TD="bgcolor: #cacaca, align: center"]10[/TD]

[TD="bgcolor: #cacaca, align: center"]11[/TD]

</tbody>

Spreadsheet Formulas
CellFormula
B8=LastLargeAddress(B2:H2)
B9=LastLargeAddress(B3:H3)
B10=LastLargeAddress(B4:H4)
B11=LastLargeAddress(B5:H5)

<tbody>
</tbody>

<tbody>
</tbody>


Excel tables to the web >> Excel Jeanie HTML 4



Code: 
Function LastLargeAddress(SelectedRange As Range)

Dim rngSelected As Range
Dim lngCellValue As Long
Dim strLastAddress As String
Dim c As Range

Set rngSelected = SelectedRange

For Each c In SelectedRange

    If lngCellValue <= c.Value Then
    
    lngCellValue = c.Value
    strLastAddress = c.Address
    
    End If

Next c

LastLargeAddress = strLastAddress


End Function
 
Last edited:
Upvote 0
Ignore the post above, I got ahead of myself with the copying and pasting.


Excel Workbook
ABCDEFGH
1Meal 1Meal 2Meal 3Meal 4Meal 5Meal 6Meal 7
2Tot Meal Cals710479710479710231231
3Protein142311284311497185115
4Carbs35516828412000115
5Fat10601064810600
6Fruits/Vegs1060350106460
7
8Row 2 Test$F$2
9Row 3 Test$F$3
10Row 4 Test$B$4
11Row 5 Test$F$5
12Row 6 Test$F$6
Sheet17





Code: 
Function LastLargeAddress(SelectedRange As Range)

Dim rngSelected As Range
Dim lngCellValue As Long
Dim strLastAddress As String
Dim c As Range

Set rngSelected = SelectedRange

For Each c In SelectedRange

    If lngCellValue <= c.Value Then
    
    lngCellValue = c.Value
    strLastAddress = c.Address
    
    End If

Next c

LastLargeAddress = strLastAddress


End Function
 
Upvote 0
Hi Skywriter,
So what this does is lists the last one instead of the first one.
What I need is to delete a selection from the array when it is found to have a certain condition associated with it outside this function. It is possible that the last one also has this condition or for that matter any of the equally large cell values.
Thanks for trying.
Any other ideas?
 
Upvote 0
Well it comes up with the last large, but only if there is more than one, if there is only one it just picks the largest. If you share exactly what you are trying to accomplish I bet I can help you, but saying one thing depends on another condition so forth doesn't help me much. i need to see all the data and criteria and know exactly what you want to do.

Let me know I do this because I enjoy the challenge and learn from these challenges.

If you have sensitive information, just replace it with made up stuff like Jane Doe, Acct#1234, 123 Main St., Anytown USA etc etc.
 
Upvote 0
This table helps populate a meal plan with the calorie allotment per food type and meal, factored against the food’s calorie density (i.e. how many calories per gram etc.). But sometimes the food is in units not grams. For instance an egg is 60 calories of fat. So if the allotment is 106 as in the above case the formula rounds it off to 2 eggs and reports the excess (120-106=14 calories), which need to be deducted from another meals allotment for fat.
So I set out to find another meal with the max calories so the 14 aren’t missed. Hence the Largest function. When the cell address is returned I need to check that it isn’t also in units as this would not accomplish anything (and in particular not the same cell that generated the excess, as occurs in this case).
I am including the meal plan table and a snapshot of the code I am using. I don’t know how much of this will still be functional when you get it but hopefully your ?? are answered.

[TABLE="width: 607"]
<colgroup><col><col><col><col><col><col><col span="3"></colgroup><tbody>[TR]
[TD]Meal no.[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Food type[/TD]
[TD]Amount[/TD]
[TD]unit[/TD]
[TD="colspan: 2"]Unit cal excess/short[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]MEAL 1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Protein[/TD]
[TD="align: right"]4[/TD]
[TD]per[/TD]
[TD]gram[/TD]
[TD]Whey Protein Powder[/TD]
[TD]35[/TD]
[TD]grams[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Carbs[/TD]
[TD="align: right"]3.33[/TD]
[TD]per[/TD]
[TD]gram[/TD]
[TD]Rolled Oats[/TD]
[TD]107[/TD]
[TD]grams[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Fats[/TD]
[TD]60[/TD]
[TD]per[/TD]
[TD]unit[/TD]
[TD]Whole Eggs[/TD]
[TD]2[/TD]
[TD]units[/TD]
[TD="align: right"]14[/TD]
[TD]cal excess/short[/TD]
[/TR]
[TR]
[TD]Fruit/Veggies[/TD]
[TD="align: right"]0.47[/TD]
[TD]per[/TD]
[TD]gram[/TD]
[TD]Mixed Berries[/TD]
[TD]227[/TD]
[TD]grams[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]MEAL 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Protein[/TD]
[TD="align: right"]1.5[/TD]
[TD]per[/TD]
[TD]gram[/TD]
[TD]Lean Minced Beef[/TD]
[TD]208[/TD]
[TD]grams[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Carbs[/TD]
[TD="align: right"]1.2[/TD]
[TD]per[/TD]
[TD]gram[/TD]
[TD]Basmati Rice[/TD]
[TD]140[/TD]
[TD]grams[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Fats[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Fruit/Veggies[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]MEAL 3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Protein[/TD]
[TD="align: right"]1.2[/TD]
[TD]per[/TD]
[TD]gram[/TD]
[TD]Chicken Breast[/TD]
[TD]237[/TD]
[TD]grams[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Carbs[/TD]
[TD="align: right"]0.75[/TD]
[TD]per[/TD]
[TD]gram[/TD]
[TD]Kumera[/TD]
[TD]379[/TD]
[TD]grams[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Fats[/TD]
[TD="align: right"]2.3[/TD]
[TD]per[/TD]
[TD]gram[/TD]
[TD]Avocado[/TD]
[TD]46[/TD]
[TD]grams[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Fruit/Veggies[/TD]
[TD="align: right"]0.3[/TD]
[TD]per[/TD]
[TD]gram[/TD]
[TD]Approved Vegetables[/TD]
[TD]118[/TD]
[TD]grams[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]MEAL 4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Protein[/TD]
[TD="align: right"]1.2[/TD]
[TD]per[/TD]
[TD]gram[/TD]
[TD]Chicken Breast[/TD]
[TD]260[/TD]
[TD]grams[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Carbs[/TD]
[TD="align: right"]0.75[/TD]
[TD]per[/TD]
[TD]gram[/TD]
[TD]Kumera[/TD]
[TD]160[/TD]
[TD]grams[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Fats[/TD]
[TD="align: right"]2.3[/TD]
[TD]per[/TD]
[TD]gram[/TD]
[TD]Avocado[/TD]
[TD]21[/TD]
[TD]grams[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Fruit/Veggies[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]MEAL 5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Protein[/TD]
[TD="align: right"]1.2[/TD]
[TD]per[/TD]
[TD]gram[/TD]
[TD]Chicken Breast[/TD]
[TD]414[/TD]
[TD]grams[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Carbs[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Fats[/TD]
[TD="align: right"]8[/TD]
[TD]per[/TD]
[TD]ml[/TD]
[TD]Lite Olive Oil[/TD]
[TD]13[/TD]
[TD]mls[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Fruit/Veggies[/TD]
[TD="align: right"]0.3[/TD]
[TD]per[/TD]
[TD]gram[/TD]
[TD]Approved Vegetables[/TD]
[TD]355[/TD]
[TD]grams[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]MEAL 6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Protein[/TD]
[TD="align: right"]4[/TD]
[TD]per[/TD]
[TD]gram[/TD]
[TD]Whey Protein Powder[/TD]
[TD]46[/TD]
[TD]grams[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Carbs[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Fats[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Fruit/Veggies[/TD]
[TD="align: right"]0.47[/TD]
[TD]per[/TD]
[TD]gram[/TD]
[TD]Mixed Berries[/TD]
[TD]98[/TD]
[TD]grams[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]MEAL 7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Protein[/TD]
[TD="align: right"]4[/TD]
[TD]per[/TD]
[TD]gram[/TD]
[TD]Whey Protein Powder[/TD]
[TD]29[/TD]
[TD]grams[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Carbs[/TD]
[TD="align: right"]1[/TD]
[TD]per[/TD]
[TD]gram[/TD]
[TD]Banana[/TD]
[TD]115[/TD]
[TD]grams[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Fats[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Fruit/Veggies[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]N/A[/TD]
[TD]N/A[/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Meal adjusted[/TD]
[TD]Adjusted allotment [/TD]
[TD][/TD]
[TD]TDC cell[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: right"]0[/TD]
[TD]Total excess/shortage Protein[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: right"]0[/TD]
[TD]Total excess/shortage Protein[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: right"]14[/TD]
[TD]Total excess/shortage Fats[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD="align: right"]0[/TD]
[TD]Total excess/shortage Fruits/Veggies[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: left"]
clip_image001.png

<tbody>
</tbody>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Sub ReassignExcessCals()
Application.ScreenUpdating = False
Dim units As String
Dim wkb As Workbook
Dim ws As Worksheet
Dim mealname As String
Dim quantity As String
Set wkb = ThisWorkbook
k = 7
l = "G"
Sheet22.Activate
Range("A47:G54").Select
Range("G54").Activate
Selection.ClearContents
Range("g47").Select
For j = 1 To 4
If Abs(activecell.Offset(0, 1)) >= 10 Then


For i = 1 To 4
activecell.Offset(4, 1).Value = i
If activecell.Offset(, 1) >= 0 Then
activecell.FormulaArray = _
"=CELL(""address"",OFFSET(TDC!R[-38]C[-5],0,MATCH(LARGE(TDC!R[-38]C[-5]:TDC!R[-38]C[-4]:TDC!R[-38]C[-3]:TDC!R[-38]C[-2]:TDC!R[-38]C[-1]:TDC!R[-38]C[0]:TDC!R[-38]C[1],R[4]C[1]),TDC!R[-38]C[-5]:R[-38]C[1],0)-1))"
'in the above line I am listing each cell separately in lieu of an array which I hoped that after testing if it was a unit it could be eliminated from the search.
Else
activecell.FormulaArray = _
"=CELL(""address"",OFFSET(TDC!R[-38]C[-5],0,MATCH(SMALL(IF(TDC!R[-38]C[-5]:R[-38]C[1]>0,(TDC!R[-38]C[-5]:R[-38]C[1])),R[4]C[1]),TDC!R[-38]C[-5]:R[-38]C[1],0)-1))"
End If
'Find its Cell Address




Call CellAddress(j, k, l)
'Qualify quantity type


activecell.Offset(4, 0).Value = "=INDIRECT(R[-4]C[-1])"
If activecell.Offset(4, 0).Value <> "units" Then
Exit For
Else
End If
Next i


End If
Cells(47 + j, 7).Select


Next j


End Sub
 
Upvote 0
Okay, thanks for the response the only issue I see with looking at your code is I can't tell what cells your data is in because there are no margins with rows and column labels. Your code references specific ranges, so I would need some help there.
 
Upvote 0
The first table is on sheet TDC; the second is on sheet22.
[TABLE="width: 754"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[TD]I
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD][/TD]
[TD]Meal 1
[/TD]
[TD]Meal 2
[/TD]
[TD]Meal 3
[/TD]
[TD]Meal 4
[/TD]
[TD]Meal 5
[/TD]
[TD]Meal 6
[/TD]
[TD]Meal 7
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Tot Meal Cals
[/TD]
[TD]710
[/TD]
[TD]479
[/TD]
[TD]710
[/TD]
[TD]479
[/TD]
[TD]710
[/TD]
[TD]231
[/TD]
[TD]231
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Protein
[/TD]
[TD]142
[/TD]
[TD]311
[/TD]
[TD]284
[/TD]
[TD]311
[/TD]
[TD]497
[/TD]
[TD]185
[/TD]
[TD]115
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]Carbs
[/TD]
[TD]355
[/TD]
[TD]168
[/TD]
[TD]284
[/TD]
[TD]120
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]115
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]Fat
[/TD]
[TD]106
[/TD]
[TD]0
[/TD]
[TD]106
[/TD]
[TD]48
[/TD]
[TD]106
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]
[TABLE="width: 102"]
<tbody>[TR]
[TD]TDC!R[-38]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]Fruits/Vegs
[/TD]
[TD]106
[/TD]
[TD]0
[/TD]
[TD]35
[/TD]
[TD]0
[/TD]
[TD]106
[/TD]
[TD]46
[/TD]
[TD]0
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD][/TD]
[TD]
TDC!C[-5]

<tbody>
</tbody>
[/TD]
[TD]TDC!C[-4]
[/TD]
[TD]TDC!C[-3]
[/TD]
[TD]TDC!C[-2]
[/TD]
[TD]TDC!C[-1]
[/TD]
[TD]TDC!C[-0]
[/TD]
[TD]TDC!C[1]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD][/TD]
[TD="colspan: 8"] References to sheet TDC; offset as found in code
[/TD]
[/TR]
</tbody>[/TABLE]

Sample Meal plan
[TABLE="width: 783"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[TD]I
[/TD]
[TD]J
[/TD]
[TD]K
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Meal no.
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]Food type
[/TD]
[TD]Amount
[/TD]
[TD]unit
[/TD]
[TD="colspan: 2"]Unit cal excess/short
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]MEAL 1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]Protein
[/TD]
[TD]4
[/TD]
[TD]per
[/TD]
[TD]gram
[/TD]
[TD]Whey Protein Powder
[/TD]
[TD]35
[/TD]
[TD]grams
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]Carbs
[/TD]
[TD]3.33
[/TD]
[TD]per
[/TD]
[TD]gram
[/TD]
[TD]Rolled Oats
[/TD]
[TD]107
[/TD]
[TD]grams
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]Fats
[/TD]
[TD]60
[/TD]
[TD]per
[/TD]
[TD]unit
[/TD]
[TD]Whole Eggs
[/TD]
[TD]2
[/TD]
[TD]units
[/TD]
[TD]14
[/TD]
[TD]cal excess/short
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD]Fruit/Veggies
[/TD]
[TD]0.47
[/TD]
[TD]per
[/TD]
[TD]gram
[/TD]
[TD]Mixed Berries
[/TD]
[TD]227
[/TD]
[TD]grams
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10
[/TD]
[TD]MEAL 2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD]Protein
[/TD]
[TD]1.5
[/TD]
[TD]per
[/TD]
[TD]gram
[/TD]
[TD]Lean Minced Beef
[/TD]
[TD]208
[/TD]
[TD]grams
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12
[/TD]
[TD]Carbs
[/TD]
[TD]1.2
[/TD]
[TD]per
[/TD]
[TD]gram
[/TD]
[TD]Basmati Rice
[/TD]
[TD]140
[/TD]
[TD]grams
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13
[/TD]
[TD]Fats
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]N/A
[/TD]
[TD]N/A
[/TD]
[TD][/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14
[/TD]
[TD="colspan: 2"]Fruit/Veggies
[/TD]
[TD][/TD]
[TD][/TD]
[TD]N/A
[/TD]
[TD]N/A
[/TD]
[TD][/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16
[/TD]
[TD]MEAL 3
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]17
[/TD]
[TD]Protein
[/TD]
[TD]1.2
[/TD]
[TD]per
[/TD]
[TD]gram
[/TD]
[TD]Chicken Breast
[/TD]
[TD]237
[/TD]
[TD]grams
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]18
[/TD]
[TD]Carbs
[/TD]
[TD]0.75
[/TD]
[TD]per
[/TD]
[TD]gram
[/TD]
[TD]Kumera
[/TD]
[TD]379
[/TD]
[TD]grams
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19
[/TD]
[TD]Fats
[/TD]
[TD]2.3
[/TD]
[TD]per
[/TD]
[TD]gram
[/TD]
[TD]Avocado
[/TD]
[TD]46
[/TD]
[TD]grams
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20
[/TD]
[TD]Fruit/Veggies
[/TD]
[TD]0.3
[/TD]
[TD]per
[/TD]
[TD]gram
[/TD]
[TD]Approved Vegetables
[/TD]
[TD]118
[/TD]
[TD]grams
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]21
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]22
[/TD]
[TD]MEAL 4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]23
[/TD]
[TD]Protein
[/TD]
[TD]1.2
[/TD]
[TD]per
[/TD]
[TD]gram
[/TD]
[TD]Chicken Breast
[/TD]
[TD]260
[/TD]
[TD]grams
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]24
[/TD]
[TD]Carbs
[/TD]
[TD]0.75
[/TD]
[TD]per
[/TD]
[TD]gram
[/TD]
[TD]Kumera
[/TD]
[TD]160
[/TD]
[TD]grams
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]25
[/TD]
[TD]Fats
[/TD]
[TD]2.3
[/TD]
[TD]per
[/TD]
[TD]gram
[/TD]
[TD]Avocado
[/TD]
[TD]21
[/TD]
[TD]grams
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]26
[/TD]
[TD="colspan: 2"]Fruit/Veggies
[/TD]
[TD][/TD]
[TD][/TD]
[TD]N/A
[/TD]
[TD]N/A
[/TD]
[TD][/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]27
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]28
[/TD]
[TD]MEAL 5
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]29
[/TD]
[TD]Protein
[/TD]
[TD]1.2
[/TD]
[TD]per
[/TD]
[TD]gram
[/TD]
[TD]Chicken Breast
[/TD]
[TD]414
[/TD]
[TD]grams
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]30
[/TD]
[TD]Carbs
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]N/A
[/TD]
[TD]N/A
[/TD]
[TD][/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]31
[/TD]
[TD]Fats
[/TD]
[TD]8
[/TD]
[TD]per
[/TD]
[TD]ml
[/TD]
[TD]Lite Olive Oil
[/TD]
[TD]13
[/TD]
[TD]mls
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]32
[/TD]
[TD]Fruit/Veggies
[/TD]
[TD]0.3
[/TD]
[TD]per
[/TD]
[TD]gram
[/TD]
[TD]Approved Vegetables
[/TD]
[TD]355
[/TD]
[TD]grams
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]33
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]34
[/TD]
[TD]MEAL 6
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]35
[/TD]
[TD]Protein
[/TD]
[TD]4
[/TD]
[TD]per
[/TD]
[TD]gram
[/TD]
[TD]Whey Protein Powder
[/TD]
[TD]46
[/TD]
[TD]grams
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]36
[/TD]
[TD]Carbs
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]N/A
[/TD]
[TD]N/A
[/TD]
[TD][/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]37
[/TD]
[TD]Fats
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]N/A
[/TD]
[TD]N/A
[/TD]
[TD][/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]38
[/TD]
[TD]Fruit/Veggies
[/TD]
[TD]0.47
[/TD]
[TD]per
[/TD]
[TD]gram
[/TD]
[TD]Mixed Berries
[/TD]
[TD]98
[/TD]
[TD]grams
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]39
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]40
[/TD]
[TD]MEAL 7
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]41
[/TD]
[TD]Protein
[/TD]
[TD]4
[/TD]
[TD]per
[/TD]
[TD]gram
[/TD]
[TD]Whey Protein Powder
[/TD]
[TD]29
[/TD]
[TD]grams
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]42
[/TD]
[TD]Carbs
[/TD]
[TD]1
[/TD]
[TD]per
[/TD]
[TD]gram
[/TD]
[TD]Banana
[/TD]
[TD]115
[/TD]
[TD]grams
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]43
[/TD]
[TD]Fats
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]N/A
[/TD]
[TD]N/A
[/TD]
[TD][/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]44
[/TD]
[TD="colspan: 2"]Fruit/Veggies
[/TD]
[TD][/TD]
[TD][/TD]
[TD]N/A
[/TD]
[TD]N/A
[/TD]
[TD][/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]45
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]46
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]47
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]Total excess/shortage Protein
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]48
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]Total excess/shortage Protein
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]49
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]Total excess/shortage Fats
[/TD]
[TD]14
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]50
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]Total excess/shortage Fruits/Veggies
[/TD]
[TD]0
[/TD]
[TD]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

The Call CellAddress(j, k, l) sub id's the line it came from so I can compare "unit"

Thanks again,
Vince
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Question Question
Populating, aggregating and sorting multiple matching values in Excel
Replies
0
Views
183
Pbobas
P
B
  • Solved
Array Returning "0" value
Replies
5
Views
396
Fluff
Fluff
R
  • Solved
Remove unwanted #N/A errors in this LAMBDA/REDUCE formula
2
Replies
11
Views
494
Rnkhch
R
J
  • Solved
how to random all numbers
Replies
7
Views
260
Fluff
Fluff
gtd526
  • Solved
Count consecutive value
Replies
5
Views
361
gtd526
gtd526

Forum statistics

Threads
1,223,268
Messages
6,171,100
Members
452,379
Latest member
IainTru

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