Trying to group rows with same values in VBA

E

Eric Penfold

Active Member
Joined
Nov 19, 2021
Messages
431
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
I`ve created this code but when i run it nothing happens?
I think these 2 Dims should match to run the code is this right

VBA Code: 
LBRow = CRow

VBA Code: 
Sub Group_PartNos()


    Dim ws As Worksheet
    Dim Rng As Range
    Dim ERow, CRow, FBRow, LBRow As Long
    Dim CRValue, NRValue As String
    
    Application.ScreenUpdating = False
    
    Set ws = ActiveSheet
    ERow = Range("C2").End(xlDown).Row
    Set Rng = ws.Range("C2:C" & ERow)
    
    FBRow = 0
    LBRow = 0
    
    For CRow = 2 To ERow
        CRValue = Cells(CRow, Rng.Column).Value
        NRValue = Cells(CRow + 1, Rng.Column).Value
        
        If Not (IsEmpty(CRValue) Or CRValue = "") Then
          If Not (IsEmpty(NRValue) Or NRValue = "") Then
           FBRow = CRow + 1
           End If
        ElseIf (IsEmpty(CRValue) Or CRValue = "") Then
           If Not (IsEmpty(NRValue) Or NRValue = "") Then
            If FBRow = CRow <> 0 Then
             LBRow = CRow
            End If
          End If
        End If
        
        If FBRow <> 0 And LBRow <> 0 Then

        If Not ws.Rows(CurrentRow).OutlineLevel > 1 Then
          ws.Range(Cells(FBRow, Rng.Column), Cells(LBRow, Rng.Column)).EntireRow.Select
          Selection.Group
          End If
          FBRow = 0: LBRow = 0
        End If
      Next
        
        Application.ScreenUpdating = True
          
End Sub
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Sort by date Sort by votes
Can you post some sample data and show us your expected results?

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

By the way, this does NOT do what you think it does:
VBA Code: 
    Dim ERow, CRow, FBRow, LBRow As Long
    Dim CRValue, NRValue As String
Only "LBRow" will be declared as Long and "NRValue" will be declared as String. The rest will be declared as Variant (which is the default).
Each variable needs to be declared explicitly, like this:
VBA Code: 
    Dim ERow As Long, CRow As Long, FBRow As Long, LBRow As Long
    Dim CRValue As String, NRValue As String
or this:
VBA Code: 
    Dim ERow As Long
    Dim CRow As Long
    Dim FBRow As Long
    Dim LBRow As Long
    Dim CRValue As String
    Dim NRValue As String
 
Upvote 0
I have changed the dims. Here is the data.
Order No is Col C

Order DateCustomer NameOrder No.Ent ByCodeDescriptionBO Qty.Intact Stock LevelsNotesBackOrderReasonCodeOrder TypeProduct TypeDupilcate Codes
01/07/2022Oliver Curran Construction Ltd SO0063929NIJDUCT60 Naylor 600x600mm Duct Access Box 335mm Depth B125 Loading 81ONISO0063929 - DUCT60
02/07/2022Ragless Groundworks Ltd SO0063839NIJ150TD90 150mm ID Twinwall Drain Bend D/Socket 90 deg Short Radius, inc. seals 200ONISO0063839 - 150TD90
04/07/2022Harringtons Builders Plc SO0064381NIJ6VF20D 160mm PVC Drainage D/Socket Coupler 1-8ONISO0064381 - 6VF20D
05/07/2022Independent Building Merchants Group Ltd T/A Chandlers SO0064499RJ 7930322532 x 25mm Plasson Reducing Set 10SOSO0064499 - 79303225
05/07/2022Independent Building Merchants Group Ltd T/A Chandlers SO0064499RJ 70615150mm x 32mm Compression Reducing Coupling 113SOSO0064499 - 706151
05/07/2022Coinford Ltd SO0064434LK 6VF20D 160mm PVC Drainage D/Socket Coupler 40-8ONISO0064434 - 6VF20D
05/07/2022Performance Foundations Ltd SO0064485NIJ450VCFC Polypropylene Cover & Frame: 450mm dia 50 kn Circular Locked 60ONISO0064485 - 450VCFC
05/07/2022Pipetech Environmental Systems Ltd SO0064243NIJ450VCFC Polypropylene Cover & Frame: 450mm dia 50 kn Circular Locked 10ONISO0064243 - 450VCFC
05/07/2022Coinford Ltd SO0064434LK 450VC6 450mm Inspection Chamber Base 160mm Channel 2 x 160mm Inlets & 2 x 110mm Inlets, for installation up to 1.2m100ONISO0064434 - 450VC6
07/07/2022CAV Groundworks Ltd SO0064731NIJKD3560SDuctile Iron Cover & Frame: 750 x 600mm; B125 112ISSO0064731 - KD3560S
07/07/2022CAV Groundworks Ltd SO0064731NIJKD3140SDuctile Iron Cover & Frame: 300 x 300mm; B125 40mm deep 51SLSO0064731 - KD3140S
07/07/2022Harringtons Builders PlcSO0064606NIJJMF104 STAKKAbox Quad Access Chamber 915x445x150mm BT Approved 262SLSO0064606 - JMF104
07/07/2022Modebest Builders Ltd SO0064709LK 6VF90D 160mm UPVC Drainage D/Socket Bend 87.5deg 90ONISO0064709 - 6VF90D
11/07/2022Ground Construction Ltd SO0064956LK VFFAC1221 110-122mm / 80-95mm Flexible Adaptor Coupling 400SOSO0064956 - VFFAC1221
11/07/2022Harkmac Construction Ltd SO0065014NIJPC7CGG Cover & Galv Frame 600 x 600mm; 10 Ton 210ISSO0065014 - PC7CGG
11/07/2022CAV Groundworks Ltd SO0064735NIJFNHX100RGCMMULTIV 100mm Slotted Heelguard Grating C250 x0.5m 350SLSO0064735 - FNHX100RGCM
11/07/2022Hillary Groundworks Ltd SO0064927LK 6VF20D 160mm PVC Drainage D/Socket Coupler 51450ISSO0064927 - 6VF20D
11/07/2022Harkmac Construction Ltd SO0065014NIJ6VCA10150 250mm Vision 600 chamber, outlet adaptor to 150mm TW – Socket 47ISSO0065014 - 6VCA10150
11/07/2022CAV Groundworks Ltd SO0064734NIJ4VPR 110mm Underground Drainage Rocker Pipe x600mm 53SOSO0064734 - 4VPR
11/07/2022Digging It Groundworks SO0064996LK 4VP6 110mm UPVC Drainage Plain Ended Pipe x6m 160ONISO0064996 - 4VP6
11/07/2022Quantum Civil Engineering LimitedSO0064938LK 4VP6 110mm UPVC Drainage Plain Ended Pipe x6m 140ONISO0064938 - 4VP6
11/07/2022Aspects Builders SO0064912LK 4VP6 110mm UPVC Drainage Plain Ended Pipe x6m 70ONISO0064912 - 4VP6
11/07/2022Ground Construction Ltd SO0064865LK 12VP3S 315mm S/Socket Sewer Pipe x3m 12ONISO0064865 - 12VP3S
12/07/2022J Coffey Construction Limited SO0062726LK SPECIAL Special 25-1ONISO0062726 - SPECIAL
12/07/2022J Coffey Construction Limited SO0062726LK SPECIAL Special 250-1ONISO0062726 - SPECIAL
12/07/2022O'Halloran & O'Brien Ltd SO0065024LK DR4545/A Block Pavior Cover: 450 x 450 x 100mm; Galvanised - 10 ton GLVW 1016SLSO0065024 - DR4545/A
12/07/2022J Coffey Construction Limited SO0062726LK CARR Carriage Charge 10NSISO0062726 - CARR
12/07/2022Centenary Constructions Ltd SO0065080NIJME6060150Ecolite D400 600x600mm Access Chamber Section x150mm High 270SOSO0065080 - ME6060150
12/07/2022Centenary Constructions Ltd SO0065080NIJDISCC Discount 10NSISO0065080 - DISCC
12/07/2022RJK Groundworks Limited SO0065119NIJ4VP6 110mm UPVC Drainage Plain Ended Pipe x6m 5144ONISO0065119 - 4VP6
12/07/2022Sunshine Developments SE Limited SO0065069SB 4VP6 110mm UPVC Drainage Plain Ended Pipe x6m 2144ONISO0065069 - 4VP6
12/07/2022Eclipse Civil Engineering LimitedSO0065109SB 4VP6 110mm UPVC Drainage Plain Ended Pipe x6m 2144ONISO0065109 - 4VP6
12/07/2022Fulker Contractors Ltd SO0065115KB 4VP6 110mm UPVC Drainage Plain Ended Pipe x6m 20144ONISO0065115 - 4VP6
12/07/2022Baram Ltd SO0065041LK 4VP6 110mm UPVC Drainage Plain Ended Pipe x6m 2144ONISO0065041 - 4VP6
13/07/2022Speedeck Foundations Ltd SO0065018NIJ4VP6 110mm UPVC Drainage Plain Ended Pipe x6m 10144ONISO0065018 - 4VP6
13/07/2022JVB Construction LimitedSO0064975LKDR4545/ABlock Pavior Cover: 450 x 450 x 100mm; Galvanised - 10 ton GLVW 20ONISO0064975 - DR4545/A
13/07/2022Hambridge Homes Ltd SO0065145KBBBA500 Damp Proof Membrane 500mu/ 2000 Gauge Polythene 4 x 12.5m Roll 10ONISO0065145 - BBA500
14/07/2022Ashley Groundworks Ltd SO0064656NIJSPECIAL Special 112ONISO0064656 - SPECIAL
14/07/2022Ashley Groundworks Ltd SO0064656NIJSPECIAL Special 512ONISO0064656 - SPECIAL
15/07/2022Ashley Groundworks Ltd SO0064656NIJSPECIAL Special 212ONISO0064656 - SPECIAL
15/07/2022Blakeley Construction Profiles LtdSO0065385LK DISCC Discount 10LSSO0065385 - DISCC
15/07/2022Ashley Groundworks Ltd SO0064656NIJ90GP6 90mm MDPE Gas Pipe x6m; Yellow 10ONISO0064656 - 90GP6
15/07/2022Ashley Groundworks Ltd SO0064656NIJ63GP50 MDPE Gas Pipe: 63mm x 50m Coil; Yellow PE80/ SDR11 10ONISO0064656 - 63GP50
15/07/2022Proseptic Ltd SO0065322LK 4VFMUSH 110mm Soil Pipe Mushroom Vent Cowl - Black 10LSSO0065322 - 4VFMUSH
15/07/2022Ashley Groundworks Ltd SO0064656NIJ49110070Electrofusion Reducing Coupling: 90 x 63mm 10ONISO0064656 - 49110070
15/07/2022Ashley Groundworks Ltd SO0064656NIJ4906090Electrofusion Elbow 45deg: 90mm 10ONISO0064656 - 4906090
15/07/2022Ashley Groundworks Ltd SO0064656NIJ49050063Electrofusion Elbow 90deg: 63mm 10SDSO0064656 - 49050063
15/07/2022Ashley Groundworks Ltd SO0064656NIJ49040090Electrofusion Tee Junction: 90mm 10ONISO0064656 - 49040090
15/07/2022Ashley Groundworks Ltd SO0064656NIJ49040063Electrofusion Tee Junction: 63mm 10ONISO0064656 - 49040063
15/07/2022Ashley Groundworks Ltd SO0064656NIJ49010125Electrofusion Coupling: 125mm 10LSSO0064656 - 49010125
15/07/2022Ashley Groundworks Ltd SO0064656NIJ49010063Electrofusion Coupling: 63mm 312LSSO0064656 - 49010063
15/07/2022JP Dunn Construction Ltd SO0065370LK 160TW90 160mm OD Twinwall Bend Long Radius 90deg 3015LSSO0065370 - 160TW90
15/07/2022Flint Construction Ltd SO0065518LK D3104C Recessed Screed Cover Galvanised: 600 x 450mm Sealed & Locked 10SLSO0065518 - D3104C
15/07/2022Ground Construction Ltd SO0065423NIJ6VF90D 160mm UPVC Drainage D/Socket Bend 87.5deg 35ISSO0065423 - 6VF90D
15/07/2022Dorrington Homes (UK) LimitedSO0065500LK 32097050HPPE Pressure Pipe 90mmx50m Coil; Black SDR17 10 Bar/ SDR17 14ISSO0065500 - 32097050
18/07/2022Brant Storage and Removals LtdSO0065577NIJFNHX100RGCMMULTIV 100mm Slotted Heelguard Grating C250 x0.5m 2-2ONISO0065577 - FNHX100RGCM
18/07/2022JA Burke Construction Ltd SO0065700LK DR6060/A Block Pavior Cover: 600 x 600 x 100mm; Galvanised Frame - 10 ton GLVW 20SLSO0065700 - DR6060/A
18/07/2022Heronlake Construction Ltd SO0065708NG 4VG88 110mm ORANGE Square Bottle Gully Roddable 10NSISO0065708 - 4VG88
19/07/20224D Structures Ltd SO0065320NIJ450VCFSPolypropylene Cover & Frame: 450 x 450mm 50 kn Square to Round 234LSSO0065320 - 450VCFS
19/07/2022O'Halloran & O'Brien Ltd SO0065681LK 25WP50 MDPE Water Pipe: 25mm x 50m Coil; Blue 12.5 bar/ PE80/ SDR11 30NSISO0065681 - 25WP50
19/07/2022O'Halloran & O'Brien Ltd SO0065599LK 125TW90125mm ID Twinwall Duct x6m; Black Inc Coupler 55ONISO0065599 - 125TW90
19/07/2022Goldmax Ltd SO0065916LKAR200GMULTIV 200mm W x 550mm D Sump Unit x0.5m D400 D400 10ONISO0065916 - AR200G
20/07/2022Christopher Aldous SO0065746LK25WP50MDPE Water Pipe: 25mm x 50m Coil; Blue 12.5 bar/ PE80/ SDR11 20LSSO0065746 - 25WP50
20/07/2022JA Burke Construction Ltd SO0065891NIJME9090150 Ecolite 900x900mm Access Section 150mm D400 319ONISO0065891 - ME9090150
21/07/2022Blackclip Ltd SO0065843NIJID100 N/A for internal ref 10NSISO0065843 - ID100
21/07/2022ME Construction Ltd SO0066024NG 4VG88BI 110mm ORANGE Square B/Inlet Bottle Gully Roddable 150NSISO0066024 - 4VG88BI
21/07/2022Independent Building Merchants Group Ltd T/A Chandlers SO0065863NG 4VF20D 110mm PVC Drainage D/Socket Coupler 452882LSSO0065863 - 4VF20D
21/07/2022PP Construction Ltd SO0066002LK 160TWC 160mm OD Twinwall Duct Coupler (Suit 140mm ID 160mm OD Pipe) 960ONISO0066002 - 160TWC
21/07/2022Wokingham Construction Ltd SO0065927LK 100LD50/GEOPerforated Land Drain: 100mm x 50m; Geotextile Wrapped 20LSSO0065927 - 100LD50/GEO
21/07/2022JA Burke Construction Ltd SO0065891NIJME9090150Ecolite 900x900mm Access Section 150mm D400 30NSISO0065891 - ME9090150
22/07/2022Desertpool Ltd SO0066067NIJDR4545/A Block Pavior Cover: 450 x 450 x 100mm; Galvanised - 10 ton GLVW 32ONISO0066067 - DR4545/A
22/07/2022O'Halloran & O'Brien Ltd SO0066183LK 6VFC2P 6"/160mm D/Socket Clay To Plastic Adaptor 1312ONISO0066183 - 6VFC2P
22/07/2022Eclipse Civil Engineering LimitedSO0066117NG 50WP50BL HDPE Water Pipe: 50mm x50m Coil; Black 16 bar/ PE100/ SDR11 10ONISO0066117 - 50WP50BL
22/07/2022Hambridge Homes Ltd SO0066156NG 4VPR 110mm Underground Drainage Rocker Pipe x600mm 145ONISO0066156 - 4VPR
22/07/2022Wessex Fixings Ltd SO0066153RJ 34072525mm Plasson Compression Stoptap 20ONISO0066153 - 340725
25/07/2022Ground Construction LtdSO0065922NIJPIPE22 22mm Pipe Insulation 9mm Wall Thickness x1m 11010ONISO0065922 - PIPE22
25/07/2022CPL Groundworks Ltd SO0066030NIJ450VCR 450mm Inspection Chamber Shaft 300mm Height 571463ONISO0066030 - 450VCR
25/07/2022CPL Groundworks Ltd SO0066030NIJ375TWCN375mm Twinwall Pipe Coupler 1725ONISO0066030 - 375TWCN
25/07/2022CPL Groundworks Ltd SO0066030NIJ300TWCN300mm Twinwall Pipe Coupler 42115ONISO0066030 - 300TWCN
25/07/2022T Vaughan Ltd SO0066314NIJRB10045 100mm Ridgiduct Twinwall 45deg Bend 510LSSO0066314 - RB10045
26/07/2022T Vaughan Ltd SO0066314NIJME9090150 Ecolite 900x900mm Access Section 150mm D400 160ONISO0066314 - ME9090150
26/07/2022Entex Projects Ltd SO0065997LK KD73F Flat Iron Gully Grate: 300 x 300mm; B125 Ductile Hinged 178LSSO0065997 - KD73F
26/07/2022Entex Projects Ltd SO0065997LK KD50DNNS Ductile Iron Gully Grate: 420 x 420mm; D400 Hinged 975LSSO0065997 - KD50DNNS
26/07/2022Entex Projects Ltd SO0065997LK KD45 Ductile Iron Cover & Frame: 450 x 450mm; D400 227ONISO0065997 - KD45
26/07/2022Entex Projects Ltd SO0065997LK KD3440S Ductile Iron Cover & Frame: 600 x 600mm; B125 431ONISO0065997 - KD3440S
26/07/2022Entex Projects Ltd SO0065997LK KD3240S Ductile Iron Cover & Frame: 450 x 450mm; B125 454ONISO0065997 - KD3240S
26/07/2022Entex Projects Ltd SO0065997LK KD100 Ductile Iron Cover & Frame: 600 x 600 x 100mm D400 485ONISO0065997 - KD100
26/07/2022Entex Projects Ltd SO0065997LK KD100 Ductile Iron Cover & Frame: 600 x 600 x 100mm D400 385ONISO0065997 - KD100
26/07/2022Curryhills Civil Engineering LtdSO0066325NIJFNHX100RGCMMULTIV 100mm Slotted Heelguard Grating C250 x0.5m 8-2ONISO0066325 - FNHX100RGCM
26/07/2022Entex Projects Ltd SO0065997LK 6VF90D 160mm UPVC Drainage D/Socket Bend 87.5deg 57ONISO0065997 - 6VF90D
26/07/2022Galamast Ltd SO0066346LK 25WP100 MDPE Water Pipe: 25mm x 100m Coil; Blue 12.5 bar/ PE80/ SDR11 30ONISO0066346 - 25WP100
27/07/2022Entex Projects Ltd SO0065997LK 150RG90 900 x 450mm Hdpe Road Gully 150/160mm Outlet 10ONISO0065997 - 150RG90
27/07/2022Ash Contracting Ltd SO0066286NIJ110YG 600 x 300mm Yard Gully 110mm Outlet 290ONISO0066286 - 110YG
27/07/2022West Point Construction Limited SO0066443NIJFNHX100RGCMMULTIV 100mm Slotted Heelguard Grating C250 x0.5m 12600LSSO0066443 - FNHX100RGCM
28/07/2022M Vathi Limited SO0066640LK SWC55 Storm Water Crate Heavy Duty Loading 1.2 x 0.6 x 0.347m (4 crates per m3)5694ONISO0066640 - SWC55
28/07/2022Boxall Ward Ltd SO0066611KB 70605050mm Compression Coupling 113LSSO0066611 - 706050
28/07/2022DJ Pegley SO0066612SB 34072525mm Plasson Compression Stoptap 10ONISO0066612 - 340725
28/07/2022TG Cruse Groundworks Ltd SO0066596NIJ225TW45225mm ID Twinwall Duct Bend Long Radius 45deg P/E 10ONISO0066596 - 225TW45
28/07/2022Harringtons Builders Plc SO0066587NIJ225TW30225mm ID Twinwall Duct Bend Long Radius 30deg 14ONISO0066587 - 225TW30
28/07/2022Guildford Tipper Hire LtdSO0066614NIJ20WP50 MDPE Water Pipe: 20mm x 50m Coil; Blue 12.5 bar/ PE80/ SDR9 30LSSO0066614 - 20WP50
28/07/2022Guildford Tipper Hire LtdSO0066614NIJ20WP100MDPE Water Pipe: 20mm x 100m Coil; Blue 12.5 bar/ PE80/ SDR9 10ONISO0066614 - 20WP100
01/08/2022M Vathi LimitedSO0066640LKSWC55Storm Water Crate Heavy Duty Loading 1.2 x 0.6 x 0.347m (4 crates per m3)5694ONISO0066640 - SWC55
 
Upvote 0
Can you explain what is supposed be happening?
What should the code be doing exactly (since you said it is not doing anything)?
 
Upvote 0
Data with the same Order Nos should group the rows together. So we can see all the rows with same Order Nos.
 
Upvote 0
Eric Penfold said:
Data with the same Order Nos should group the rows together. So we can see all the rows with same Order Nos.
Click to expand...
By "group", do you just mean all have them next to each other?
If so, then why not just sort by column "C"?
If that is not what you mean by "group", then please explain.
 
Upvote 0
Joe4 said:
By "group", do you just mean all have them next to each other?
If so, then why not just sort by column "C"? I am sorting in col C
If that is not what you mean by "group", then please explain.
Click to expand...
Yes so any of rows with the same PartNos in col C are grouped together.
 
Upvote 0
Eric Penfold said:
Yes so any of rows with the same PartNos in col C are grouped together.
Click to expand...
How exactly do you want this to work?

Your data is not structured in the way were grouping is typically used.
Grouping is usually applied in the following circumstances:
1. Your data is sorted by the value you want to grouped by, so that all grouped records are next to each other. You seem to jump around (for example, you have "SO0065891" on one row, then some other numbers below it, then "SO0065891" again).
2. Usually there is some sort of summary row for each group, that shows a total amount, total count, or some other summary of that group. So that way when the details are grouped/hidden, you still see summarized information about that group.

Since your data does not seem to follow either of these things, I am not sure what you want your expected output to look like.
Could you give us a sample where you show a smaller section of data, and then show us what your expected results BASED ON THAT DATA should look like?

NOTE: Have you considered just using Pivot Tables instead of VBA?
 
Upvote 0
These Part No 64499 rows are grouped together. This is my plan for all rows on this sheet.

Order DateCustomer NameOrder No.Ent ByCodeDescriptionBO Qty.Intact Stock LevelsNotesBackOrderReasonCodeOrder TypeProduct TypeDupilcate Codes
01/07/2022Oliver Curran Construction Ltd SO0063929NIJDUCT60 Naylor 600x600mm Duct Access Box 335mm Depth B125 Loading 81ONISO0063929 - DUCT60
02/07/2022Ragless Groundworks Ltd SO0063839NIJ150TD90 150mm ID Twinwall Drain Bend D/Socket 90 deg Short Radius, inc. seals 200ONISO0063839 - 150TD90
04/07/2022Harringtons Builders Plc SO0064381NIJ6VF20D 160mm PVC Drainage D/Socket Coupler 1-8ONISO0064381 - 6VF20D
05/07/2022Independent Building Merchants Group Ltd T/A Chandlers SO0064499RJ 7930322532 x 25mm Plasson Reducing Set 10SOSO0064499 - 79303225
05/07/2022Independent Building Merchants Group Ltd T/A Chandlers SO0064499RJ 70615150mm x 32mm Compression Reducing Coupling 113SOSO0064499 - 706151
 
Upvote 0
Is this what you are talking about when you say "Grouping"?
(because that is what "Grouping" means in Excel).

If so, what do you expect your result of the example to look like after being "grouped"?
What exactly do you expect to see?
Note that without a summary row, clicking on the grouping would make all those grouped rows disappear from view.

And what do you want to do about all the rows with the same Order No that aren't already next to each other (like the example from your data shown below):
1659106195018.png


Do you only want the first two grouped, and the last one left out of the grouping?
Or do you want all the data sorted first by column C so ALL of the Order Numbers are together (and all 3 would be grouped in this scenario)?
 
Upvote 0
You must log in or register to reply here.

Similar threads

Keebler
  • Solved
new project: copy range without empty or blank rows
5 6 7
Replies
68
Views
2K
Keebler
Keebler
A
  • Question Question
Clock in and out 2 breaks and a lunch
Replies
0
Views
122
Aiden Jenner
A
R
  • Question Question
How can I get the value of a specific column in a range.
Replies
4
Views
465
Scott Huish
Scott Huish
O
  • Question Question
User-defined type not defined - vba/excel error
Replies
4
Views
214
RoryA
RoryA
J
  • Question Question
Userform inconsistent responses
Replies
1
Views
194
Candyman8019
C

Forum statistics

Threads
1,223,924
Messages
6,175,416
Members
452,640
Latest member
steveridge

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