Data table sort into top 5 with headers from column and rows (PLEASE HELP ITS A NIGHTMARE)

T

TheFella

New Member
Joined
Feb 21, 2011
Messages
10
I have a very large data table which i want to sort out by amounts into a top 5 table by type and and name.
I need it so any person, amount or fruit can appear in the table multiple times by the highest amount as the search criteria.

Here is an example of the table i have with my data.


<TABLE style="WIDTH: 288pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=384 border=0><COLGROUP><COL style="WIDTH: 48pt" span=6 width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; WIDTH: 48pt; BORDER-TOP-COLOR: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0" width=64 height=17></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; WIDTH: 48pt; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0" width=64>apples</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; WIDTH: 48pt; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0" width=64>oranges</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; WIDTH: 48pt; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0" width=64>pears</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; WIDTH: 48pt; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0" width=64>banana</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; WIDTH: 48pt; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0" width=64>lemon</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0" height=17>john</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0">2</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0">1</TD><TD class=xl66 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: yellow; BORDER-RIGHT-COLOR: #f0f0f0">4</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0">3</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0">1</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0" height=17>jenny</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0">1</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0">1</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0">2</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0">2</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0">2</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0" height=17>sam</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0">0</TD><TD class=xl66 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: yellow; BORDER-RIGHT-COLOR: #f0f0f0">6</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0">2</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0">1</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0">1</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0" height=17>lenny</TD><TD class=xl66 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: yellow; BORDER-RIGHT-COLOR: #f0f0f0">8</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0">1</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0">2</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0">1</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0">1</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0" height=17>sally</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0">3</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0">2</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0">2</TD><TD class=xl66 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: yellow; BORDER-RIGHT-COLOR: #f0f0f0">5</TD><TD class=xl66 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: yellow; BORDER-RIGHT-COLOR: #f0f0f0">6</TD></TR></TBODY></TABLE>


Although my table is a lot bigger than this table i just need help to work out a formula which will sort out the top 5 for me into another table as follows in this example:-


<TABLE style="WIDTH: 144pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=192 border=0><COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; WIDTH: 48pt; BORDER-TOP-COLOR: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0" width=64 height=17>name</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; WIDTH: 48pt; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0" width=64>amount</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; WIDTH: 48pt; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0" width=64>fruit</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl66 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0" height=17>lenny</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0">8</TD><TD class=xl66 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0">apples</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl66 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0" height=17>sam</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0">6</TD><TD class=xl66 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0">oranges</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl66 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0" height=17>sally</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0">6</TD><TD class=xl66 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0">lemon</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl66 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0" height=17>sally</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0">5</TD><TD class=xl66 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0">banana</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl66 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0" height=17>john</TD><TD class=xl65 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0">4</TD><TD class=xl66 style="BORDER-LEFT-COLOR: #f0f0f0; BORDER-BOTTOM-COLOR: #f0f0f0; BORDER-TOP-COLOR: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #f0f0f0">pears</TD></TR></TBODY></TABLE>

Can anybody help me please!

Many thanks in advance.


 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
Sort by date Sort by votes
This VBA code will build a Table with your Top Five results on a new worksheet named "Results":
Code: 
Sub ReorgData2()
Dim w1 As Worksheet, wR As Worksheet
Dim LR As Long, r As Long, LC As Long, c As Long, NR As Long
    Set w1 = Worksheets(ActiveSheet.Name)
'If "Results" Worksheet does not exist, then create it
    If Not Evaluate("ISREF(Results!A1)") Then Worksheets.Add(After:=w1).Name = "Results"
'Assign Worksheet variables
    Set wR = Worksheets("Results")
    wR.UsedRange.Clear
    LR = w1.Cells(Rows.Count, 1).End(xlUp).Row
    LC = w1.Cells(1, Columns.Count).End(xlToLeft).Column
'Assign "NextRow" variable to start at Row 1
    NR = 2
    For r = 2 To LR
        For c = 2 To LC
            wR.Cells(NR, 1) = w1.Cells(r, 1)
            wR.Cells(NR, 2) = w1.Cells(r, c)
            wR.Cells(NR, 3) = w1.Cells(1, c)
            NR = NR + 1
        Next c
    Next r
            wR.Range("A1") = "Name"
            wR.Range("B1") = "Amount"
            wR.Range("C1") = "Fruit"
'Sort new Table
    wR.UsedRange.Columns.AutoFit
    wR.Activate
    lrow = wR.Cells(Rows.Count, 1).End(xlUp).Row
    ActiveWorkbook.Worksheets("Results").Sort.SortFields.Clear
    ActiveWorkbook.Worksheets("Results").Sort.SortFields.Add Key:=Range("B2:B" & lrow) _
        , SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:=xlSortNormal
    With ActiveWorkbook.Worksheets("Results").Sort
        .SetRange Range("A1:C" & lrow)
        .header = xlYes
        .MatchCase = False
        .Orientation = xlTopToBottom
        .SortMethod = xlPinYin
        .Apply
    End With
'Delete all but top five items
    Range("A7:A" & lrow).EntireRow.Delete
End Sub
To use the posted code using Excel 2007:
Start the Visual Basic Editor (ALT+F11).
On the Insert menu in the VBE, click Module. (if necessary)
In the module (the white area at the right), paste your code.
Note: All Macros start with "Sub MacroName()" and End with "End Sub"

How to create a button and assign a macro to it:
Click on Developer Ribbon, Click the Insert Icon in the Controls section.
On the Forms Controls section, Click the Button Icon.
Drag out a button on the screen. When you release the left mouse button, an "Assign Macro" dialog box will appear. Highlight whatever macro you want, and click OK. The macro will now be assigned to that button.

You can also run the code by hitting Alt-F8 and selecting the macro name and clicking Run.
 
Upvote 0
John,
many thanks for your help, unfortunately i am using 2003 at work and with this version i keep getting an error in a line of the code which is:-

ActiveWorkbook.Worksheets("Results").Sort.SortFields.Clear

If i run this code at home on 2007 will i be able to save it in compatability mode and use it on 2003. If not not could you debug the code for me to use on 2003.

Thanks once again and regards.

Brent.
 
Upvote 0
I simplified the Sort section, I do not have 2003 to test on, but it should work now.
Code: 
Sub ReorgData2()
Dim w1 As Worksheet, wR As Worksheet
Dim LR As Long, r As Long, LC As Long, c As Long, NR As Long
    Set w1 = Worksheets(ActiveSheet.Name)
'If "Results" Worksheet does not exist, then create it
    If Not Evaluate("ISREF(Results!A1)") Then Worksheets.Add(After:=w1).Name = "Results"
'Assign Worksheet variables
    Set wR = Worksheets("Results")
    wR.UsedRange.Clear
    LR = w1.Cells(Rows.Count, 1).End(xlUp).Row
    LC = w1.Cells(1, Columns.Count).End(xlToLeft).Column
'Assign "NextRow" variable to start at Row 2
    NR = 2
    For r = 2 To LR
        For c = 2 To LC
            wR.Cells(NR, 1) = w1.Cells(r, 1)
            wR.Cells(NR, 2) = w1.Cells(r, c)
            wR.Cells(NR, 3) = w1.Cells(1, c)
            NR = NR + 1
        Next c
    Next r
            wR.Range("A1") = "Name"
            wR.Range("B1") = "Amount"
            wR.Range("C1") = "Fruit"
'Sort new Table
    wR.UsedRange.Columns.AutoFit
    wR.Activate
    lrow = wR.Cells(Rows.Count, 1).End(xlUp).Row
        Range("A1:C" & lrow).Sort Key1:=Range("B1"), Order1:=xlDescending, header:=xlYes, _
        OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
        DataOption1:=xlSortNormal
    Range("A7:A" & lrow).EntireRow.Delete
End Sub
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
623
smozgur
smozgur
C
  • Question Question
Macro Help - Transposing Some Data from Columns to Rows, Accounting for Duplicate Data
Replies
1
Views
127
Kaper
Kaper
G
  • Question Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G
A
  • Question Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
2K
Attrazion
A
E
  • Question Question
Query in excel to Outlook mail take rows with name until next name
Replies
0
Views
518
esben
E

Forum statistics

Threads
1,224,600
Messages
6,179,834
Members
452,947
Latest member
Gerry_F

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