Locate first instance of all dates in a column and hide all remaining rows

[Darren_workforce]

Hello,

I wasn't sure if this can be done with a date/time cell like below. That's how the raw data is generated and I was hoping to work with it. What I was hoping to do was scan column C, locate the first instance of each date within that column affiliated to a status of "available" in Column B, and then hide all remaining rows so that just the one row is visible. I understand that will require VBA but I was struggling on figuring out the formula needed in order to even start building a macro.

I know my dummy data is lacking but row 2 does have the first instance of 9/1/2024, however it's related column B cell displays "unavailable" so that wouldn't count. Row 3 is the first instance of 9/3/2024 and has Available in column B and so it would stay visible and all remaining rows containing 9/3/2024 would be hidden. And then the same would be done for 9/4/2024 and then all remaining dates within the range.

Can this be done or would I need to separate out the date and the time into 2 cells first?

User Name	Status	Start Time	End Time
User Name	Offline	9/1/2024 12:53	9/3/2024 9:43
User Name	Available	9/3/2024 9:43	9/3/2024 9:55
User Name	On a Call	9/3/2024 9:55	9/3/2024 10:09
User Name	After Call Work	9/3/2024 10:09	9/3/2024 10:11
User Name	Available	9/3/2024 10:11	9/3/2024 10:11
User Name	After Call Work	9/4/2024 12:17	9/4/2024 12:19
User Name	Break	9/4/2024 12:19	9/4/2024 12:34
User Name	Available	9/4/2024 12:34	9/4/2024 12:34
User Name	Available	9/4/2024 18:31	9/4/2024 18:34
User Name	Offline	9/4/2024 18:34	9/5/2024 9:45
User Name	Available	9/5/2024 9:45	9/5/2024 9:54
User Name	After Call Work	9/9/2024 15:20	9/9/2024 15:22
User Name	After Call Work	9/9/2024 15:22	9/9/2024 15:23
User Name	Available	9/9/2024 15:22	9/9/2024 15:22
User Name	On a Call	9/9/2024 15:23	9/9/2024 15:25
User Name	After Call Work	9/9/2024 15:25	9/9/2024 15:26
User Name	On a Call	9/17/2024 12:01	9/17/2024 12:07
User Name	After Call Work	9/17/2024 12:07	9/17/2024 12:09
User Name	Prjct-Email	9/17/2024 12:09	9/17/2024 12:09
User Name	After Call Work	9/17/2024 12:09	9/17/2024 12:09
User Name	Prjct-Email	9/17/2024 12:09	9/17/2024 12:19
User Name	Available	9/17/2024 12:19	9/17/2024 12:21
User Name	Available	9/19/2024 13:49	9/19/2024 13:49
User Name	On a Call	9/19/2024 13:49	9/19/2024 13:52
User Name	After Call Work	9/19/2024 13:52	9/19/2024 13:52
User Name	On a Call	9/25/2024 11:20	9/25/2024 11:32
User Name	After Call Work	9/25/2024 11:32	9/25/2024 11:32
User Name	Prjct-Email	9/25/2024 11:32	9/25/2024 11:44
User Name	Available	9/27/2024 13:07	9/27/2024 13:07
User Name	After Call Work	9/27/2024 13:07	9/27/2024 13:07
User Name	On a Call	10/1/2024 12:53	10/1/2024 13:08
User Name	After Call Work	10/1/2024 13:08	10/1/2024 13:08

 

[HighAndWilder]

Hello,

I wasn't sure if this can be done with a date/time cell like below. That's how the raw data is generated and I was hoping to work with it. What I was hoping to do was scan column C, locate the first instance of each date within that column affiliated to a status of "available" in Column B, and then hide all remaining rows so that just the one row is visible. I understand that will require VBA but I was struggling on figuring out the formula needed in order to even start building a macro.

I know my dummy data is lacking but row 2 does have the first instance of 9/1/2024, however it's related column B cell displays "unavailable" so that wouldn't count. Row 3 is the first instance of 9/3/2024 and has Available in column B and so it would stay visible and all remaining rows containing 9/3/2024 would be hidden. And then the same would be done for 9/4/2024 and then all remaining dates within the range.

Can this be done or would I need to separate out the date and the time into 2 cells first?

User Name	Status	Start Time	End Time
User Name	Offline	9/1/2024 12:53	9/3/2024 9:43
User Name	Available	9/3/2024 9:43	9/3/2024 9:55
User Name	On a Call	9/3/2024 9:55	9/3/2024 10:09
User Name	After Call Work	9/3/2024 10:09	9/3/2024 10:11
User Name	Available	9/3/2024 10:11	9/3/2024 10:11
User Name	After Call Work	9/4/2024 12:17	9/4/2024 12:19
User Name	Break	9/4/2024 12:19	9/4/2024 12:34
User Name	Available	9/4/2024 12:34	9/4/2024 12:34
User Name	Available	9/4/2024 18:31	9/4/2024 18:34
User Name	Offline	9/4/2024 18:34	9/5/2024 9:45
User Name	Available	9/5/2024 9:45	9/5/2024 9:54
User Name	After Call Work	9/9/2024 15:20	9/9/2024 15:22
User Name	After Call Work	9/9/2024 15:22	9/9/2024 15:23
User Name	Available	9/9/2024 15:22	9/9/2024 15:22
User Name	On a Call	9/9/2024 15:23	9/9/2024 15:25
User Name	After Call Work	9/9/2024 15:25	9/9/2024 15:26
User Name	On a Call	9/17/2024 12:01	9/17/2024 12:07
User Name	After Call Work	9/17/2024 12:07	9/17/2024 12:09
User Name	Prjct-Email	9/17/2024 12:09	9/17/2024 12:09
User Name	After Call Work	9/17/2024 12:09	9/17/2024 12:09
User Name	Prjct-Email	9/17/2024 12:09	9/17/2024 12:19
User Name	Available	9/17/2024 12:19	9/17/2024 12:21
User Name	Available	9/19/2024 13:49	9/19/2024 13:49
User Name	On a Call	9/19/2024 13:49	9/19/2024 13:52
User Name	After Call Work	9/19/2024 13:52	9/19/2024 13:52
User Name	On a Call	9/25/2024 11:20	9/25/2024 11:32
User Name	After Call Work	9/25/2024 11:32	9/25/2024 11:32
User Name	Prjct-Email	9/25/2024 11:32	9/25/2024 11:44
User Name	Available	9/27/2024 13:07	9/27/2024 13:07
User Name	After Call Work	9/27/2024 13:07	9/27/2024 13:07
User Name	On a Call	10/1/2024 12:53	10/1/2024 13:08
User Name	After Call Work	10/1/2024 13:08	10/1/2024 13:08

I have not got a lot of data to go on so I created some that may not be terribly realistic.

Try this.

It assumes that the data starts in A1.

It uses the integer of the date so the time is ignored.

Locate first instance of all dates in a column and hide all remaining rows.xlsm
	A	B	C	D
1	User Name	Status	Start Time	End Time
2	User Name	Prjct-Email	01/01/2024	01/01/2024
3	User Name	Available	01/01/2024	01/01/2024
4	User Name	Available	01/01/2024	02/01/2024
5	User Name	On a Call	03/01/2024	03/01/2024
6	User Name	After Call Work	03/01/2024	03/01/2024
7	User Name	Offline	03/01/2024	03/01/2024
8	User Name	On a Call	03/01/2024	03/01/2024
9	User Name	Break	03/01/2024	03/01/2024
10	User Name	Prjct-Email	04/01/2024	04/01/2024
11	User Name	Available	04/01/2024	04/01/2024
12	User Name	After Call Work	04/01/2024	04/01/2024
13	User Name	On a Call	04/01/2024	04/01/2024
14	User Name	On a Call	04/01/2024	04/01/2024
15	User Name	Offline	04/01/2024	04/01/2024
16	User Name	Offline	05/01/2024	05/01/2024
17	User Name	Prjct-Email	06/01/2024	06/01/2024
18	User Name	Break	06/01/2024	06/01/2024
19	User Name	Prjct-Email	06/01/2024	06/01/2024
20	User Name	On a Call	06/01/2024	06/01/2024
21	User Name	On a Call	06/01/2024	06/01/2024
22	User Name	On a Call	06/01/2024	06/01/2024
23	User Name	Prjct-Email	06/01/2024	06/01/2024
24	User Name	Available	07/01/2024	07/01/2024
25	User Name	On a Call	07/01/2024	07/01/2024
26	User Name	Available	07/01/2024	07/01/2024
27	User Name	Break	07/01/2024	07/01/2024
28	User Name	Prjct-Email	07/01/2024	07/01/2024
29	User Name	Offline	07/01/2024	07/01/2024
30	User Name	Available	09/01/2024	09/01/2024
31	User Name	Available	09/01/2024	09/01/2024
32	User Name	Available	09/01/2024	09/01/2024
33	User Name	Available	09/01/2024	09/01/2024
34	User Name	After Call Work	09/01/2024	10/01/2024
35	User Name	Break	10/01/2024	10/01/2024
36	User Name	Break	10/01/2024	10/01/2024
37	User Name	Break	11/01/2024	11/01/2024
38	User Name	On a Call	11/01/2024	11/01/2024
39	User Name	After Call Work	11/01/2024	11/01/2024
40	User Name	On a Call	13/01/2024	13/01/2024
41	User Name	Break	13/01/2024	13/01/2024
42	User Name	Break	13/01/2024	13/01/2024
43	User Name	On a Call	13/01/2024	13/01/2024
44	User Name	On a Call	13/01/2024	13/01/2024
45	User Name	Offline	13/01/2024	13/01/2024
46	User Name	Offline	13/01/2024	13/01/2024
47	User Name	After Call Work	14/01/2024	14/01/2024
48	User Name	On a Call	14/01/2024	14/01/2024
49	User Name	On a Call	15/01/2024	15/01/2024
50	User Name	Available	15/01/2024	15/01/2024
51	User Name	Available	15/01/2024	15/01/2024
52	User Name	Prjct-Email	16/01/2024	16/01/2024
53	User Name	After Call Work	16/01/2024	16/01/2024
54	User Name	Available	16/01/2024	16/01/2024
55	User Name	Prjct-Email	17/01/2024	17/01/2024
56	User Name	Break	17/01/2024	17/01/2024
57	User Name	Available	18/01/2024	18/01/2024
58	User Name	After Call Work	18/01/2024	18/01/2024
59	User Name	On a Call	18/01/2024	18/01/2024
60	User Name	On a Call	18/01/2024	18/01/2024
61	User Name	Available	18/01/2024	18/01/2024
62	User Name	Prjct-Email	19/01/2024	19/01/2024
63	User Name	Offline	19/01/2024	19/01/2024
64	User Name	Break	20/01/2024	20/01/2024
65	User Name	After Call Work	20/01/2024	20/01/2024
66	User Name	After Call Work	20/01/2024	20/01/2024
67	User Name	Prjct-Email	21/01/2024	21/01/2024
68	User Name	Prjct-Email	21/01/2024	21/01/2024
69	User Name	Offline	21/01/2024	21/01/2024
70	User Name	After Call Work	22/01/2024	22/01/2024
71	User Name	Break	22/01/2024	22/01/2024
72	User Name	After Call Work	22/01/2024	22/01/2024
73	User Name	Available	22/01/2024	22/01/2024
74	User Name	Offline	23/01/2024	23/01/2024
75	User Name	Available	23/01/2024	23/01/2024
76	User Name	Prjct-Email	23/01/2024	23/01/2024
77	User Name	Offline	24/01/2024	24/01/2024
78	User Name	Break	24/01/2024	24/01/2024
79	User Name	Break	24/01/2024	24/01/2024
80	User Name	Available	24/01/2024	24/01/2024
81	User Name	Break	25/01/2024	25/01/2024
82	User Name	Offline	26/01/2024	26/01/2024
83	User Name	On a Call	26/01/2024	26/01/2024
84	User Name	Break	26/01/2024	26/01/2024
85	User Name	Offline	26/01/2024	26/01/2024
86	User Name	After Call Work	27/01/2024	27/01/2024
87	User Name	Break	27/01/2024	27/01/2024
88	User Name	On a Call	27/01/2024	27/01/2024
89	User Name	Available	27/01/2024	27/01/2024
90	User Name	On a Call	27/01/2024	27/01/2024
91	User Name	Offline	27/01/2024	27/01/2024
92	User Name	On a Call	27/01/2024	27/01/2024
93	User Name	Available	28/01/2024	28/01/2024
94	User Name	Offline	28/01/2024	28/01/2024
95	User Name	Prjct-Email	28/01/2024	28/01/2024
96	User Name	Available	28/01/2024	28/01/2024
97	User Name	After Call Work	29/01/2024	29/01/2024
98	User Name	Offline	29/01/2024	29/01/2024
99	User Name	On a Call	29/01/2024	29/01/2024
100	User Name	Available	30/01/2024	30/01/2024
101	User Name	Available	30/01/2024	30/01/2024
102	User Name	Available	30/01/2024	30/01/2024
103	User Name	Break	30/01/2024	30/01/2024
104	User Name	Prjct-Email	30/01/2024	30/01/2024
Sheet1

Public Sub subHideAvailable()
Dim arr() As Variant
Dim strFormula As String
Dim arrUnique() As Variant
Dim i As Integer
Dim ii As Integer

  With Worksheets("Sheet1").Range("A1").CurrentRegion

    With .Resize(.Rows.Count - 1, .Columns.Count).Offset(1, 0)
    
      .EntireRow.Hidden = True
    
      ' Create a two column array with the date and row number where column B is 'Available'.
      arr = Evaluate("HSTACK(FILTER(INT(" & .Columns(3).Address & ")," & .Columns(2).Address & "=" & """Available""" & ")," & _
      "FILTER(ROW(" & .Columns(1).Address & ")," & .Columns(2).Address & "=" & """Available""" & "))")
    
      ' Create a one column array of unique date values where column B is 'Available'.
      arrUnique = Evaluate("UNIQUE(FILTER(INT(" & .Columns(3).Address & ")," & .Columns(2).Address & "=" & """Available""" & "))")
      
      For i = LBound(arrUnique) To UBound(arrUnique)
        For ii = LBound(arr) To UBound(arr)
          If arr(ii, 1) = arrUnique(i, 1) Then
            Cells(arr(ii, 2), 2).EntireRow.Hidden = False
            Exit For
          End If
        Next
      Next i
    
    End With

  End With
    
End Sub

 

[Skyybot]

Is it my understanding that you want to see only available users on a certain date or range of dates. Would you be able to provide an example of what that UserName data may look like?

 

[HighAndWilder]

Hello,

I wasn't sure if this can be done with a date/time cell like below. That's how the raw data is generated and I was hoping to work with it. What I was hoping to do was scan column C, locate the first instance of each date within that column affiliated to a status of "available" in Column B, and then hide all remaining rows so that just the one row is visible. I understand that will require VBA but I was struggling on figuring out the formula needed in order to even start building a macro.

I know my dummy data is lacking but row 2 does have the first instance of 9/1/2024, however it's related column B cell displays "unavailable" so that wouldn't count. Row 3 is the first instance of 9/3/2024 and has Available in column B and so it would stay visible and all remaining rows containing 9/3/2024 would be hidden. And then the same would be done for 9/4/2024 and then all remaining dates within the range.

Can this be done or would I need to separate out the date and the time into 2 cells first?

User Name	Status	Start Time	End Time
User Name	Offline	9/1/2024 12:53	9/3/2024 9:43
User Name	Available	9/3/2024 9:43	9/3/2024 9:55
User Name	On a Call	9/3/2024 9:55	9/3/2024 10:09
User Name	After Call Work	9/3/2024 10:09	9/3/2024 10:11
User Name	Available	9/3/2024 10:11	9/3/2024 10:11
User Name	After Call Work	9/4/2024 12:17	9/4/2024 12:19
User Name	Break	9/4/2024 12:19	9/4/2024 12:34
User Name	Available	9/4/2024 12:34	9/4/2024 12:34
User Name	Available	9/4/2024 18:31	9/4/2024 18:34
User Name	Offline	9/4/2024 18:34	9/5/2024 9:45
User Name	Available	9/5/2024 9:45	9/5/2024 9:54
User Name	After Call Work	9/9/2024 15:20	9/9/2024 15:22
User Name	After Call Work	9/9/2024 15:22	9/9/2024 15:23
User Name	Available	9/9/2024 15:22	9/9/2024 15:22
User Name	On a Call	9/9/2024 15:23	9/9/2024 15:25
User Name	After Call Work	9/9/2024 15:25	9/9/2024 15:26
User Name	On a Call	9/17/2024 12:01	9/17/2024 12:07
User Name	After Call Work	9/17/2024 12:07	9/17/2024 12:09
User Name	Prjct-Email	9/17/2024 12:09	9/17/2024 12:09
User Name	After Call Work	9/17/2024 12:09	9/17/2024 12:09
User Name	Prjct-Email	9/17/2024 12:09	9/17/2024 12:19
User Name	Available	9/17/2024 12:19	9/17/2024 12:21
User Name	Available	9/19/2024 13:49	9/19/2024 13:49
User Name	On a Call	9/19/2024 13:49	9/19/2024 13:52
User Name	After Call Work	9/19/2024 13:52	9/19/2024 13:52
User Name	On a Call	9/25/2024 11:20	9/25/2024 11:32
User Name	After Call Work	9/25/2024 11:32	9/25/2024 11:32
User Name	Prjct-Email	9/25/2024 11:32	9/25/2024 11:44
User Name	Available	9/27/2024 13:07	9/27/2024 13:07
User Name	After Call Work	9/27/2024 13:07	9/27/2024 13:07
User Name	On a Call	10/1/2024 12:53	10/1/2024 13:08
User Name	After Call Work	10/1/2024 13:08	10/1/2024 13:08

Version 2 now.

Assumes Sheet1 and data starts in A1.

Locate first instance of all dates in a column and hide all remaining rows.xlsm
	A	B	C	D
1	User Name	Status	Start Time	End Time
2	User Name	Prjct-Email	01/01/2024	01/01/2024
3	User Name	Available	01/01/2024	01/01/2024
4	User Name	Available	01/01/2024	02/01/2024
5	User Name	On a Call	03/01/2024	03/01/2024
6	User Name	After Call Work	03/01/2024	03/01/2024
7	User Name	Offline	03/01/2024	03/01/2024
8	User Name	On a Call	03/01/2024	03/01/2024
9	User Name	Break	03/01/2024	03/01/2024
10	User Name	Prjct-Email	04/01/2024	04/01/2024
11	User Name	Available	04/01/2024	04/01/2024
12	User Name	After Call Work	04/01/2024	04/01/2024
13	User Name	On a Call	04/01/2024	04/01/2024
14	User Name	On a Call	04/01/2024	04/01/2024
15	User Name	Offline	04/01/2024	04/01/2024
16	User Name	Offline	05/01/2024	05/01/2024
17	User Name	Prjct-Email	06/01/2024	06/01/2024
18	User Name	Break	06/01/2024	06/01/2024
19	User Name	Prjct-Email	06/01/2024	06/01/2024
20	User Name	On a Call	06/01/2024	06/01/2024
21	User Name	On a Call	06/01/2024	06/01/2024
22	User Name	On a Call	06/01/2024	06/01/2024
23	User Name	Prjct-Email	06/01/2024	06/01/2024
24	User Name	Available	07/01/2024	07/01/2024
25	User Name	On a Call	07/01/2024	07/01/2024
26	User Name	Available	07/01/2024	07/01/2024
27	User Name	Break	07/01/2024	07/01/2024
28	User Name	Prjct-Email	07/01/2024	07/01/2024
29	User Name	Offline	07/01/2024	07/01/2024
30	User Name	Available	09/01/2024	09/01/2024
31	User Name	Available	09/01/2024	09/01/2024
32	User Name	Available	09/01/2024	09/01/2024
33	User Name	Available	09/01/2024	09/01/2024
34	User Name	After Call Work	09/01/2024	10/01/2024
35	User Name	Break	10/01/2024	10/01/2024
36	User Name	Break	10/01/2024	10/01/2024
37	User Name	Break	11/01/2024	11/01/2024
38	User Name	On a Call	11/01/2024	11/01/2024
39	User Name	After Call Work	11/01/2024	11/01/2024
40	User Name	On a Call	13/01/2024	13/01/2024
41	User Name	Break	13/01/2024	13/01/2024
42	User Name	Break	13/01/2024	13/01/2024
43	User Name	On a Call	13/01/2024	13/01/2024
44	User Name	On a Call	13/01/2024	13/01/2024
45	User Name	Offline	13/01/2024	13/01/2024
46	User Name	Offline	13/01/2024	13/01/2024
47	User Name	After Call Work	14/01/2024	14/01/2024
48	User Name	On a Call	14/01/2024	14/01/2024
49	User Name	On a Call	15/01/2024	15/01/2024
50	User Name	Available	15/01/2024	15/01/2024
51	User Name	Available	15/01/2024	15/01/2024
52	User Name	Prjct-Email	16/01/2024	16/01/2024
53	User Name	After Call Work	16/01/2024	16/01/2024
54	User Name	Available	16/01/2024	16/01/2024
55	User Name	Prjct-Email	17/01/2024	17/01/2024
56	User Name	Break	17/01/2024	17/01/2024
57	User Name	Available	18/01/2024	18/01/2024
58	User Name	After Call Work	18/01/2024	18/01/2024
59	User Name	On a Call	18/01/2024	18/01/2024
60	User Name	On a Call	18/01/2024	18/01/2024
61	User Name	Available	18/01/2024	18/01/2024
62	User Name	Prjct-Email	19/01/2024	19/01/2024
63	User Name	Offline	19/01/2024	19/01/2024
64	User Name	Break	20/01/2024	20/01/2024
65	User Name	After Call Work	20/01/2024	20/01/2024
66	User Name	After Call Work	20/01/2024	20/01/2024
67	User Name	Prjct-Email	21/01/2024	21/01/2024
68	User Name	Prjct-Email	21/01/2024	21/01/2024
69	User Name	Offline	21/01/2024	21/01/2024
70	User Name	After Call Work	22/01/2024	22/01/2024
71	User Name	Break	22/01/2024	22/01/2024
72	User Name	After Call Work	22/01/2024	22/01/2024
73	User Name	Available	22/01/2024	22/01/2024
74	User Name	Offline	23/01/2024	23/01/2024
75	User Name	Available	23/01/2024	23/01/2024
76	User Name	Prjct-Email	23/01/2024	23/01/2024
77	User Name	Offline	24/01/2024	24/01/2024
78	User Name	Break	24/01/2024	24/01/2024
79	User Name	Break	24/01/2024	24/01/2024
80	User Name	Available	24/01/2024	24/01/2024
81	User Name	Break	25/01/2024	25/01/2024
82	User Name	Offline	26/01/2024	26/01/2024
83	User Name	On a Call	26/01/2024	26/01/2024
84	User Name	Break	26/01/2024	26/01/2024
85	User Name	Offline	26/01/2024	26/01/2024
86	User Name	After Call Work	27/01/2024	27/01/2024
87	User Name	Break	27/01/2024	27/01/2024
88	User Name	On a Call	27/01/2024	27/01/2024
89	User Name	Available	27/01/2024	27/01/2024
90	User Name	On a Call	27/01/2024	27/01/2024
91	User Name	Offline	27/01/2024	27/01/2024
92	User Name	On a Call	27/01/2024	27/01/2024
93	User Name	Available	28/01/2024	28/01/2024
94	User Name	Offline	28/01/2024	28/01/2024
95	User Name	Prjct-Email	28/01/2024	28/01/2024
96	User Name	Available	28/01/2024	28/01/2024
97	User Name	After Call Work	29/01/2024	29/01/2024
98	User Name	Offline	29/01/2024	29/01/2024
99	User Name	On a Call	29/01/2024	29/01/2024
100	User Name	Available	30/01/2024	30/01/2024
101	User Name	Available	30/01/2024	30/01/2024
102	User Name	Available	30/01/2024	30/01/2024
103	User Name	Break	30/01/2024	30/01/2024
104	User Name	Prjct-Email	30/01/2024	30/01/2024
Sheet1

Public Sub subHideAvailableVersion2()
Dim i As Integer
Dim dict As Object
Dim arr() As Variant

  Set dict = CreateObject("Scripting.Dictionary")
    
  arr = Worksheets("Sheet1").Range("A1").CurrentRegion.Value
  
  Cells.EntireRow.Hidden = True
  
  Cells(1, 2).EntireRow.Hidden = False
  
  For i = 2 To UBound(arr)
  
    If arr(i, 2) = "Available" And Not dict.exists(arr(i, 3)) Then
      
      dict.Add Key:=arr(i, 3), Item:=dict.Count + 1
            
      Cells(i, 2).EntireRow.Hidden = False
      
    End If
    
  Next i
  
End Sub

 

[Peter_SSs]

I understand that will require VBA

I'm not so sure. Would either of these non-macro approaches be of interest?

The first idea is not to hide any rows at all but simply show only the relevant rows in another location.
My understanding is that it is the green rows that you want to see. If that is so, the the formula in F2 below produces just that data in columns F:I

24 10 31.xlsm
	A	B	C	D	E	F	G	H	I
1	User Name	Status	Start Time	End Time		User Name	Status	Start Time	End Time
2	User Name	Offline	1/09/2024 12:53	3/09/2024 9:43		User Name	Available	3/09/2024 9:43	3/09/2024 9:55
3	User Name	Available	3/09/2024 9:43	3/09/2024 9:55		User Name	Available	4/09/2024 12:34	4/09/2024 12:34
4	User Name	On a Call	3/09/2024 9:55	3/09/2024 10:09		User Name	Available	5/09/2024 9:45	5/09/2024 9:54
5	User Name	After Call Work	3/09/2024 10:09	3/09/2024 10:11		User Name	Available	9/09/2024 15:22	9/09/2024 15:22
6	User Name	Available	3/09/2024 10:11	3/09/2024 10:11		User Name	Available	17/09/2024 12:19	17/09/2024 12:21
7	User Name	After Call Work	4/09/2024 12:17	4/09/2024 12:19		User Name	Available	19/09/2024 13:49	19/09/2024 13:49
8	User Name	Break	4/09/2024 12:19	4/09/2024 12:34		User Name	Available	27/09/2024 13:07	27/09/2024 13:07
9	User Name	Available	4/09/2024 12:34	4/09/2024 12:34
10	User Name	Available	4/09/2024 18:31	4/09/2024 18:34
11	User Name	Offline	4/09/2024 18:34	5/09/2024 9:45
12	User Name	Available	5/09/2024 9:45	5/09/2024 9:54
13	User Name	After Call Work	9/09/2024 15:20	9/09/2024 15:22
14	User Name	After Call Work	9/09/2024 15:22	9/09/2024 15:23
15	User Name	Available	9/09/2024 15:22	9/09/2024 15:22
16	User Name	On a Call	9/09/2024 15:23	9/09/2024 15:25
17	User Name	After Call Work	9/09/2024 15:25	9/09/2024 15:26
18	User Name	On a Call	17/09/2024 12:01	17/09/2024 12:07
19	User Name	After Call Work	17/09/2024 12:07	17/09/2024 12:09
20	User Name	Prjct-Email	17/09/2024 12:09	17/09/2024 12:09
21	User Name	After Call Work	17/09/2024 12:09	17/09/2024 12:09
22	User Name	Prjct-Email	17/09/2024 12:09	17/09/2024 12:19
23	User Name	Available	17/09/2024 12:19	17/09/2024 12:21
24	User Name	Available	19/09/2024 13:49	19/09/2024 13:49
25	User Name	On a Call	19/09/2024 13:49	19/09/2024 13:52
26	User Name	After Call Work	19/09/2024 13:52	19/09/2024 13:52
27	User Name	On a Call	25/09/2024 11:20	25/09/2024 11:32
28	User Name	After Call Work	25/09/2024 11:32	25/09/2024 11:32
29	User Name	Prjct-Email	25/09/2024 11:32	25/09/2024 11:44
30	User Name	Available	27/09/2024 13:07	27/09/2024 13:07
31	User Name	After Call Work	27/09/2024 13:07	27/09/2024 13:07
32	User Name	On a Call	1/10/2024 12:53	1/10/2024 13:08
33	User Name	After Call Work	1/10/2024 13:08	1/10/2024 13:08
Hide rows

Cell Formulas
Range	Formula
F2:I8	F2	=LET(a,FILTER(A2:D33,B2:B33="Available"),st,INDEX(a,0,3),FILTER(a,(INDEX(a,0,2)="Available")*(st=XLOOKUP(INT(st),INT(st),st))))
Dynamic array formulas.

My second idea does actually hide the rows.
For my layout

24 10 31.xlsm
	A	B	C	D	E	F	G	H
1	User Name	Status	Start Time	End Time
2	User Name	Offline	1/09/2024 12:53	3/09/2024 9:43				#N/A
3	User Name	Available	3/09/2024 9:43	3/09/2024 9:55
4	User Name	On a Call	3/09/2024 9:55	3/09/2024 10:09
5	User Name	After Call Work	3/09/2024 10:09	3/09/2024 10:11
6	User Name	Available	3/09/2024 10:11	3/09/2024 10:11
7	User Name	After Call Work	4/09/2024 12:17	4/09/2024 12:19
8	User Name	Break	4/09/2024 12:19	4/09/2024 12:34
9	User Name	Available	4/09/2024 12:34	4/09/2024 12:34
10	User Name	Available	4/09/2024 18:31	4/09/2024 18:34
11	User Name	Offline	4/09/2024 18:34	5/09/2024 9:45
12	User Name	Available	5/09/2024 9:45	5/09/2024 9:54
13	User Name	After Call Work	9/09/2024 15:20	9/09/2024 15:22
14	User Name	After Call Work	9/09/2024 15:22	9/09/2024 15:23
15	User Name	Available	9/09/2024 15:22	9/09/2024 15:22
16	User Name	On a Call	9/09/2024 15:23	9/09/2024 15:25
17	User Name	After Call Work	9/09/2024 15:25	9/09/2024 15:26
18	User Name	On a Call	17/09/2024 12:01	17/09/2024 12:07
19	User Name	After Call Work	17/09/2024 12:07	17/09/2024 12:09
20	User Name	Prjct-Email	17/09/2024 12:09	17/09/2024 12:09
21	User Name	After Call Work	17/09/2024 12:09	17/09/2024 12:09
22	User Name	Prjct-Email	17/09/2024 12:09	17/09/2024 12:19
23	User Name	Available	17/09/2024 12:19	17/09/2024 12:21
24	User Name	Available	19/09/2024 13:49	19/09/2024 13:49
25	User Name	On a Call	19/09/2024 13:49	19/09/2024 13:52
26	User Name	After Call Work	19/09/2024 13:52	19/09/2024 13:52
27	User Name	On a Call	25/09/2024 11:20	25/09/2024 11:32
28	User Name	After Call Work	25/09/2024 11:32	25/09/2024 11:32
29	User Name	Prjct-Email	25/09/2024 11:32	25/09/2024 11:44
30	User Name	Available	27/09/2024 13:07	27/09/2024 13:07
31	User Name	After Call Work	27/09/2024 13:07	27/09/2024 13:07
32	User Name	On a Call	1/10/2024 12:53	1/10/2024 13:08
33	User Name	After Call Work	1/10/2024 13:08	1/10/2024 13:08
Hide rows (2)

Cell Formulas
Range	Formula
H2	H2	=MATCH("Available"&INT(C2),B$2:B$33&INT(C$2:C$33),0)=ROW(C2)-ROW(C$2)+1

• Put the formula shown in H2 (H1 must be empty
• Select the data (A1:D33 for me)
• On the Data ribbon tab select 'Advanced' in the 'sort & Filter' section
• Complete the dialog as shown below (note the Criteria range includes the empty cell H1) and then click OK

Here is the result for me

24 10 31.xlsm
	A	B	C	D
1	User Name	Status	Start Time	End Time
3	User Name	Available	3/09/2024 9:43	3/09/2024 9:55
9	User Name	Available	4/09/2024 12:34	4/09/2024 12:34
12	User Name	Available	5/09/2024 9:45	5/09/2024 9:54
15	User Name	Available	9/09/2024 15:22	9/09/2024 15:22
23	User Name	Available	17/09/2024 12:19	17/09/2024 12:21
24	User Name	Available	19/09/2024 13:49	19/09/2024 13:49
30	User Name	Available	27/09/2024 13:07	27/09/2024 13:07
34
Hide rows (2)

To unhide the rows again click 'Clear' in the 'Sort & Filter' section of the 'data' ribbon tab.

N.B. Both of the above approaches could be implemented by vba if you really want/need that.