Concatenate cell value in asending order based on repeatation of another value

N

Negi1984

Board Regular
Joined
May 6, 2011
Messages
199
Hi All,

I have a data in range N5 : T till last cell, in below format

[TABLE="class: grid, width: 304"]
<tbody>[TR]
[TD]cellname[/TD]
[TD]tRXID[/TD]
[TD]BSIC[/TD]
[TD]HSN[/TD]
[TD]MAIO[/TD]
[TD]FreqList[/TD]
[TD]Saut[/TD]
[/TR]
[TR]
[TD]A123[/TD]
[TD="align: right"]1[/TD]
[TD]20[/TD]
[TD] [/TD]
[TD="align: right"]0[/TD]
[TD]1017[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]A123[/TD]
[TD="align: right"]2[/TD]
[TD]20[/TD]
[TD]11[/TD]
[TD="align: right"]1[/TD]
[TD]988[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]A123[/TD]
[TD="align: right"]3[/TD]
[TD]20[/TD]
[TD]11[/TD]
[TD="align: right"]1[/TD]
[TD]2000[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]B123[/TD]
[TD="align: right"]1[/TD]
[TD]41[/TD]
[TD] [/TD]
[TD="align: right"]0[/TD]
[TD]81[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]B123[/TD]
[TD="align: right"]2[/TD]
[TD]41[/TD]
[TD]18[/TD]
[TD="align: right"]1[/TD]
[TD]83[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]C12[/TD]
[TD="align: right"]1[/TD]
[TD]51[/TD]
[TD] [/TD]
[TD="align: right"]0[/TD]
[TD]982[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]D12[/TD]
[TD="align: right"]1[/TD]
[TD]20[/TD]
[TD] [/TD]
[TD="align: right"]0[/TD]
[TD]123[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]E12[/TD]
[TD="align: right"]1[/TD]
[TD]40[/TD]
[TD] [/TD]
[TD="align: right"]0[/TD]
[TD]975[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]F12[/TD]
[TD="align: right"]1[/TD]
[TD]30[/TD]
[TD] [/TD]
[TD="align: right"]0[/TD]
[TD]79[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col><col></colgroup>[/TABLE]

And want to arrange Column F in below format.
Logic :- if Cell name is repeat 1st time or only once in whole range than Freqlist will be same no as mentioned.
if cell name repeated 2nd time or more than freqlist cell value should combined all cell values in Freqlist in ascending order. Below is the sample output for the same.
[TABLE="class: grid, width: 338"]
<tbody>[TR]
[TD]cellname[/TD]
[TD]tRXID[/TD]
[TD]BSIC[/TD]
[TD]HSN[/TD]
[TD]MAIO[/TD]
[TD]FreqList[/TD]
[TD]Saut[/TD]
[/TR]
[TR]
[TD]A123[/TD]
[TD="align: right"]1[/TD]
[TD]20[/TD]
[TD][/TD]
[TD][/TD]
[TD]1017[/TD]
[TD]BBH[/TD]
[/TR]
[TR]
[TD]A123[/TD]
[TD="align: right"]2[/TD]
[TD]20[/TD]
[TD]11[/TD]
[TD]0[/TD]
[TD]988 1017 2000[/TD]
[TD]BBH[/TD]
[/TR]
[TR]
[TD]A123[/TD]
[TD="align: right"]3[/TD]
[TD]20[/TD]
[TD]11[/TD]
[TD]1[/TD]
[TD]988 1017 2000[/TD]
[TD]BBH[/TD]
[/TR]
[TR]
[TD]B123[/TD]
[TD="align: right"]1[/TD]
[TD]41[/TD]
[TD][/TD]
[TD][/TD]
[TD]81[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]B123[/TD]
[TD="align: right"]2[/TD]
[TD]41[/TD]
[TD]18[/TD]
[TD]0[/TD]
[TD]81 83[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]C12[/TD]
[TD="align: right"]1[/TD]
[TD]51[/TD]
[TD][/TD]
[TD][/TD]
[TD]982[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]D12[/TD]
[TD="align: right"]1[/TD]
[TD]20[/TD]
[TD][/TD]
[TD][/TD]
[TD]123[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]E12[/TD]
[TD="align: right"]1[/TD]
[TD]40[/TD]
[TD][/TD]
[TD][/TD]
[TD]975[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]F12[/TD]
[TD="align: right"]1[/TD]
[TD]30[/TD]
[TD][/TD]
[TD][/TD]
[TD]79[/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col><col></colgroup>[/TABLE]

Thanks in advance for your valuable suggestion.
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
Sort by date Sort by votes
Try this, results start "F1" :-
NB:- I have assumed that your data Header start "N4" and actual data start "N5"
NB:- I don't know where the new data in column 7 comes from. ?????
Code: 
[COLOR="Navy"]Sub[/COLOR] MG22Jun19
[COLOR="Navy"]Dim[/COLOR] Rng [COLOR="Navy"]As[/COLOR] Range, Dn [COLOR="Navy"]As[/COLOR] Range, n [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Long,[/COLOR] Q [COLOR="Navy"]As[/COLOR] Variant, Ray [COLOR="Navy"]As[/COLOR] Variant, c [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Long[/COLOR]
[COLOR="Navy"]Dim[/COLOR] Dic [COLOR="Navy"]As[/COLOR] Object
Ray = Range("N4", Range("N" & Rows.Count).End(xlUp)).Resize(, 7)
[COLOR="Navy"]Set[/COLOR] Dic = CreateObject("scripting.dictionary")
Dic.CompareMode = vbTextCompare
[COLOR="Navy"]For[/COLOR] n = 2 To UBound(Ray, 1)
  [COLOR="Navy"]If[/COLOR] Not Dic.Exists(Ray(n, 1)) [COLOR="Navy"]Then[/COLOR]
        ReDim nRay(1 To UBound(Ray, 1))
        nRay(1) = Ray(n, 6)
        Dic.Add Ray(n, 1), Array(n, nRay, 1)
    [COLOR="Navy"]Else[/COLOR]
        Q = Dic(Ray(n, 1))
            Q(2) = Q(2) + 1
            Q(1)(Q(2)) = Ray(n, 6)
            Q(0) = Q(0) & "," & n
        Dic(Ray(n, 1)) = Q
[COLOR="Navy"]End[/COLOR] If
[COLOR="Navy"]Next[/COLOR]
[COLOR="Navy"]Dim[/COLOR] Sp [COLOR="Navy"]As[/COLOR] Variant, Al [COLOR="Navy"]As[/COLOR] Variant, K [COLOR="Navy"]As[/COLOR] Variant, Rw [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Long[/COLOR]
[COLOR="Navy"]For[/COLOR] [COLOR="Navy"]Each[/COLOR] K [COLOR="Navy"]In[/COLOR] Dic.keys
    Sp = Split(Dic(K)(0), ",")
      [COLOR="Navy"]With[/COLOR] CreateObject("System.Collections.ArrayList")
          [COLOR="Navy"]For[/COLOR] n = 1 To UBound(Dic(K)(1))
                [COLOR="Navy"]If[/COLOR] Not IsEmpty(Dic(K)(1)(n)) [COLOR="Navy"]Then[/COLOR]
                .Add Dic(K)(1)(n)
                [COLOR="Navy"]End[/COLOR] If
            [COLOR="Navy"]Next[/COLOR]
        .Sort
      
        [COLOR="Navy"]For[/COLOR] Rw = 1 To UBound(Sp)
            Ray(Sp(Rw), 6) = Join(.ToArray, " ")
        [COLOR="Navy"]Next[/COLOR] Rw
    [COLOR="Navy"]End[/COLOR] With
[COLOR="Navy"]Next[/COLOR] K
[COLOR="Navy"]With[/COLOR] Range("F1").Resize(UBound(Ray, 1), UBound(Ray, 2))
        .Value = Ray
        .Columns.AutoFit
        .Borders.Weight = 2
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]With[/COLOR]
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]Sub[/COLOR]
Regards Mick
 
Upvote 0
Hi Mick,

Thanks a lot for your valuable support. Code is working fine.
Regarding column 7 "Saut", I was applying formula manually, if Cell name are more than once repeated than change existing value to "BBH" other wise no change in this column.
 
Upvote 0
Hi Mick,

Need your support once again , there is slight changes in input data. Previously FreqList column having numerical data, but this time multiple numbers can be there as shown below. Could you please suggest , what changes is required to get the output.
Thank you once again for your valuable support.
Input Data,

[TABLE="width: 278"]
<colgroup><col width="63" style="width: 47pt; mso-width-source: userset; mso-width-alt: 2304;"> <col width="46" style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;"> <col width="39" style="width: 29pt; mso-width-source: userset; mso-width-alt: 1426;"> <col width="35" style="width: 26pt; mso-width-source: userset; mso-width-alt: 1280;"> <col width="45" style="width: 34pt; mso-width-source: userset; mso-width-alt: 1645;"> <col width="106" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3876;"> <col width="36" style="width: 27pt; mso-width-source: userset; mso-width-alt: 1316;"> <tbody>[TR]
[TD="width: 63, bgcolor: white"]cellname
[/TD]
[TD="width: 46, bgcolor: white"]tRXID[/TD]
[TD="width: 39, bgcolor: white"]BSIC[/TD]
[TD="width: 35, bgcolor: white"]HSN[/TD]
[TD="width: 45, bgcolor: white"]MAIO[/TD]
[TD="width: 106, bgcolor: white"]FreqList[/TD]
[TD="width: 36, bgcolor: white"]Saut[/TD]
[/TR]
[TR]
[TD="bgcolor: white"]A123
[/TD]
[TD="bgcolor: white"]1[/TD]
[TD="bgcolor: white"]20[/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"]0[/TD]
[TD="bgcolor: white"]1017[/TD]
[TD="bgcolor: white"]2[/TD]
[/TR]
[TR]
[TD="bgcolor: white"]A123
[/TD]
[TD="bgcolor: white"]2[/TD]
[TD="bgcolor: white"]20[/TD]
[TD="bgcolor: white"]11[/TD]
[TD="bgcolor: white"]1[/TD]
[TD="bgcolor: white"]1017 988 2000[/TD]
[TD="bgcolor: white"]2[/TD]
[/TR]
[TR]
[TD="bgcolor: white"]A123
[/TD]
[TD="bgcolor: white"]3[/TD]
[TD="bgcolor: white"]20[/TD]
[TD="bgcolor: white"]11[/TD]
[TD="bgcolor: white"]1[/TD]
[TD="bgcolor: white"]988 2000[/TD]
[TD="bgcolor: white"]2[/TD]
[/TR]
[TR]
[TD="bgcolor: white"]B123
[/TD]
[TD="bgcolor: white"]1[/TD]
[TD="bgcolor: white"]41[/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"]0[/TD]
[TD="bgcolor: white"]82[/TD]
[TD="bgcolor: white"]2
[/TD]
[/TR]
[TR]
[TD="bgcolor: white"]B123
[/TD]
[TD="bgcolor: white"]2[/TD]
[TD="bgcolor: white"]41[/TD]
[TD="bgcolor: white"]18[/TD]
[TD="bgcolor: white"]1[/TD]
[TD="bgcolor: white"]83,81[/TD]
[TD="bgcolor: white"]2[/TD]
[/TR]
[TR]
[TD="bgcolor: white"]C12
[/TD]
[TD="bgcolor: white"]1[/TD]
[TD="bgcolor: white"]51[/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"]0[/TD]
[TD="bgcolor: white"]982[/TD]
[TD="bgcolor: white"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: white"]D12
[/TD]
[TD="bgcolor: white"]1[/TD]
[TD="bgcolor: white"]20[/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"]0[/TD]
[TD="bgcolor: white"]123[/TD]
[TD="bgcolor: white"]1
[/TD]
[/TR]
[TR]
[TD="bgcolor: white"]E12
[/TD]
[TD="bgcolor: white"]1[/TD]
[TD="bgcolor: white"]40[/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"]0[/TD]
[TD="bgcolor: white"]975[/TD]
[TD="bgcolor: white"]1
[/TD]
[/TR]
[TR]
[TD="bgcolor: white"]F12[/TD]
[TD="bgcolor: white"]1[/TD]
[TD="bgcolor: white"]30[/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"]0[/TD]
[TD="bgcolor: white"]79[/TD]
[TD="bgcolor: white"]1
[/TD]
[/TR]
</tbody>[/TABLE]

Output Data :

[TABLE="width: 278"]
<colgroup><col width="63" style="width: 47pt; mso-width-source: userset; mso-width-alt: 2304;"> <col width="46" style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;"> <col width="39" style="width: 29pt; mso-width-source: userset; mso-width-alt: 1426;"> <col width="35" style="width: 26pt; mso-width-source: userset; mso-width-alt: 1280;"> <col width="45" style="width: 34pt; mso-width-source: userset; mso-width-alt: 1645;"> <col width="106" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3876;"> <col width="36" style="width: 27pt; mso-width-source: userset; mso-width-alt: 1316;"> <tbody>[TR]
[TD="width: 63, bgcolor: white"]cellname[/TD]
[TD="width: 46, bgcolor: white"]tRXID[/TD]
[TD="width: 39, bgcolor: white"]BSIC[/TD]
[TD="width: 35, bgcolor: white"]HSN[/TD]
[TD="width: 45, bgcolor: white"]MAIO[/TD]
[TD="width: 106, bgcolor: white"]FreqList[/TD]
[TD="width: 36, bgcolor: white"]Saut
[/TD]
[/TR]
[TR]
[TD="bgcolor: white"]A123[/TD]
[TD="bgcolor: white"]1[/TD]
[TD="bgcolor: white"]20[/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"]1017[/TD]
[TD="bgcolor: white"]2[/TD]
[/TR]
[TR]
[TD="bgcolor: white"]A123[/TD]
[TD="bgcolor: white"]2[/TD]
[TD="bgcolor: white"]20[/TD]
[TD="bgcolor: white"]11[/TD]
[TD="bgcolor: white"]0[/TD]
[TD="bgcolor: white"]988 1017 2000[/TD]
[TD="bgcolor: white"]2[/TD]
[/TR]
[TR]
[TD="bgcolor: white"]A123[/TD]
[TD="bgcolor: white"]3[/TD]
[TD="bgcolor: white"]20[/TD]
[TD="bgcolor: white"]11[/TD]
[TD="bgcolor: white"]1[/TD]
[TD="bgcolor: white"]988 1017 2000[/TD]
[TD="bgcolor: white"]2[/TD]
[/TR]
[TR]
[TD="bgcolor: white"]B123[/TD]
[TD="bgcolor: white"]1[/TD]
[TD="bgcolor: white"]41[/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"]82[/TD]
[TD="bgcolor: white"]2
[/TD]
[/TR]
[TR]
[TD="bgcolor: white"]B123[/TD]
[TD="bgcolor: white"]2[/TD]
[TD="bgcolor: white"]41[/TD]
[TD="bgcolor: white"]18[/TD]
[TD="bgcolor: white"]0[/TD]
[TD="bgcolor: white"]81 82 83[/TD]
[TD="bgcolor: white"]2[/TD]
[/TR]
[TR]
[TD="bgcolor: white"]C12[/TD]
[TD="bgcolor: white"]1[/TD]
[TD="bgcolor: white"]51[/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"]982[/TD]
[TD="bgcolor: white"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: white"]D12[/TD]
[TD="bgcolor: white"]1[/TD]
[TD="bgcolor: white"]20[/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"]123[/TD]
[TD="bgcolor: white"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: white"]E12[/TD]
[TD="bgcolor: white"]1[/TD]
[TD="bgcolor: white"]40[/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"]975[/TD]
[TD="bgcolor: white"]1
[/TD]
[/TR]
[TR]
[TD="bgcolor: white"]F12[/TD]
[TD="bgcolor: white"]1[/TD]
[TD="bgcolor: white"]30[/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"]79[/TD]
[TD="bgcolor: white"]1
[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
Try this for results starting "F1"
Code: 
[COLOR="Navy"]Sub[/COLOR] MG26Jul35
[COLOR="Navy"]Dim[/COLOR] Rng [COLOR="Navy"]As[/COLOR] Range, Dn [COLOR="Navy"]As[/COLOR] Range, n [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Long,[/COLOR] Q [COLOR="Navy"]As[/COLOR] Variant, Ray [COLOR="Navy"]As[/COLOR] Variant, c [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Long[/COLOR]
[COLOR="Navy"]Dim[/COLOR] Dic [COLOR="Navy"]As[/COLOR] Object, s [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Long,[/COLOR] Sp1 [COLOR="Navy"]As[/COLOR] Variant, nstr [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]String[/COLOR]
Ray = Range("N4", Range("N" & Rows.Count).End(xlUp)).Resize(, 7)
[COLOR="Navy"]Set[/COLOR] Dic = CreateObject("scripting.dictionary")
Dic.CompareMode = vbTextCompare
[COLOR="Navy"]For[/COLOR] n = 2 To UBound(Ray, 1)
  [COLOR="Navy"]If[/COLOR] Not Dic.Exists(Ray(n, 1)) [COLOR="Navy"]Then[/COLOR]
        ReDim nRay(1 To 10)
        nstr = ""
        Sp1 = Split(Ray(n, 6), " ")
        
        [COLOR="Navy"]For[/COLOR] s = 0 To UBound(Sp1)
            nRay(s + 1) = Sp1(s)
        nstr = nstr & IIf(nstr = "", Sp1(s), "," & Sp1(s))
        [COLOR="Navy"]Next[/COLOR] s
        Dic.Add Ray(n, 1), Array(n, nRay, 1, nstr)
    [COLOR="Navy"]Else[/COLOR]
        Q = Dic(Ray(n, 1))
            Sp1 = Split(Ray(n, 6), " ")
            [COLOR="Navy"]For[/COLOR] s = 0 To UBound(Sp1)
            
                [COLOR="Navy"]If[/COLOR] InStr(Q(3), Sp1(s)) = 0 [COLOR="Navy"]Then[/COLOR]
                     Q(3) = Q(3) & "," & Sp1(s)
                     Q(2) = Q(2) + 1
                     Q(1)(Q(2)) = Sp1(s)
                [COLOR="Navy"]End[/COLOR] If
        [COLOR="Navy"]Next[/COLOR] s
          
            
        Q(0) = Q(0) & "," & n
        Dic(Ray(n, 1)) = Q
[COLOR="Navy"]End[/COLOR] If
[COLOR="Navy"]Next[/COLOR]
[COLOR="Navy"]Dim[/COLOR] Sp [COLOR="Navy"]As[/COLOR] Variant, Al [COLOR="Navy"]As[/COLOR] Variant, K [COLOR="Navy"]As[/COLOR] Variant, Rw [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Long[/COLOR]
[COLOR="Navy"]For[/COLOR] [COLOR="Navy"]Each[/COLOR] K [COLOR="Navy"]In[/COLOR] Dic.keys
    Sp = Split(Dic(K)(0), ",")
      [COLOR="Navy"]With[/COLOR] CreateObject("System.Collections.ArrayList")
          [COLOR="Navy"]For[/COLOR] n = 1 To UBound(Dic(K)(1))
                [COLOR="Navy"]If[/COLOR] Not IsEmpty(Dic(K)(1)(n)) [COLOR="Navy"]Then[/COLOR]
                .Add Val(Dic(K)(1)(n))
                [COLOR="Navy"]End[/COLOR] If
            [COLOR="Navy"]Next[/COLOR]
        .Sort
        
        [COLOR="Navy"]For[/COLOR] Rw = 0 To UBound(Sp)
            [COLOR="Navy"]If[/COLOR] Rw = 0 [COLOR="Navy"]Then[/COLOR]
            Ray(Sp(Rw), 5) = ""
            [COLOR="Navy"]Else[/COLOR]
            Ray(Sp(Rw), 6) = Join(.ToArray, " ")
            Ray(Sp(Rw), 5) = Rw - 1
        [COLOR="Navy"]End[/COLOR] If
        [COLOR="Navy"]Next[/COLOR] Rw
    [COLOR="Navy"]End[/COLOR] With
[COLOR="Navy"]Next[/COLOR] K
[COLOR="Navy"]With[/COLOR] Range("F1").Resize(UBound(Ray, 1), UBound(Ray, 2))
        .Value = Ray
        .Columns.AutoFit
        .Borders.Weight = 2
[COLOR="Navy"]End[/COLOR] With
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]Sub[/COLOR]
Regards Mick
 
Upvote 0
You must log in or register to reply here.

Similar threads

earthworm
  • Question Question
Split Data into separate worksheet based on Cell values
Replies
8
Views
590
earthworm
earthworm
K
  • Question Question
macro insert three columns repeatedly with all values based on multiple sheets
Replies
0
Views
380
KalilMe
K
airforceone
  • Solved
Yet Another Sheet Name Copying based on Cell Value Problem
2
Replies
17
Views
995
airforceone
airforceone
N
  • Question Question
Repeat & Concatenate Range Data with Fixed template lines
Replies
0
Views
431
Negi1984
N
J
  • Question Question
Formula to make cell equal a value based on another cell
Replies
1
Views
335
jondavis1987
J

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