Formula to stack rows under each other

[Malcolm torishi]

Hi I’ve been thinking of a way to stack rows of text and numbers under each other but I just can’t get it. Can anyone help with the following :-
I have an index column say A7:A27, persons name column B7:B27,and a time column C2:C27. Each of these rows can be filled with text and numbers and some of the rows can be completely empty, so eg filled rows could be rows 9,14,18, and 20 with the rest being empty. What I am looking to do next but just don’t know how is to take all of the complete 4 rows that are filled with data and stack them under each other starting with the earliest time first in column say G7, so if I have 4 different times under column C , I what the complete row of data staked in time order from G7 down wards so that the latest time would be at the bottom of the stack
if anyone can help thank you

 

[Toadstool]

I'm assuming you want the three columns listed (Index, Name and Time) so here's my solution with some sample data:

	A	B	C	D	E	F	G	H	I
Index	Name
X12	Bert
Z99	Susan
X23	Vanessa
Index	Name	Time Sorted
Z78	Brandi	X23	Vanessa
X12	Xavier	X12	Bert
X23	Brandi
Z99	Roger
W98	John	X12	Charlie
W98	John
X34	Alf
X12	Charlie	Z77	Xavier
Z99	Roger	X12	Xavier
X23	Brandi	Z99	Susan
Z77	Xavier	Z78	Brandi
X34	Alf

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]Time[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]0:35[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]

[TD="align: center"]22:33[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: center"]0:35[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]

[TD="align: center"]22:45[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]0:35[/TD]

[TD="align: center"]8[/TD]

[TD="align: center"]22:11[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]0:35[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]1:00[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]1:00[/TD]

[TD="align: center"]11[/TD]

[TD="align: center"]2:30[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]1:00[/TD]

[TD="align: center"]12[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]2:30[/TD]

[TD="align: center"]13[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]16:25[/TD]

[TD="align: center"]14[/TD]

[TD="align: center"]1:00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]17:00[/TD]

[TD="align: center"]15[/TD]

[TD="align: center"]1:00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]22:11[/TD]

[TD="align: center"]16[/TD]

[TD="align: center"]1:00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]22:33[/TD]

[TD="align: center"]17[/TD]

[TD="align: center"]17:00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]22:45[/TD]

[TD="align: center"]18[/TD]

[TD="align: center"]16:25[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

MT1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G7[/TH]
[TD="align: left"]=IF(ROW()-ROW($G$6)-COUNTA($C$2:$C$27) > 0,"",INDEX(A$2:A$27,AGGREGATE(15,6,ROW($C$2:$C$27)-ROW($C$1)/($C$2:$C$27=I7),COUNTIF($I7:$I$26,I7))))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]H7
[/TH]
[TD="align: left"]=IF(ROW()-ROW($H$6)-COUNTA($C$2:$C$27) > 0,"",INDEX($B$2:$B$27,AGGREGATE(15,6,ROW($C$2:$C$27)-ROW($C$1)/($C$2:$C$27=I7),COUNTIF($I7:$I$26,I7))))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I7
[/TH]
[TD="align: left"]=IF(COUNTA($C$2:$C$27) < ROW()-ROW($I$6),"",AGGREGATE(15,6,$C$2:$C$27,ROW()-ROW($I$6)))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[jasonb75]

Using the same sample data as Toadstool, but with simplified formulas.

In G7, copied right to H7 then filled down

=IF($I7="","",INDEX(A:A,AGGREGATE(14,6,ROW(A$2:A$27)/($C$2:$C$27=$M7),COUNTIF($M$7:$M7,$M7))))

In I7, filled down

=IFERROR(SMALL(C$2:C$27,ROWS(I$7:I7)),"")

If there are never duplicates in the index column (column A) then the formula in H7 could be further simplified to

=IF($I7="","",INDEX($B$2:$B$27,MATCH(G7,$A$2:$A$27,0)))

 

[Toadstool]

Using the same sample data as Toadstool, but with simplified formulas.

In G7, copied right to H7 then filled down

=IF($I7="","",INDEX(A:A,AGGREGATE(14,6,ROW(A$2:A$27)/($C$2:$C$27=$M7),COUNTIF($M$7:$M7,$M7))))[/QUOTE]

Jason, Where does the M7 come from?

 

[jasonb75]

Jason, Where does the M7 come from?

Oops!
M7 should have been I7, I copied your sample to a blank sheet, then moved your results right by 4 columns, your times were in column M, mine in column I.

=IF($I7="","",INDEX(A:A,AGGREGATE(14,6,ROW(A$2:A$27)/($C$2:$C$27=$I7),COUNTIF($I$7:$I7,$I7))))

 

[sandy666]

based on example from post#2 and with PowerQuery

[SIZE=1]// Table1
let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    RBR = Table.SelectRows(Table.TransformColumnTypes(Source,{{"Time", type time}}), each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null}))),
    Sort = Table.Sort(RBR,{{"Time", Order.Ascending}, {"Name", Order.Ascending}, {"Index", Order.Ascending}})
in
    Sort[/SIZE]

Table1
[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#5B9BD5]Index[/td][td=bgcolor:#5B9BD5]Name[/td][td=bgcolor:#5B9BD5]Time[/td][td][/td][td=bgcolor:#70AD47]Index[/td][td=bgcolor:#70AD47]Name[/td][td=bgcolor:#70AD47]Time[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]X12[/td][td=bgcolor:#DDEBF7]Bert[/td][td=bgcolor:#DDEBF7]

00:35​

[/td][td][/td][td=bgcolor:#E2EFDA]X12[/td][td=bgcolor:#E2EFDA]Bert[/td][td=bgcolor:#E2EFDA]

00:35​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Z99[/td][td]Susan[/td][td]

22:33​

[/td][td][/td][td]X23[/td][td]Vanessa[/td][td]

00:35​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]X23[/td][td=bgcolor:#DDEBF7]Vanessa[/td][td=bgcolor:#DDEBF7]

00:35​

[/td][td][/td][td=bgcolor:#E2EFDA]X23[/td][td=bgcolor:#E2EFDA]Brandi[/td][td=bgcolor:#E2EFDA]

01:00​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td][/td][td]X12[/td][td]Charlie[/td][td]

01:00​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7][/td][td=bgcolor:#DDEBF7][/td][td=bgcolor:#DDEBF7][/td][td][/td][td=bgcolor:#E2EFDA]Z99[/td][td=bgcolor:#E2EFDA]Roger[/td][td=bgcolor:#E2EFDA]

01:00​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Z78[/td][td]Brandi[/td][td]

22:45​

[/td][td][/td][td]W98[/td][td]John[/td][td]

02:30​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]X12[/td][td=bgcolor:#DDEBF7]Xavier[/td][td=bgcolor:#DDEBF7]

22:11​

[/td][td][/td][td=bgcolor:#E2EFDA]X34[/td][td=bgcolor:#E2EFDA]Alf[/td][td=bgcolor:#E2EFDA]

16:25​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td][/td][td]Z77[/td][td]Xavier[/td][td]

17:00​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7][/td][td=bgcolor:#DDEBF7][/td][td=bgcolor:#DDEBF7][/td][td][/td][td=bgcolor:#E2EFDA]X12[/td][td=bgcolor:#E2EFDA]Xavier[/td][td=bgcolor:#E2EFDA]

22:11​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]W98[/td][td]John[/td][td]

02:30​

[/td][td][/td][td]Z99[/td][td]Susan[/td][td]

22:33​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7][/td][td=bgcolor:#DDEBF7][/td][td=bgcolor:#DDEBF7][/td][td][/td][td=bgcolor:#E2EFDA]Z78[/td][td=bgcolor:#E2EFDA]Brandi[/td][td=bgcolor:#E2EFDA]

22:45​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]X12[/td][td=bgcolor:#DDEBF7]Charlie[/td][td=bgcolor:#DDEBF7]

01:00​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]Z99[/td][td]Roger[/td][td]

01:00​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]X23[/td][td=bgcolor:#DDEBF7]Brandi[/td][td=bgcolor:#DDEBF7]

01:00​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td]Z77[/td][td]Xavier[/td][td]

17:00​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]X34[/td][td=bgcolor:#DDEBF7]Alf[/td][td=bgcolor:#DDEBF7]

16:25​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[/table]

 

[Malcolm torishi]

based on example from post#2 and with PowerQuery

[SIZE=1]// Table1
let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    RBR = Table.SelectRows(Table.TransformColumnTypes(Source,{{"Time", type time}}), each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null}))),
    Sort = Table.Sort(RBR,{{"Time", Order.Ascending}, {"Name", Order.Ascending}, {"Index", Order.Ascending}})
in
    Sort[/SIZE]

Table1
[TABLE="class: head"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #5B9BD5"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Index[/COLOR][/TD]
[TD="bgcolor: #5B9BD5"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Name[/COLOR][/TD]
[TD="bgcolor: #5B9BD5"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Time[/COLOR][/TD]
[TD][/TD]
[TD="bgcolor: #70AD47"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Index[/COLOR][/TD]
[TD="bgcolor: #70AD47"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Name[/COLOR][/TD]
[TD="bgcolor: #70AD47"][COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Time[/COLOR][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #DDEBF7"]X12[/TD]
[TD="bgcolor: #DDEBF7"]Bert[/TD]
[TD="bgcolor: #DDEBF7"]

00:35​

[/TD]
[TD][/TD]
[TD="bgcolor: #E2EFDA"]X12[/TD]
[TD="bgcolor: #E2EFDA"]Bert[/TD]
[TD="bgcolor: #E2EFDA"]

00:35​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Z99[/TD]
[TD]Susan[/TD]
[TD]

22:33​

[/TD]
[TD][/TD]
[TD]X23[/TD]
[TD]Vanessa[/TD]
[TD]

00:35​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #DDEBF7"]X23[/TD]
[TD="bgcolor: #DDEBF7"]Vanessa[/TD]
[TD="bgcolor: #DDEBF7"]

00:35​

[/TD]
[TD][/TD]
[TD="bgcolor: #E2EFDA"]X23[/TD]
[TD="bgcolor: #E2EFDA"]Brandi[/TD]
[TD="bgcolor: #E2EFDA"]

01:00​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]X12[/TD]
[TD]Charlie[/TD]
[TD]

01:00​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #DDEBF7"][/TD]
[TD="bgcolor: #DDEBF7"][/TD]
[TD="bgcolor: #DDEBF7"][/TD]
[TD][/TD]
[TD="bgcolor: #E2EFDA"]Z99[/TD]
[TD="bgcolor: #E2EFDA"]Roger[/TD]
[TD="bgcolor: #E2EFDA"]

01:00​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Z78[/TD]
[TD]Brandi[/TD]
[TD]

22:45​

[/TD]
[TD][/TD]
[TD]W98[/TD]
[TD]John[/TD]
[TD]

02:30​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #DDEBF7"]X12[/TD]
[TD="bgcolor: #DDEBF7"]Xavier[/TD]
[TD="bgcolor: #DDEBF7"]

22:11​

[/TD]
[TD][/TD]
[TD="bgcolor: #E2EFDA"]X34[/TD]
[TD="bgcolor: #E2EFDA"]Alf[/TD]
[TD="bgcolor: #E2EFDA"]

16:25​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Z77[/TD]
[TD]Xavier[/TD]
[TD]

17:00​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #DDEBF7"][/TD]
[TD="bgcolor: #DDEBF7"][/TD]
[TD="bgcolor: #DDEBF7"][/TD]
[TD][/TD]
[TD="bgcolor: #E2EFDA"]X12[/TD]
[TD="bgcolor: #E2EFDA"]Xavier[/TD]
[TD="bgcolor: #E2EFDA"]

22:11​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]W98[/TD]
[TD]John[/TD]
[TD]

02:30​

[/TD]
[TD][/TD]
[TD]Z99[/TD]
[TD]Susan[/TD]
[TD]

22:33​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #DDEBF7"][/TD]
[TD="bgcolor: #DDEBF7"][/TD]
[TD="bgcolor: #DDEBF7"][/TD]
[TD][/TD]
[TD="bgcolor: #E2EFDA"]Z78[/TD]
[TD="bgcolor: #E2EFDA"]Brandi[/TD]
[TD="bgcolor: #E2EFDA"]

22:45​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #DDEBF7"]X12[/TD]
[TD="bgcolor: #DDEBF7"]Charlie[/TD]
[TD="bgcolor: #DDEBF7"]

01:00​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Z99[/TD]
[TD]Roger[/TD]
[TD]

01:00​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #DDEBF7"]X23[/TD]
[TD="bgcolor: #DDEBF7"]Brandi[/TD]
[TD="bgcolor: #DDEBF7"]

01:00​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD]Z77[/TD]
[TD]Xavier[/TD]
[TD]

17:00​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: #DDEBF7"]X34[/TD]
[TD="bgcolor: #DDEBF7"]Alf[/TD]
[TD="bgcolor: #DDEBF7"]

16:25​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Thank you everyone, you make it look so easy

 

[sandy666]

you make it look so easy

because it's easy

you can do that without any formula or code

change range to table
in Filter uncheck : blanks
sort ascending Time column

 

[jasonb75]

because it's easy

I consider that to be offensive to anybody who doesn't find it easy.

 

[sandy666]

I consider that to be offensive to anybody who doesn't find it easy.

I don't think so