sorting

L

Lowggy

New Member
Joined
Mar 3, 2018
Messages
39
I have and excel file with about 200 rows. Consecutive columns have cells with last name, first name but in between those pairs of couple there are single names. I want to sort the file in alphabetical order keeping all the couples together and listing the single names at the end and of course keeping all the other columns in tact.
 
Sort by date Sort by votes
Lowggy said:
Yes this is exactly what I want, so I just add another column and flag all the individuals that are not part of a couple and the run the formula.
Click to expand...
:confused: Run what formula?
 
Upvote 0

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
Lowggy said:
Yes this is exactly what I want, so I just add another column and flag all the individuals that are not part of a couple and the run the formula. Thanks again, your website and you individuals are extremely helpful. Randy
Click to expand...

???

here is a M code for PowerQuery (Get&Transform)
there is no formula or something like that

Code: 
[SIZE=1]let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Split Column by Delimiter" = Table.SplitColumn(Source, "Column3", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), {"Column3.1", "Column3.2"}),
    #"Grouped Rows" = Table.Group(#"Split Column by Delimiter", {"Column3.1"}, {{"Count", each Table.RowCount(_), type number}, {"CAR", each _, type table}}),
    #"Sorted Rows" = Table.Sort(#"Grouped Rows",{{"Count", Order.Descending}, {"Column3.1", Order.Ascending}}),
    #"Expanded CAR" = Table.ExpandTableColumn(#"Sorted Rows", "CAR", {"Column1", "Column2", "Column3.1", "Column3.2", "Column4", "Column5"}, {"Column1", "Column2", "Column3.1.1", "Column3.2", "Column4", "Column5"}),
    #"Merged Columns" = Table.CombineColumns(#"Expanded CAR",{"Column3.1.1", "Column3.2"},Combiner.CombineTextByDelimiter(", ", QuoteStyle.None),"Merged"),
    #"Removed Columns" = Table.RemoveColumns(#"Merged Columns",{"Column3.1", "Count"})
in
    #"Removed Columns"[/SIZE]
 
Upvote 0
Peter_SSs said:
:confused: Run what formula?
Click to expand...

I thought it was you, but I got a file showing my file with an additional column where there was a number 2 for all singles and a 1 for the couples with a formula to run at the top of the additional column.
it was not you?
 
Upvote 0
here is version with "flag". 1 = single (column: count)

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#70AD47]Column1[/td][td=bgcolor:#70AD47]Column2[/td][td=bgcolor:#70AD47]Count[/td][td=bgcolor:#70AD47]Merged[/td][td=bgcolor:#70AD47]Column4[/td][td=bgcolor:#70AD47]Column5[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
-1​
[/td][td=bgcolor:#E2EFDA]
166​
[/td][td=bgcolor:#E2EFDA]
2​
[/td][td=bgcolor:#E2EFDA]ALFORD, JIM[/td][td=bgcolor:#E2EFDA]
10​
[/td][td=bgcolor:#E2EFDA]
9​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
-1​
[/td][td]
61​
[/td][td]
2​
[/td][td]ALFORD, RUTH[/td][td]
19.5​
[/td][td]
16​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
-1​
[/td][td=bgcolor:#E2EFDA]
39​
[/td][td=bgcolor:#E2EFDA]
2​
[/td][td=bgcolor:#E2EFDA]ALMASI, CAROL*[/td][td=bgcolor:#E2EFDA]
19.1​
[/td][td=bgcolor:#E2EFDA]
16​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
-1​
[/td][td]
181​
[/td][td]
2​
[/td][td]ALMASI, DENNIS*[/td][td]
5.6​
[/td][td]
5​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
-1​
[/td][td=bgcolor:#E2EFDA]
750​
[/td][td=bgcolor:#E2EFDA]
2​
[/td][td=bgcolor:#E2EFDA]BADGER, JIM[/td][td=bgcolor:#E2EFDA]
16.7​
[/td][td=bgcolor:#E2EFDA]
15​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
-1​
[/td][td]
749​
[/td][td]
2​
[/td][td]BADGER, LYN[/td][td]
13.1​
[/td][td]
11​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
-1​
[/td][td=bgcolor:#E2EFDA]
66​
[/td][td=bgcolor:#E2EFDA]
2​
[/td][td=bgcolor:#E2EFDA]BEIERLE, BOB[/td][td=bgcolor:#E2EFDA]
9.2​
[/td][td=bgcolor:#E2EFDA]
8​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
-1​
[/td][td]
210​
[/td][td]
2​
[/td][td]BEIERLE, CAROLYN[/td][td]
20.1​
[/td][td]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
-1​
[/td][td=bgcolor:#E2EFDA]
99​
[/td][td=bgcolor:#E2EFDA]
2​
[/td][td=bgcolor:#E2EFDA]BERGER, RHONDA[/td][td=bgcolor:#E2EFDA]
20.2​
[/td][td=bgcolor:#E2EFDA]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
-1​
[/td][td]
97​
[/td][td]
2​
[/td][td]BERGER, TODD[/td][td]
18.2​
[/td][td]
16​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
-1​
[/td][td=bgcolor:#E2EFDA]
352​
[/td][td=bgcolor:#E2EFDA]
2​
[/td][td=bgcolor:#E2EFDA]BERGERON, LESLIE*[/td][td=bgcolor:#E2EFDA]
9.4​
[/td][td=bgcolor:#E2EFDA]
8​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
-1​
[/td][td]
353​
[/td][td]
2​
[/td][td]BERGERON, MAURICE*[/td][td]
17.5​
[/td][td]
16​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
-1​
[/td][td=bgcolor:#E2EFDA]
18​
[/td][td=bgcolor:#E2EFDA]
1​
[/td][td=bgcolor:#E2EFDA]ANDRIOLA, BETTY*[/td][td=bgcolor:#E2EFDA]
20.2​
[/td][td=bgcolor:#E2EFDA]
17​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
-1​
[/td][td]
57​
[/td][td]
1​
[/td][td]BARNABY, BUTCH[/td][td]
17.5​
[/td][td]
16​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]
-1​
[/td][td=bgcolor:#E2EFDA]
44​
[/td][td=bgcolor:#E2EFDA]
1​
[/td][td=bgcolor:#E2EFDA]BAUER, RICHARD*[/td][td=bgcolor:#E2EFDA]
16.8​
[/td][td=bgcolor:#E2EFDA]
15​
[/td][/tr]

[tr=bgcolor:#FFFFFF][td]
-1​
[/td][td]
130​
[/td][td]
1​
[/td][td]BELL, DON[/td][td]
16.6​
[/td][td]
15​
[/td][/tr]
[/table]
Code: 
[SIZE=1]let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Split Column by Delimiter" = Table.SplitColumn(Source, "Column3", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), {"Column3.1", "Column3.2"}),
    #"Grouped Rows" = Table.Group(#"Split Column by Delimiter", {"Column3.1"}, {{"Count", each Table.RowCount(_), type number}, {"CAR", each _, type table}}),
    #"Sorted Rows" = Table.Sort(#"Grouped Rows",{{"Count", Order.Descending}, {"Column3.1", Order.Ascending}}),
    #"Expanded CAR" = Table.ExpandTableColumn(#"Sorted Rows", "CAR", {"Column1", "Column2", "Column3.1", "Column3.2", "Column4", "Column5"}, {"Column1", "Column2", "Column3.1.1", "Column3.2", "Column4", "Column5"}),
    #"Merged Columns" = Table.CombineColumns(#"Expanded CAR",{"Column3.1.1", "Column3.2"},Combiner.CombineTextByDelimiter(", ", QuoteStyle.None),"Merged"),
    #"Removed Columns" = Table.RemoveColumns(#"Merged Columns",{"Column3.1"}),
    #"Reordered Columns" = Table.ReorderColumns(#"Removed Columns",{"Column1", "Column2", "Count", "Merged", "Column4", "Column5"})
in
    #"Reordered Columns"[/SIZE]
 
Upvote 0
sandy666 said:
here is version with "flag". 1 = single (column: count)

[TABLE="class: head"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #70AD47"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Column1[/COLOR][/TD]
[TD="bgcolor: #70AD47"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Column2[/COLOR][/TD]
[TD="bgcolor: #70AD47"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Count[/COLOR][/TD]
[TD="bgcolor: #70AD47"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Merged[/COLOR][/TD]
[TD="bgcolor: #70AD47"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Column4[/COLOR][/TD]
[TD="bgcolor: #70AD47"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Column5[/COLOR][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #E2EFDA"]
-1​
[/TD]
[TD="bgcolor: #E2EFDA"]
166​
[/TD]
[TD="bgcolor: #E2EFDA"]
2​
[/TD]
[TD="bgcolor: #E2EFDA"]ALFORD, JIM[/TD]
[TD="bgcolor: #E2EFDA"]
10​
[/TD]
[TD="bgcolor: #E2EFDA"]
9​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
-1​
[/TD]
[TD]
61​
[/TD]
[TD]
2​
[/TD]
[TD]ALFORD, RUTH[/TD]
[TD]
19.5​
[/TD]
[TD]
16​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #E2EFDA"]
-1​
[/TD]
[TD="bgcolor: #E2EFDA"]
39​
[/TD]
[TD="bgcolor: #E2EFDA"]
2​
[/TD]
[TD="bgcolor: #E2EFDA"]ALMASI, CAROL*[/TD]
[TD="bgcolor: #E2EFDA"]
19.1​
[/TD]
[TD="bgcolor: #E2EFDA"]
16​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
-1​
[/TD]
[TD]
181​
[/TD]
[TD]
2​
[/TD]
[TD]ALMASI, DENNIS*[/TD]
[TD]
5.6​
[/TD]
[TD]
5​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #E2EFDA"]
-1​
[/TD]
[TD="bgcolor: #E2EFDA"]
750​
[/TD]
[TD="bgcolor: #E2EFDA"]
2​
[/TD]
[TD="bgcolor: #E2EFDA"]BADGER, JIM[/TD]
[TD="bgcolor: #E2EFDA"]
16.7​
[/TD]
[TD="bgcolor: #E2EFDA"]
15​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
-1​
[/TD]
[TD]
749​
[/TD]
[TD]
2​
[/TD]
[TD]BADGER, LYN[/TD]
[TD]
13.1​
[/TD]
[TD]
11​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #E2EFDA"]
-1​
[/TD]
[TD="bgcolor: #E2EFDA"]
66​
[/TD]
[TD="bgcolor: #E2EFDA"]
2​
[/TD]
[TD="bgcolor: #E2EFDA"]BEIERLE, BOB[/TD]
[TD="bgcolor: #E2EFDA"]
9.2​
[/TD]
[TD="bgcolor: #E2EFDA"]
8​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
-1​
[/TD]
[TD]
210​
[/TD]
[TD]
2​
[/TD]
[TD]BEIERLE, CAROLYN[/TD]
[TD]
20.1​
[/TD]
[TD]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #E2EFDA"]
-1​
[/TD]
[TD="bgcolor: #E2EFDA"]
99​
[/TD]
[TD="bgcolor: #E2EFDA"]
2​
[/TD]
[TD="bgcolor: #E2EFDA"]BERGER, RHONDA[/TD]
[TD="bgcolor: #E2EFDA"]
20.2​
[/TD]
[TD="bgcolor: #E2EFDA"]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
-1​
[/TD]
[TD]
97​
[/TD]
[TD]
2​
[/TD]
[TD]BERGER, TODD[/TD]
[TD]
18.2​
[/TD]
[TD]
16​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #E2EFDA"]
-1​
[/TD]
[TD="bgcolor: #E2EFDA"]
352​
[/TD]
[TD="bgcolor: #E2EFDA"]
2​
[/TD]
[TD="bgcolor: #E2EFDA"]BERGERON, LESLIE*[/TD]
[TD="bgcolor: #E2EFDA"]
9.4​
[/TD]
[TD="bgcolor: #E2EFDA"]
8​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
-1​
[/TD]
[TD]
353​
[/TD]
[TD]
2​
[/TD]
[TD]BERGERON, MAURICE*[/TD]
[TD]
17.5​
[/TD]
[TD]
16​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #E2EFDA"]
-1​
[/TD]
[TD="bgcolor: #E2EFDA"]
18​
[/TD]
[TD="bgcolor: #E2EFDA"]
1​
[/TD]
[TD="bgcolor: #E2EFDA"]ANDRIOLA, BETTY*[/TD]
[TD="bgcolor: #E2EFDA"]
20.2​
[/TD]
[TD="bgcolor: #E2EFDA"]
17​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
-1​
[/TD]
[TD]
57​
[/TD]
[TD]
1​
[/TD]
[TD]BARNABY, BUTCH[/TD]
[TD]
17.5​
[/TD]
[TD]
16​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #E2EFDA"]
-1​
[/TD]
[TD="bgcolor: #E2EFDA"]
44​
[/TD]
[TD="bgcolor: #E2EFDA"]
1​
[/TD]
[TD="bgcolor: #E2EFDA"]BAUER, RICHARD*[/TD]
[TD="bgcolor: #E2EFDA"]
16.8​
[/TD]
[TD="bgcolor: #E2EFDA"]
15​
[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]
-1​
[/TD]
[TD]
130​
[/TD]
[TD]
1​
[/TD]
[TD]BELL, DON[/TD]
[TD]
16.6​
[/TD]
[TD]
15​
[/TD]
[/TR]
</tbody>[/TABLE]

Code: 
[SIZE=1]let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Split Column by Delimiter" = Table.SplitColumn(Source, "Column3", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), {"Column3.1", "Column3.2"}),
    #"Grouped Rows" = Table.Group(#"Split Column by Delimiter", {"Column3.1"}, {{"Count", each Table.RowCount(_), type number}, {"CAR", each _, type table}}),
    #"Sorted Rows" = Table.Sort(#"Grouped Rows",{{"Count", Order.Descending}, {"Column3.1", Order.Ascending}}),
    #"Expanded CAR" = Table.ExpandTableColumn(#"Sorted Rows", "CAR", {"Column1", "Column2", "Column3.1", "Column3.2", "Column4", "Column5"}, {"Column1", "Column2", "Column3.1.1", "Column3.2", "Column4", "Column5"}),
    #"Merged Columns" = Table.CombineColumns(#"Expanded CAR",{"Column3.1.1", "Column3.2"},Combiner.CombineTextByDelimiter(", ", QuoteStyle.None),"Merged"),
    #"Removed Columns" = Table.RemoveColumns(#"Merged Columns",{"Column3.1"}),
    #"Reordered Columns" = Table.ReorderColumns(#"Removed Columns",{"Column1", "Column2", "Count", "Merged", "Column4", "Column5"})
in
    #"Reordered Columns"[/SIZE]
Click to expand...
Ok I see your code now, thank you.
 
Upvote 0
Lowggy said:
I thought it was you, but I got a file showing my file with an additional column where there was a number 2 for all singles and a 1 for the couples with a formula to run at the top of the additional column.
it was not you?
Click to expand...
What you quoted in post 10 was from Sandy666 so I assumed that your comments in that post were directed at him.

Post 9 was my suggestion for a manual approach. The formula in column F was to mark couples/multiples with a 1 and singles with a 2 and then manually sort the data. You said the easiest method and I thought that was easy.

Is that what you tried?
 
Upvote 0
ok, thanks everyone. I thought learning excel would be easier than this. Now i am having trouble sorting my file. I want to keep all the double rows together that are numbered 1 and 1, 2 and 2 with the associated names but I want to sort the file so that it comes out in ascending order of the value in column F. I tried several custom sorts that I thought should work but no luck.
Here is part of the file. low couple handicap being column F
[TABLE="width: 697"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Group[/TD]
[TD]Couples Name, last then first[/TD]
[TD]Individual Handicap[/TD]
[TD]Total Couple Handicap[/TD]
[TD]Low Couple Handicap[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]ALFORD, JIM*[/TD]
[TD]9[/TD]
[TD]25[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]ALFORD, RUTH*[/TD]
[TD]16[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]ALMASI, CAROL*[/TD]
[TD]16[/TD]
[TD]21[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]ALMASI, DENNIS*[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]BADGER, JIM*[/TD]
[TD]15[/TD]
[TD]26[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]BADGER, LYN*[/TD]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]BEIERLE, BOB*[/TD]
[TD]8[/TD]
[TD]25[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]BEIERLE, CAROLYN*[/TD]
[TD]17[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]BERGER, RHONDA*[/TD]
[TD]17[/TD]
[TD]33[/TD]
[TD]16[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]BERGER, TODD*[/TD]
[TD]16[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD]BERGERON, LESLIE*[/TD]
[TD]8[/TD]
[TD]24[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD]BERGERON, MAURICE*[/TD]
[TD]16[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD]BOBE, DONNA*[/TD]
[TD]17[/TD]
[TD]25[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD]BOBE, LARRY*[/TD]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD]BOSTWICK, CAROL*[/TD]
[TD]12[/TD]
[TD]22[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD] DAVE FULMER[/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
Sticking with a manual approach, try a formula like this in a vacant column then select all columns and sort on the new column.

Excel Workbook
BCDEFG
1GroupCouples Name, last then firstIndividual HandicapTotal Couple HandicapLow Couple Handicap
21ALFORD, JIM*92599001
31ALFORD, RUTH*169001
42ALMASI, CAROL*162155002
52ALMASI, DENNIS*55002
63BADGER, JIM*15261111003
73BADGER, LYN*1111003
84BEIERLE, BOB*82588004
94BEIERLE, CAROLYN*178004
105BERGER, RHONDA*17331616005
115BERGER, TODD*1616005
126BERGERON, LESLIE*82488006
136BERGERON, MAURICE*168006
147BOBE, DONNA*172588007
157BOBE, LARRY*88007
168BOSTWICK, CAROL*12221010008
178DAVE FULMER1010008
Sort
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question Question
VBA code to determine InDesign Layout
Replies
6
Views
525
Akuini
Akuini
C
  • Solved
Newbie Alert: Column-sorting question
Replies
4
Views
70
JamesCanale
JamesCanale
A
  • Question Question
How sort files contains specific word based on modified dates
Replies
0
Views
102
abdelfattah
A
G
  • Question Question
remove columns from multiple Excel-files in a folder
Replies
5
Views
335
gjvv
G
N
  • Solved
Command buttons not sorting - and sometimes jumping around on sort
2
Replies
10
Views
183
netxtown
N

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,021
Latest member
Justyna P

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