Tough Data Sheet to get Login/Login dates and times.

pitcrew · Sep 29, 2023

Hello, I have a difficult Spreadsheet I am working with to try and get the data I need. I am trying to get sign-in (S/In) and Sign-out (S/Out) times for my employees from phone system report.
The problem is the report shows each employee's sign-in and sign-out for the entire week. Also, these events show multiple times (as when they login it logs them into several different phone ques all at once). So I need to find a way to pull out the first sign-in for each employee each day. then I need to pull the last sign-out for each employee each day.

Here is the mini sheet of the data, smaller version of course.

Pitcrew Login -Logout Report.xlsx

A

B

C

1

Entry Time

Agent Name

State Chg

2

9/11/2023 9:01

Jennifer Leibenguth

S/In

3

9/11/2023 9:01

Jennifer Leibenguth

N/A

4

9/11/2023 9:01

Jennifer Leibenguth

S/In

5

9/11/2023 9:01

Jennifer Leibenguth

S/In

6

9/11/2023 9:01

Jennifer Leibenguth

S/In

7

9/11/2023 9:01

Jennifer Leibenguth

S/In

8

9/11/2023 9:01

Jennifer Leibenguth

S/In

9

9/11/2023 9:01

Jennifer Leibenguth

S/In

10

9/11/2023 9:01

Jennifer Leibenguth

Avail

11

9/11/2023 9:01

Jennifer Leibenguth

Alrt(Call)/A

12

9/11/2023 9:01

Jennifer Leibenguth

Busy(Call)/A

13

9/11/2023 9:05

Bonnie Bleier

Busy(Call)/A

14

9/11/2023 9:11

Jennifer Leibenguth

Avail

15

9/11/2023 9:11

Jennifer Leibenguth

W/U

16

9/11/2023 9:11

Jennifer Leibenguth

Avail

17

9/11/2023 9:13

Bonnie Bleier

Avail

18

9/11/2023 9:14

Bonnie Bleier

Avail

19

9/11/2023 9:14

Jennifer Leibenguth

Alrt(Call)/A

20

9/11/2023 9:15

Jennifer Leibenguth

Busy(Call)/A

21

9/11/2023 9:18

Jennifer Leibenguth

Avail

22

9/11/2023 9:29

Lori Dement

S/In

23

9/11/2023 9:29

Lori Dement

N/A

24

9/11/2023 9:29

Lori Dement

S/In

25

9/11/2023 9:29

Lori Dement

S/In

26

9/11/2023 9:29

Lori Dement

S/In

27

9/11/2023 9:29

Lori Dement

S/In

28

9/11/2023 9:29

Lori Dement

S/In

29

9/11/2023 9:52

Bonnie Bleier

Avail

30

9/11/2023 9:53

David Powers

S/In

31

9/11/2023 9:53

David Powers

N/A

32

9/11/2023 9:53

David Powers

S/In

33

9/11/2023 9:53

David Powers

S/In

34

9/11/2023 9:53

David Powers

S/In

35

9/11/2023 9:53

David Powers

S/In

36

9/11/2023 9:53

David Powers

S/In

37

9/11/2023 9:54

Jennifer Leibenguth

N/A

38

9/11/2023 9:57

Bonnie Bleier

Alrt(Call)/A

39

9/11/2023 9:57

Bonnie Bleier

Busy(Call)/A

40

9/11/2023 9:57

Jennifer Leibenguth

Avail

41

9/11/2023 10:00

Bonnie Bleier

Avail

42

9/11/2023 10:00

Bonnie Bleier

W/U

43

9/11/2023 11:37

David Powers

Alrt(Call)/A

44

9/11/2023 11:37

Lori Dement

N/A

45

9/11/2023 11:37

David Powers

Busy(Call)/A

46

9/11/2023 11:45

David Powers

Avail

47

9/11/2023 11:45

David Powers

W/U

48

9/11/2023 11:55

Bonnie Bleier

W/U

49

9/11/2023 11:55

Bonnie Bleier

Avail

50

9/11/2023 15:00

Marianne Peterson

S/Out

51

9/11/2023 15:00

Marianne Peterson

S/Out

52

9/11/2023 15:00

Marianne Peterson

S/Out

53

9/11/2023 15:00

Marianne Peterson

S/Out

54

9/11/2023 15:00

Marianne Peterson

S/Out

55

9/11/2023 15:00

Marianne Peterson

S/Out

56

9/11/2023 15:00

Marianne Peterson

S/Out

57

9/11/2023 15:05

David Powers

N/A

58

9/11/2023 15:06

David Powers

Avail

59

9/11/2023 15:12

Bonnie Bleier

Avail

60

9/11/2023 15:12

Bonnie Bleier

W/U

61

9/11/2023 15:12

Bonnie Bleier

Avail

62

9/11/2023 15:14

Bonnie Bleier

Alrt(Call)/A

63

9/11/2023 15:14

Bonnie Bleier

Busy(Call)/A

64

9/11/2023 15:15

Jennifer Leibenguth

Avail

65

9/11/2023 15:15

Jennifer Leibenguth

W/U

66

9/11/2023 15:15

David Powers

Avail

67

9/11/2023 15:15

David Powers

W/U

68

9/11/2023 15:15

Jennifer Leibenguth

Avail

69

9/11/2023 15:15

David Powers

Avail

70

9/11/2023 15:17

Jennifer Leibenguth

N/A

71

9/11/2023 15:19

Bonnie Bleier

Avail

72

9/11/2023 15:20

Bonnie Bleier

Alrt(Call)/A

73

9/11/2023 15:21

Bonnie Bleier

Busy(Call)/A

74

9/11/2023 15:21

Jennifer Leibenguth

Avail

75

9/11/2023 15:21

Bonnie Bleier

Avail

76

9/11/2023 15:32

Jennifer Leibenguth

N/A

77

9/11/2023 15:32

Lori Dement

Alrt(Call)/A

78

9/11/2023 15:32

Lori Dement

Busy(Call)/A

79

9/11/2023 15:37

Lori Dement

Avail

80

9/11/2023 15:37

Lori Dement

W/U

81

9/11/2023 15:38

Lori Dement

Avail

82

9/11/2023 15:46

Bonnie Bleier

W/U

83

9/11/2023 15:46

Bonnie Bleier

Avail

84

9/11/2023 15:48

Lori Dement

Avail

85

9/11/2023 15:48

Lori Dement

W/U

86

9/11/2023 15:48

Lori Dement

Avail

87

9/11/2023 15:51

Bonnie Bleier

Alrt(Call)/A

88

9/11/2023 15:51

Bonnie Bleier

Busy(Call)/A

89

9/11/2023 15:57

Lori Dement

N/A

90

9/11/2023 15:59

Bonnie Bleier

N/A

91

9/11/2023 16:01

Bonnie Bleier

S/Out

92

9/11/2023 16:01

Bonnie Bleier

S/Out

93

9/11/2023 16:01

Bonnie Bleier

S/Out

94

9/11/2023 16:01

Bonnie Bleier

S/Out

95

9/11/2023 16:01

Bonnie Bleier

S/Out

96

9/11/2023 16:01

Bonnie Bleier

S/Out

97

9/11/2023 16:03

David Powers

Avail

98

9/11/2023 16:07

David Powers

Alrt(Call)/A

99

9/11/2023 16:07

David Powers

Busy(Call)/A

100

9/11/2023 16:10

Jennifer Leibenguth

Avail

101

9/11/2023 16:13

David Powers

Avail

102

9/11/2023 16:13

David Powers

W/U

103

9/11/2023 16:13

David Powers

Avail

104

9/11/2023 16:17

Jennifer Leibenguth

Alrt(Call)/A

105

9/11/2023 16:17

Jennifer Leibenguth

Busy(Call)/A

106

9/11/2023 16:20

David Powers

Alrt(Call)/A

107

9/11/2023 16:20

David Powers

Busy(Call)/A

108

9/11/2023 16:23

Jennifer Leibenguth

Avail

109

9/11/2023 16:23

Jennifer Leibenguth

W/U

110

9/11/2023 16:23

Jennifer Leibenguth

Avail

111

9/11/2023 16:33

Jennifer Leibenguth

Alrt(Call)/A

112

9/11/2023 16:33

Jennifer Leibenguth

Busy(Call)/A

113

9/11/2023 16:34

David Powers

Avail

114

9/11/2023 16:34

David Powers

W/U

115

9/11/2023 16:34

David Powers

Avail

116

9/11/2023 16:36

David Powers

Alrt(Call)/A

117

9/11/2023 16:36

Jennifer Leibenguth

Avail

118

9/11/2023 16:36

Jennifer Leibenguth

W/U

119

9/11/2023 16:36

David Powers

Busy(Call)/A

120

9/11/2023 16:37

Jennifer Leibenguth

Avail

121

9/11/2023 16:42

David Powers

Avail

122

9/11/2023 16:42

David Powers

W/U

123

9/11/2023 16:42

David Powers

Avail

124

9/11/2023 16:46

Lori Dement

Avail

125

9/11/2023 16:52

Lori Dement

Alrt(Call)/A

126

9/11/2023 16:52

Lori Dement

Busy(Call)/A

127

9/11/2023 16:52

David Powers

N/A

128

9/11/2023 16:53

Jennifer Leibenguth

Alrt(Call)/A

129

9/11/2023 16:53

Jennifer Leibenguth

Busy(Call)/A

130

9/11/2023 16:57

David Powers

S/Out

131

9/11/2023 16:57

David Powers

S/Out

132

9/11/2023 16:57

David Powers

S/Out

133

9/11/2023 16:57

David Powers

S/Out

134

9/11/2023 16:57

David Powers

S/Out

135

9/11/2023 16:57

David Powers

S/Out

136

9/11/2023 16:57

Jennifer Leibenguth

Avail

137

9/11/2023 16:57

Jennifer Leibenguth

W/U

138

9/11/2023 17:00

Jennifer Leibenguth

Alrt(Call)/A

139

9/11/2023 17:00

Jennifer Leibenguth

Busy(Call)/A

140

9/11/2023 17:00

Lori Dement

Avail

141

9/11/2023 17:00

Lori Dement

W/U

142

9/11/2023 17:01

Lori Dement

Avail

143

9/11/2023 17:04

Lori Dement

Alrt(Call)/A

144

9/11/2023 17:04

Lori Dement

Busy(Call)/A

145

9/11/2023 17:05

Lori Dement

Avail

146

9/11/2023 17:05

Lori Dement

W/U

147

9/11/2023 17:05

Lori Dement

Avail

148

9/11/2023 17:06

Jennifer Leibenguth

Avail

149

9/11/2023 17:06

Jennifer Leibenguth

W/U

150

9/11/2023 17:24

Lori Dement

Avail

151

9/11/2023 17:25

Lori Dement

Alrt(Call)/A

152

9/11/2023 17:25

Lori Dement

Busy(Call)/A

153

9/11/2023 17:29

Jennifer Leibenguth

S/Out

154

9/11/2023 17:29

Jennifer Leibenguth

S/Out

155

9/11/2023 17:29

Jennifer Leibenguth

S/Out

156

9/11/2023 17:29

Jennifer Leibenguth

S/Out

157

9/11/2023 17:43

Lori Dement

Avail

158

9/11/2023 17:43

Lori Dement

Alrt(Call)/A

159

9/11/2023 17:43

Lori Dement

Busy(Call)/A

160

9/11/2023 17:47

Lori Dement

N/A

161

9/11/2023 17:50

David Powers

S/In

162

9/11/2023 17:50

David Powers

N/A

163

9/11/2023 17:50

David Powers

S/In

164

9/11/2023 17:50

David Powers

S/In

165

9/11/2023 17:51

David Powers

Avail

166

9/11/2023 17:51

David Powers

Alrt(Call)/A

167

9/11/2023 17:51

David Powers

Busy(Call)/A

168

9/11/2023 17:51

Lori Dement

S/Out

169

9/11/2023 17:51

Lori Dement

S/Out

170

9/11/2023 17:51

Lori Dement

S/Out

171

9/12/2023 9:01

Bonnie Bleier

S/In

172

9/12/2023 9:01

Bonnie Bleier

S/In

173

9/12/2023 9:01

Bonnie Bleier

S/In

174

9/12/2023 9:24

David Powers

S/In

175

9/12/2023 9:24

David Powers

N/A

176

9/12/2023 9:24

David Powers

S/In

177

9/12/2023 9:24

David Powers

S/In

178

9/12/2023 9:27

Jennifer Leibenguth

S/In

179

9/12/2023 9:27

Jennifer Leibenguth

N/A

180

9/12/2023 9:27

Jennifer Leibenguth

S/In

181

9/12/2023 9:49

Lori Dement

Busy(Call)/A

182

9/12/2023 9:50

David Powers

Alrt(Call)/A

183

9/12/2023 9:50

David Powers

Busy(Call)/A

184

9/12/2023 9:52

Bonnie Bleier

S/Out

185

9/12/2023 9:52

Bonnie Bleier

S/Out

186

9/12/2023 9:52

Bonnie Bleier

S/Out

187

9/12/2023 9:52

Bonnie Bleier

S/Out

188

9/12/2023 9:52

David Powers

Avail

189

9/12/2023 9:52

David Powers

W/U

190

9/12/2023 9:52

David Powers

Avail

191

9/12/2023 9:53

David Powers

Alrt(Call)/A

192

9/12/2023 9:53

David Powers

Busy(Call)/A

193

9/12/2023 9:53

David Powers

Avail

194

9/12/2023 9:54

Lori Dement

Avail

195

9/12/2023 9:58

David Powers

Alrt(Call)/A

196

9/12/2023 9:58

David Powers

Busy(Call)/A

197

9/12/2023 9:59

David Powers

Avail

198

9/12/2023 9:59

David Powers

W/U

199

9/12/2023 9:59

Lori Dement

Alrt(Call)/A

200

9/12/2023 9:59

Lori Dement

Busy(Call)/A

201

9/12/2023 9:59

David Powers

Avail

202

9/12/2023 9:59

David Powers

Alrt(Call)/A

203

9/12/2023 9:59

David Powers

Busy(Call)/A

204

9/12/2023 10:37

Lori Dement

Avail

205

9/12/2023 10:37

Lori Dement

Alrt(Call)/A

206

9/12/2023 10:37

Lori Dement

Busy(Call)/A

207

9/12/2023 10:41

Bonnie Bleier

S/In

208

9/12/2023 10:41

Bonnie Bleier

S/In

209

9/12/2023 10:41

Bonnie Bleier

Alrt(Call)/A

210

9/12/2023 10:41

Bonnie Bleier

Busy(Call)/A

211

9/12/2023 10:43

Lori Dement

Avail

212

9/12/2023 10:43

Lori Dement

W/U

213

9/12/2023 10:43

Lori Dement

Avail

214

9/12/2023 10:45

Lori Dement

Alrt(Call)/A

215

9/12/2023 10:45

Lori Dement

Busy(Call)/A

216

9/12/2023 10:45

Bonnie Bleier

Avail

217

9/12/2023 10:45

Bonnie Bleier

W/U

218

9/12/2023 10:45

Bonnie Bleier

Avail

219

9/12/2023 10:51

Lori Dement

Avail

220

9/12/2023 10:51

Lori Dement

W/U

221

9/12/2023 10:51

Lori Dement

Avail

222

9/12/2023 10:52

Lori Dement

Alrt(Call)/A

223

9/12/2023 10:52

Lori Dement

Busy(Call)/A

224

9/12/2023 10:54

Bonnie Bleier

Alrt(Call)/A

225

9/12/2023 11:00

Bonnie Bleier

Busy(Call)/A

226

9/12/2023 11:03

Lori Dement

N/A

227

9/12/2023 11:10

Bonnie Bleier

Avail

228

9/12/2023 11:10

Bonnie Bleier

W/U

229

9/12/2023 11:10

Bonnie Bleier

Avail

230

9/12/2023 11:51

David Powers

Avail

231

9/12/2023 11:51

David Powers

W/U

232

9/12/2023 11:51

David Powers

Avail

233

9/12/2023 11:52

Lori Dement

Alrt(Call)/A

234

9/12/2023 11:52

Lori Dement

Busy(Call)/A

235

9/12/2023 11:55

David Powers

Busy(Call)/A

236

9/12/2023 13:00

Bonnie Bleier

Avail

237

9/12/2023 13:00

Bonnie Bleier

W/U

238

9/12/2023 13:00

Bonnie Bleier

Avail

239

9/12/2023 13:00

Jennifer Leibenguth

N/A

240

9/12/2023 13:07

David Powers

Avail

241

9/12/2023 13:07

David Powers

W/U

242

9/12/2023 13:07

David Powers

Avail

243

9/12/2023 13:08

Lori Dement

Alrt(Call)/A

244

9/12/2023 13:09

Bonnie Bleier

Busy(Call)/A

245

9/12/2023 13:11

David Powers

Alrt(Call)/A

246

9/12/2023 13:11

David Powers

Busy(Call)/A

247

9/12/2023 13:14

Lori Dement

Avail

248

9/12/2023 13:16

Bonnie Bleier

Avail

249

9/12/2023 13:16

Lori Dement

N/A

250

9/12/2023 13:19

Lori Dement

Avail

251

9/12/2023 13:20

David Powers

Avail

252

9/12/2023 13:20

David Powers

W/U

253

9/12/2023 13:20

David Powers

Avail

254

9/12/2023 13:25

Lori Dement

Alrt(Call)/A

255

9/12/2023 13:26

Lori Dement

Busy(Call)/A

256

9/12/2023 13:28

Lori Dement

Avail

257

9/12/2023 13:37

David Powers

Avail

258

9/12/2023 13:42

Bonnie Bleier

Alrt(Call)/A

259

9/12/2023 13:42

Bonnie Bleier

Busy(Call)/A

260

9/12/2023 13:45

Lori Dement

N/A

261

9/12/2023 13:46

Bonnie Bleier

Avail

262

9/12/2023 13:46

Bonnie Bleier

W/U

263

9/12/2023 13:58

David Powers

Avail

264

9/12/2023 16:02

David Powers

Avail

265

9/12/2023 16:04

Marianne Peterson

S/Out

266

9/12/2023 16:04

Marianne Peterson

S/Out

267

9/12/2023 16:04

Marianne Peterson

S/Out

268

9/12/2023 16:04

Marianne Peterson

S/Out

269

9/12/2023 16:59

Bonnie Bleier

Avail

270

9/12/2023 16:59

Jennifer Leibenguth

S/Out

271

9/12/2023 16:59

Jennifer Leibenguth

S/Out

272

9/12/2023 16:59

Jennifer Leibenguth

S/Out

273

9/12/2023 16:59

Jennifer Leibenguth

S/Out

274

9/12/2023 17:29

Bonnie Bleier

Avail

275

9/12/2023 17:29

Bonnie Bleier

W/U

276

9/12/2023 17:29

Bonnie Bleier

Avail

277

9/12/2023 17:30

Lori Dement

S/Out

278

9/12/2023 17:32

David Powers

S/Out

279

9/12/2023 17:32

David Powers

S/Out

280

9/12/2023 17:32

David Powers

S/Out

281

9/12/2023 17:32

David Powers

S/Out

282

9/12/2023 17:32

David Powers

S/Out

283

9/12/2023 17:32

David Powers

S/Out

284

9/12/2023 17:45

Bonnie Bleier

Alrt(Call)/A

285

9/12/2023 18:37

Bonnie Bleier

S/Out

TPx Data

Fluff · Sep 29, 2023

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

pitcrew · Sep 29, 2023

Fluff said:
What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Thanks, I will do that. I have both Excel 2014 stand alone as well as Office 365 online Excel, so I can use either one.

Fluff · Sep 29, 2023

pitcrew said:
I have both Excel 2014

There is no 2014. But for 365 try

Fluff.xlsm

A

B

C

D

E

F

G

1

Entry Time

Agent Name

State Chg

S/In

S/Out

2

11/09/2023 09:01

Jennifer Leibenguth

S/In

Jennifer Leibenguth

11/09/2023 09:01

12/09/2023 16:59

3

11/09/2023 09:01

Jennifer Leibenguth

N/A

Bonnie Bleier

12/09/2023 09:01

12/09/2023 18:37

4

11/09/2023 09:01

Jennifer Leibenguth

S/In

Lori Dement

11/09/2023 09:29

12/09/2023 17:30

5

11/09/2023 09:01

Jennifer Leibenguth

S/In

David Powers

11/09/2023 09:53

12/09/2023 17:32

6

11/09/2023 09:01

Jennifer Leibenguth

S/In

Marianne Peterson

#CALC!

12/09/2023 16:04

7

11/09/2023 09:01

Jennifer Leibenguth

S/In

8

11/09/2023 09:01

Jennifer Leibenguth

S/In

9

11/09/2023 09:01

Jennifer Leibenguth

S/In

10

11/09/2023 09:01

Jennifer Leibenguth

Avail

11

11/09/2023 09:01

Jennifer Leibenguth

Alrt(Call)/A

12

11/09/2023 09:01

Jennifer Leibenguth

Busy(Call)/A

13

11/09/2023 09:05

Bonnie Bleier

Busy(Call)/A

14

11/09/2023 09:11

Jennifer Leibenguth

Avail

15

11/09/2023 09:11

Jennifer Leibenguth

W/U

16

11/09/2023 09:11

Jennifer Leibenguth

Avail

17

11/09/2023 09:13

Bonnie Bleier

Avail

18

11/09/2023 09:14

Bonnie Bleier

Avail

19

11/09/2023 09:14

Jennifer Leibenguth

Alrt(Call)/A

20

11/09/2023 09:15

Jennifer Leibenguth

Busy(Call)/A

21

11/09/2023 09:18

Jennifer Leibenguth

Avail

22

11/09/2023 09:29

Lori Dement

S/In

23

11/09/2023 09:29

Lori Dement

N/A

24

11/09/2023 09:29

Lori Dement

S/In

25

11/09/2023 09:29

Lori Dement

S/In

26

11/09/2023 09:29

Lori Dement

S/In

27

11/09/2023 09:29

Lori Dement

S/In

28

11/09/2023 09:29

Lori Dement

S/In

29

11/09/2023 09:52

Bonnie Bleier

Avail

30

11/09/2023 09:53

David Powers

S/In

31

11/09/2023 09:53

David Powers

N/A

32

11/09/2023 09:53

David Powers

S/In

33

11/09/2023 09:53

David Powers

S/In

34

11/09/2023 09:53

David Powers

S/In

35

11/09/2023 09:53

David Powers

S/In

36

11/09/2023 09:53

David Powers

S/In

37

11/09/2023 09:54

Jennifer Leibenguth

N/A

38

11/09/2023 09:57

Bonnie Bleier

Alrt(Call)/A

39

11/09/2023 09:57

Bonnie Bleier

Busy(Call)/A

40

11/09/2023 09:57

Jennifer Leibenguth

Avail

41

11/09/2023 10:00

Bonnie Bleier

Avail

42

11/09/2023 10:00

Bonnie Bleier

W/U

43

11/09/2023 11:37

David Powers

Alrt(Call)/A

44

11/09/2023 11:37

Lori Dement

N/A

45

11/09/2023 11:37

David Powers

Busy(Call)/A

46

11/09/2023 11:45

David Powers

Avail

47

11/09/2023 11:45

David Powers

W/U

48

11/09/2023 11:55

Bonnie Bleier

W/U

49

11/09/2023 11:55

Bonnie Bleier

Avail

50

11/09/2023 15:00

Marianne Peterson

S/Out

51

11/09/2023 15:00

Marianne Peterson

S/Out

52

11/09/2023 15:00

Marianne Peterson

S/Out

53

11/09/2023 15:00

Marianne Peterson

S/Out

54

11/09/2023 15:00

Marianne Peterson

S/Out

55

11/09/2023 15:00

Marianne Peterson

S/Out

56

11/09/2023 15:00

Marianne Peterson

S/Out

57

11/09/2023 15:05

David Powers

N/A

58

11/09/2023 15:06

David Powers

Avail

59

11/09/2023 15:12

Bonnie Bleier

Avail

60

11/09/2023 15:12

Bonnie Bleier

W/U

61

11/09/2023 15:12

Bonnie Bleier

Avail

62

11/09/2023 15:14

Bonnie Bleier

Alrt(Call)/A

63

11/09/2023 15:14

Bonnie Bleier

Busy(Call)/A

64

11/09/2023 15:15

Jennifer Leibenguth

Avail

65

11/09/2023 15:15

Jennifer Leibenguth

W/U

66

11/09/2023 15:15

David Powers

Avail

67

11/09/2023 15:15

David Powers

W/U

68

11/09/2023 15:15

Jennifer Leibenguth

Avail

69

11/09/2023 15:15

David Powers

Avail

70

11/09/2023 15:17

Jennifer Leibenguth

N/A

71

11/09/2023 15:19

Bonnie Bleier

Avail

72

11/09/2023 15:20

Bonnie Bleier

Alrt(Call)/A

73

11/09/2023 15:21

Bonnie Bleier

Busy(Call)/A

74

11/09/2023 15:21

Jennifer Leibenguth

Avail

75

11/09/2023 15:21

Bonnie Bleier

Avail

76

11/09/2023 15:32

Jennifer Leibenguth

N/A

77

11/09/2023 15:32

Lori Dement

Alrt(Call)/A

78

11/09/2023 15:32

Lori Dement

Busy(Call)/A

79

11/09/2023 15:37

Lori Dement

Avail

80

11/09/2023 15:37

Lori Dement

W/U

81

11/09/2023 15:38

Lori Dement

Avail

82

11/09/2023 15:46

Bonnie Bleier

W/U

83

11/09/2023 15:46

Bonnie Bleier

Avail

84

11/09/2023 15:48

Lori Dement

Avail

85

11/09/2023 15:48

Lori Dement

W/U

86

11/09/2023 15:48

Lori Dement

Avail

87

11/09/2023 15:51

Bonnie Bleier

Alrt(Call)/A

88

11/09/2023 15:51

Bonnie Bleier

Busy(Call)/A

89

11/09/2023 15:57

Lori Dement

N/A

90

11/09/2023 15:59

Bonnie Bleier

N/A

91

11/09/2023 16:01

Bonnie Bleier

S/Out

92

11/09/2023 16:01

Bonnie Bleier

S/Out

93

11/09/2023 16:01

Bonnie Bleier

S/Out

94

11/09/2023 16:01

Bonnie Bleier

S/Out

95

11/09/2023 16:01

Bonnie Bleier

S/Out

96

11/09/2023 16:01

Bonnie Bleier

S/Out

97

11/09/2023 16:03

David Powers

Avail

98

11/09/2023 16:07

David Powers

Alrt(Call)/A

99

11/09/2023 16:07

David Powers

Busy(Call)/A

100

11/09/2023 16:10

Jennifer Leibenguth

Avail

101

11/09/2023 16:13

David Powers

Avail

102

11/09/2023 16:13

David Powers

W/U

103

11/09/2023 16:13

David Powers

Avail

104

11/09/2023 16:17

Jennifer Leibenguth

Alrt(Call)/A

105

11/09/2023 16:17

Jennifer Leibenguth

Busy(Call)/A

106

11/09/2023 16:20

David Powers

Alrt(Call)/A

107

11/09/2023 16:20

David Powers

Busy(Call)/A

108

11/09/2023 16:23

Jennifer Leibenguth

Avail

109

11/09/2023 16:23

Jennifer Leibenguth

W/U

110

11/09/2023 16:23

Jennifer Leibenguth

Avail

111

11/09/2023 16:33

Jennifer Leibenguth

Alrt(Call)/A

112

11/09/2023 16:33

Jennifer Leibenguth

Busy(Call)/A

113

11/09/2023 16:34

David Powers

Avail

114

11/09/2023 16:34

David Powers

W/U

115

11/09/2023 16:34

David Powers

Avail

116

11/09/2023 16:36

David Powers

Alrt(Call)/A

117

11/09/2023 16:36

Jennifer Leibenguth

Avail

118

11/09/2023 16:36

Jennifer Leibenguth

W/U

119

11/09/2023 16:36

David Powers

Busy(Call)/A

120

11/09/2023 16:37

Jennifer Leibenguth

Avail

121

11/09/2023 16:42

David Powers

Avail

122

11/09/2023 16:42

David Powers

W/U

123

11/09/2023 16:42

David Powers

Avail

124

11/09/2023 16:46

Lori Dement

Avail

125

11/09/2023 16:52

Lori Dement

Alrt(Call)/A

126

11/09/2023 16:52

Lori Dement

Busy(Call)/A

127

11/09/2023 16:52

David Powers

N/A

128

11/09/2023 16:53

Jennifer Leibenguth

Alrt(Call)/A

129

11/09/2023 16:53

Jennifer Leibenguth

Busy(Call)/A

130

11/09/2023 16:57

David Powers

S/Out

131

11/09/2023 16:57

David Powers

S/Out

132

11/09/2023 16:57

David Powers

S/Out

133

11/09/2023 16:57

David Powers

S/Out

134

11/09/2023 16:57

David Powers

S/Out

135

11/09/2023 16:57

David Powers

S/Out

136

11/09/2023 16:57

Jennifer Leibenguth

Avail

137

11/09/2023 16:57

Jennifer Leibenguth

W/U

138

11/09/2023 17:00

Jennifer Leibenguth

Alrt(Call)/A

139

11/09/2023 17:00

Jennifer Leibenguth

Busy(Call)/A

140

11/09/2023 17:00

Lori Dement

Avail

141

11/09/2023 17:00

Lori Dement

W/U

142

11/09/2023 17:01

Lori Dement

Avail

143

11/09/2023 17:04

Lori Dement

Alrt(Call)/A

144

11/09/2023 17:04

Lori Dement

Busy(Call)/A

145

11/09/2023 17:05

Lori Dement

Avail

146

11/09/2023 17:05

Lori Dement

W/U

147

11/09/2023 17:05

Lori Dement

Avail

148

11/09/2023 17:06

Jennifer Leibenguth

Avail

149

11/09/2023 17:06

Jennifer Leibenguth

W/U

150

11/09/2023 17:24

Lori Dement

Avail

151

11/09/2023 17:25

Lori Dement

Alrt(Call)/A

152

11/09/2023 17:25

Lori Dement

Busy(Call)/A

153

11/09/2023 17:29

Jennifer Leibenguth

S/Out

154

11/09/2023 17:29

Jennifer Leibenguth

S/Out

155

11/09/2023 17:29

Jennifer Leibenguth

S/Out

156

11/09/2023 17:29

Jennifer Leibenguth

S/Out

157

11/09/2023 17:43

Lori Dement

Avail

158

11/09/2023 17:43

Lori Dement

Alrt(Call)/A

159

11/09/2023 17:43

Lori Dement

Busy(Call)/A

160

11/09/2023 17:47

Lori Dement

N/A

161

11/09/2023 17:50

David Powers

S/In

162

11/09/2023 17:50

David Powers

N/A

163

11/09/2023 17:50

David Powers

S/In

164

11/09/2023 17:50

David Powers

S/In

165

11/09/2023 17:51

David Powers

Avail

166

11/09/2023 17:51

David Powers

Alrt(Call)/A

167

11/09/2023 17:51

David Powers

Busy(Call)/A

168

11/09/2023 17:51

Lori Dement

S/Out

169

11/09/2023 17:51

Lori Dement

S/Out

170

11/09/2023 17:51

Lori Dement

S/Out

171

12/09/2023 09:01

Bonnie Bleier

S/In

172

12/09/2023 09:01

Bonnie Bleier

S/In

173

12/09/2023 09:01

Bonnie Bleier

S/In

174

12/09/2023 09:24

David Powers

S/In

175

12/09/2023 09:24

David Powers

N/A

176

12/09/2023 09:24

David Powers

S/In

177

12/09/2023 09:24

David Powers

S/In

178

12/09/2023 09:27

Jennifer Leibenguth

S/In

179

12/09/2023 09:27

Jennifer Leibenguth

N/A

180

12/09/2023 09:27

Jennifer Leibenguth

S/In

181

12/09/2023 09:49

Lori Dement

Busy(Call)/A

182

12/09/2023 09:50

David Powers

Alrt(Call)/A

183

12/09/2023 09:50

David Powers

Busy(Call)/A

184

12/09/2023 09:52

Bonnie Bleier

S/Out

185

12/09/2023 09:52

Bonnie Bleier

S/Out

186

12/09/2023 09:52

Bonnie Bleier

S/Out

187

12/09/2023 09:52

Bonnie Bleier

S/Out

188

12/09/2023 09:52

David Powers

Avail

189

12/09/2023 09:52

David Powers

W/U

190

12/09/2023 09:52

David Powers

Avail

191

12/09/2023 09:53

David Powers

Alrt(Call)/A

192

12/09/2023 09:53

David Powers

Busy(Call)/A

193

12/09/2023 09:53

David Powers

Avail

194

12/09/2023 09:54

Lori Dement

Avail

195

12/09/2023 09:58

David Powers

Alrt(Call)/A

196

12/09/2023 09:58

David Powers

Busy(Call)/A

197

12/09/2023 09:59

David Powers

Avail

198

12/09/2023 09:59

David Powers

W/U

199

12/09/2023 09:59

Lori Dement

Alrt(Call)/A

200

12/09/2023 09:59

Lori Dement

Busy(Call)/A

201

12/09/2023 09:59

David Powers

Avail

202

12/09/2023 09:59

David Powers

Alrt(Call)/A

203

12/09/2023 09:59

David Powers

Busy(Call)/A

204

12/09/2023 10:37

Lori Dement

Avail

205

12/09/2023 10:37

Lori Dement

Alrt(Call)/A

206

12/09/2023 10:37

Lori Dement

Busy(Call)/A

207

12/09/2023 10:41

Bonnie Bleier

S/In

208

12/09/2023 10:41

Bonnie Bleier

S/In

209

12/09/2023 10:41

Bonnie Bleier

Alrt(Call)/A

210

12/09/2023 10:41

Bonnie Bleier

Busy(Call)/A

211

12/09/2023 10:43

Lori Dement

Avail

212

12/09/2023 10:43

Lori Dement

W/U

213

12/09/2023 10:43

Lori Dement

Avail

214

12/09/2023 10:45

Lori Dement

Alrt(Call)/A

215

12/09/2023 10:45

Lori Dement

Busy(Call)/A

216

12/09/2023 10:45

Bonnie Bleier

Avail

217

12/09/2023 10:45

Bonnie Bleier

W/U

218

12/09/2023 10:45

Bonnie Bleier

Avail

219

12/09/2023 10:51

Lori Dement

Avail

220

12/09/2023 10:51

Lori Dement

W/U

221

12/09/2023 10:51

Lori Dement

Avail

222

12/09/2023 10:52

Lori Dement

Alrt(Call)/A

223

12/09/2023 10:52

Lori Dement

Busy(Call)/A

224

12/09/2023 10:54

Bonnie Bleier

Alrt(Call)/A

225

12/09/2023 11:00

Bonnie Bleier

Busy(Call)/A

226

12/09/2023 11:03

Lori Dement

N/A

227

12/09/2023 11:10

Bonnie Bleier

Avail

228

12/09/2023 11:10

Bonnie Bleier

W/U

229

12/09/2023 11:10

Bonnie Bleier

Avail

230

12/09/2023 11:51

David Powers

Avail

231

12/09/2023 11:51

David Powers

W/U

232

12/09/2023 11:51

David Powers

Avail

233

12/09/2023 11:52

Lori Dement

Alrt(Call)/A

234

12/09/2023 11:52

Lori Dement

Busy(Call)/A

235

12/09/2023 11:55

David Powers

Busy(Call)/A

236

12/09/2023 13:00

Bonnie Bleier

Avail

237

12/09/2023 13:00

Bonnie Bleier

W/U

238

12/09/2023 13:00

Bonnie Bleier

Avail

239

12/09/2023 13:00

Jennifer Leibenguth

N/A

240

12/09/2023 13:07

David Powers

Avail

241

12/09/2023 13:07

David Powers

W/U

242

12/09/2023 13:07

David Powers

Avail

243

12/09/2023 13:08

Lori Dement

Alrt(Call)/A

244

12/09/2023 13:09

Bonnie Bleier

Busy(Call)/A

245

12/09/2023 13:11

David Powers

Alrt(Call)/A

246

12/09/2023 13:11

David Powers

Busy(Call)/A

247

12/09/2023 13:14

Lori Dement

Avail

248

12/09/2023 13:16

Bonnie Bleier

Avail

249

12/09/2023 13:16

Lori Dement

N/A

250

12/09/2023 13:19

Lori Dement

Avail

251

12/09/2023 13:20

David Powers

Avail

252

12/09/2023 13:20

David Powers

W/U

253

12/09/2023 13:20

David Powers

Avail

254

12/09/2023 13:25

Lori Dement

Alrt(Call)/A

255

12/09/2023 13:26

Lori Dement

Busy(Call)/A

256

12/09/2023 13:28

Lori Dement

Avail

257

12/09/2023 13:37

David Powers

Avail

258

12/09/2023 13:42

Bonnie Bleier

Alrt(Call)/A

259

12/09/2023 13:42

Bonnie Bleier

Busy(Call)/A

260

12/09/2023 13:45

Lori Dement

N/A

261

12/09/2023 13:46

Bonnie Bleier

Avail

262

12/09/2023 13:46

Bonnie Bleier

W/U

263

12/09/2023 13:58

David Powers

Avail

264

12/09/2023 16:02

David Powers

Avail

265

12/09/2023 16:04

Marianne Peterson

S/Out

266

12/09/2023 16:04

Marianne Peterson

S/Out

267

12/09/2023 16:04

Marianne Peterson

S/Out

268

12/09/2023 16:04

Marianne Peterson

S/Out

269

12/09/2023 16:59

Bonnie Bleier

Avail

270

12/09/2023 16:59

Jennifer Leibenguth

S/Out

271

12/09/2023 16:59

Jennifer Leibenguth

S/Out

272

12/09/2023 16:59

Jennifer Leibenguth

S/Out

273

12/09/2023 16:59

Jennifer Leibenguth

S/Out

274

12/09/2023 17:29

Bonnie Bleier

Avail

275

12/09/2023 17:29

Bonnie Bleier

W/U

276

12/09/2023 17:29

Bonnie Bleier

Avail

277

12/09/2023 17:30

Lori Dement

S/Out

278

12/09/2023 17:32

David Powers

S/Out

279

12/09/2023 17:32

David Powers

S/Out

280

12/09/2023 17:32

David Powers

S/Out

281

12/09/2023 17:32

David Powers

S/Out

282

12/09/2023 17:32

David Powers

S/Out

283

12/09/2023 17:32

David Powers

S/Out

284

12/09/2023 17:45

Bonnie Bleier

Alrt(Call)/A

285

12/09/2023 18:37

Bonnie Bleier

S/Out

Sheet6

Cell Formulas
Range	Formula
E2:E6	E2	=UNIQUE(B2:B285)
F2:F6	F2	=TAKE(FILTER($A$2:$A$400,($B$2:$B$400=$E2)*($C$2:$C$400=F$1)),1)
G2:G6	G2	=TAKE(FILTER($A$2:$A$400,($B$2:$B$400=$E2)*($C$2:$C$400=G$1)),-1)
Dynamic array formulas.

pitcrew · Sep 29, 2023

Fluff said:
There is no 2014. But for 365 try

Fluff.xlsm
A B C D E F G
1 Entry Time Agent Name State Chg S/In S/Out
2 11/09/2023 09:01 Jennifer Leibenguth S/In Jennifer Leibenguth 11/09/2023 09:01 12/09/2023 16:59
3 11/09/2023 09:01 Jennifer Leibenguth N/A Bonnie Bleier 12/09/2023 09:01 12/09/2023 18:37
4 11/09/2023 09:01 Jennifer Leibenguth S/In Lori Dement 11/09/2023 09:29 12/09/2023 17:30
5 11/09/2023 09:01 Jennifer Leibenguth S/In David Powers 11/09/2023 09:53 12/09/2023 17:32
6 11/09/2023 09:01 Jennifer Leibenguth S/In Marianne Peterson #CALC! 12/09/2023 16:04
7 11/09/2023 09:01 Jennifer Leibenguth S/In
8 11/09/2023 09:01 Jennifer Leibenguth S/In
9 11/09/2023 09:01 Jennifer Leibenguth S/In
10 11/09/2023 09:01 Jennifer Leibenguth Avail
11 11/09/2023 09:01 Jennifer Leibenguth Alrt(Call)/A
12 11/09/2023 09:01 Jennifer Leibenguth Busy(Call)/A
13 11/09/2023 09:05 Bonnie Bleier Busy(Call)/A
14 11/09/2023 09:11 Jennifer Leibenguth Avail
15 11/09/2023 09:11 Jennifer Leibenguth W/U
16 11/09/2023 09:11 Jennifer Leibenguth Avail
17 11/09/2023 09:13 Bonnie Bleier Avail
18 11/09/2023 09:14 Bonnie Bleier Avail
19 11/09/2023 09:14 Jennifer Leibenguth Alrt(Call)/A
20 11/09/2023 09:15 Jennifer Leibenguth Busy(Call)/A
21 11/09/2023 09:18 Jennifer Leibenguth Avail
22 11/09/2023 09:29 Lori Dement S/In
23 11/09/2023 09:29 Lori Dement N/A
24 11/09/2023 09:29 Lori Dement S/In
25 11/09/2023 09:29 Lori Dement S/In
26 11/09/2023 09:29 Lori Dement S/In
27 11/09/2023 09:29 Lori Dement S/In
28 11/09/2023 09:29 Lori Dement S/In
29 11/09/2023 09:52 Bonnie Bleier Avail
30 11/09/2023 09:53 David Powers S/In
31 11/09/2023 09:53 David Powers N/A
32 11/09/2023 09:53 David Powers S/In
33 11/09/2023 09:53 David Powers S/In
34 11/09/2023 09:53 David Powers S/In
35 11/09/2023 09:53 David Powers S/In
36 11/09/2023 09:53 David Powers S/In
37 11/09/2023 09:54 Jennifer Leibenguth N/A
38 11/09/2023 09:57 Bonnie Bleier Alrt(Call)/A
39 11/09/2023 09:57 Bonnie Bleier Busy(Call)/A
40 11/09/2023 09:57 Jennifer Leibenguth Avail
41 11/09/2023 10:00 Bonnie Bleier Avail
42 11/09/2023 10:00 Bonnie Bleier W/U
43 11/09/2023 11:37 David Powers Alrt(Call)/A
44 11/09/2023 11:37 Lori Dement N/A
45 11/09/2023 11:37 David Powers Busy(Call)/A
46 11/09/2023 11:45 David Powers Avail
47 11/09/2023 11:45 David Powers W/U
48 11/09/2023 11:55 Bonnie Bleier W/U
49 11/09/2023 11:55 Bonnie Bleier Avail
50 11/09/2023 15:00 Marianne Peterson S/Out
51 11/09/2023 15:00 Marianne Peterson S/Out
52 11/09/2023 15:00 Marianne Peterson S/Out
53 11/09/2023 15:00 Marianne Peterson S/Out
54 11/09/2023 15:00 Marianne Peterson S/Out
55 11/09/2023 15:00 Marianne Peterson S/Out
56 11/09/2023 15:00 Marianne Peterson S/Out
57 11/09/2023 15:05 David Powers N/A
58 11/09/2023 15:06 David Powers Avail
59 11/09/2023 15:12 Bonnie Bleier Avail
60 11/09/2023 15:12 Bonnie Bleier W/U
61 11/09/2023 15:12 Bonnie Bleier Avail
62 11/09/2023 15:14 Bonnie Bleier Alrt(Call)/A
63 11/09/2023 15:14 Bonnie Bleier Busy(Call)/A
64 11/09/2023 15:15 Jennifer Leibenguth Avail
65 11/09/2023 15:15 Jennifer Leibenguth W/U
66 11/09/2023 15:15 David Powers Avail
67 11/09/2023 15:15 David Powers W/U
68 11/09/2023 15:15 Jennifer Leibenguth Avail
69 11/09/2023 15:15 David Powers Avail
70 11/09/2023 15:17 Jennifer Leibenguth N/A
71 11/09/2023 15:19 Bonnie Bleier Avail
72 11/09/2023 15:20 Bonnie Bleier Alrt(Call)/A
73 11/09/2023 15:21 Bonnie Bleier Busy(Call)/A
74 11/09/2023 15:21 Jennifer Leibenguth Avail
75 11/09/2023 15:21 Bonnie Bleier Avail
76 11/09/2023 15:32 Jennifer Leibenguth N/A
77 11/09/2023 15:32 Lori Dement Alrt(Call)/A
78 11/09/2023 15:32 Lori Dement Busy(Call)/A
79 11/09/2023 15:37 Lori Dement Avail
80 11/09/2023 15:37 Lori Dement W/U
81 11/09/2023 15:38 Lori Dement Avail
82 11/09/2023 15:46 Bonnie Bleier W/U
83 11/09/2023 15:46 Bonnie Bleier Avail
84 11/09/2023 15:48 Lori Dement Avail
85 11/09/2023 15:48 Lori Dement W/U
86 11/09/2023 15:48 Lori Dement Avail
87 11/09/2023 15:51 Bonnie Bleier Alrt(Call)/A
88 11/09/2023 15:51 Bonnie Bleier Busy(Call)/A
89 11/09/2023 15:57 Lori Dement N/A
90 11/09/2023 15:59 Bonnie Bleier N/A
91 11/09/2023 16:01 Bonnie Bleier S/Out
92 11/09/2023 16:01 Bonnie Bleier S/Out
93 11/09/2023 16:01 Bonnie Bleier S/Out
94 11/09/2023 16:01 Bonnie Bleier S/Out
95 11/09/2023 16:01 Bonnie Bleier S/Out
96 11/09/2023 16:01 Bonnie Bleier S/Out
97 11/09/2023 16:03 David Powers Avail
98 11/09/2023 16:07 David Powers Alrt(Call)/A
99 11/09/2023 16:07 David Powers Busy(Call)/A
100 11/09/2023 16:10 Jennifer Leibenguth Avail
101 11/09/2023 16:13 David Powers Avail
102 11/09/2023 16:13 David Powers W/U
103 11/09/2023 16:13 David Powers Avail
104 11/09/2023 16:17 Jennifer Leibenguth Alrt(Call)/A
105 11/09/2023 16:17 Jennifer Leibenguth Busy(Call)/A
106 11/09/2023 16:20 David Powers Alrt(Call)/A
107 11/09/2023 16:20 David Powers Busy(Call)/A
108 11/09/2023 16:23 Jennifer Leibenguth Avail
109 11/09/2023 16:23 Jennifer Leibenguth W/U
110 11/09/2023 16:23 Jennifer Leibenguth Avail
111 11/09/2023 16:33 Jennifer Leibenguth Alrt(Call)/A
112 11/09/2023 16:33 Jennifer Leibenguth Busy(Call)/A
113 11/09/2023 16:34 David Powers Avail
114 11/09/2023 16:34 David Powers W/U
115 11/09/2023 16:34 David Powers Avail
116 11/09/2023 16:36 David Powers Alrt(Call)/A
117 11/09/2023 16:36 Jennifer Leibenguth Avail
118 11/09/2023 16:36 Jennifer Leibenguth W/U
119 11/09/2023 16:36 David Powers Busy(Call)/A
120 11/09/2023 16:37 Jennifer Leibenguth Avail
121 11/09/2023 16:42 David Powers Avail
122 11/09/2023 16:42 David Powers W/U
123 11/09/2023 16:42 David Powers Avail
124 11/09/2023 16:46 Lori Dement Avail
125 11/09/2023 16:52 Lori Dement Alrt(Call)/A
126 11/09/2023 16:52 Lori Dement Busy(Call)/A
127 11/09/2023 16:52 David Powers N/A
128 11/09/2023 16:53 Jennifer Leibenguth Alrt(Call)/A
129 11/09/2023 16:53 Jennifer Leibenguth Busy(Call)/A
130 11/09/2023 16:57 David Powers S/Out
131 11/09/2023 16:57 David Powers S/Out
132 11/09/2023 16:57 David Powers S/Out
133 11/09/2023 16:57 David Powers S/Out
134 11/09/2023 16:57 David Powers S/Out
135 11/09/2023 16:57 David Powers S/Out
136 11/09/2023 16:57 Jennifer Leibenguth Avail
137 11/09/2023 16:57 Jennifer Leibenguth W/U
138 11/09/2023 17:00 Jennifer Leibenguth Alrt(Call)/A
139 11/09/2023 17:00 Jennifer Leibenguth Busy(Call)/A
140 11/09/2023 17:00 Lori Dement Avail
141 11/09/2023 17:00 Lori Dement W/U
142 11/09/2023 17:01 Lori Dement Avail
143 11/09/2023 17:04 Lori Dement Alrt(Call)/A
144 11/09/2023 17:04 Lori Dement Busy(Call)/A
145 11/09/2023 17:05 Lori Dement Avail
146 11/09/2023 17:05 Lori Dement W/U
147 11/09/2023 17:05 Lori Dement Avail
148 11/09/2023 17:06 Jennifer Leibenguth Avail
149 11/09/2023 17:06 Jennifer Leibenguth W/U
150 11/09/2023 17:24 Lori Dement Avail
151 11/09/2023 17:25 Lori Dement Alrt(Call)/A
152 11/09/2023 17:25 Lori Dement Busy(Call)/A
153 11/09/2023 17:29 Jennifer Leibenguth S/Out
154 11/09/2023 17:29 Jennifer Leibenguth S/Out
155 11/09/2023 17:29 Jennifer Leibenguth S/Out
156 11/09/2023 17:29 Jennifer Leibenguth S/Out
157 11/09/2023 17:43 Lori Dement Avail
158 11/09/2023 17:43 Lori Dement Alrt(Call)/A
159 11/09/2023 17:43 Lori Dement Busy(Call)/A
160 11/09/2023 17:47 Lori Dement N/A
161 11/09/2023 17:50 David Powers S/In
162 11/09/2023 17:50 David Powers N/A
163 11/09/2023 17:50 David Powers S/In
164 11/09/2023 17:50 David Powers S/In
165 11/09/2023 17:51 David Powers Avail
166 11/09/2023 17:51 David Powers Alrt(Call)/A
167 11/09/2023 17:51 David Powers Busy(Call)/A
168 11/09/2023 17:51 Lori Dement S/Out
169 11/09/2023 17:51 Lori Dement S/Out
170 11/09/2023 17:51 Lori Dement S/Out
171 12/09/2023 09:01 Bonnie Bleier S/In
172 12/09/2023 09:01 Bonnie Bleier S/In
173 12/09/2023 09:01 Bonnie Bleier S/In
174 12/09/2023 09:24 David Powers S/In
175 12/09/2023 09:24 David Powers N/A
176 12/09/2023 09:24 David Powers S/In
177 12/09/2023 09:24 David Powers S/In
178 12/09/2023 09:27 Jennifer Leibenguth S/In
179 12/09/2023 09:27 Jennifer Leibenguth N/A
180 12/09/2023 09:27 Jennifer Leibenguth S/In
181 12/09/2023 09:49 Lori Dement Busy(Call)/A
182 12/09/2023 09:50 David Powers Alrt(Call)/A
183 12/09/2023 09:50 David Powers Busy(Call)/A
184 12/09/2023 09:52 Bonnie Bleier S/Out
185 12/09/2023 09:52 Bonnie Bleier S/Out
186 12/09/2023 09:52 Bonnie Bleier S/Out
187 12/09/2023 09:52 Bonnie Bleier S/Out
188 12/09/2023 09:52 David Powers Avail
189 12/09/2023 09:52 David Powers W/U
190 12/09/2023 09:52 David Powers Avail
191 12/09/2023 09:53 David Powers Alrt(Call)/A
192 12/09/2023 09:53 David Powers Busy(Call)/A
193 12/09/2023 09:53 David Powers Avail
194 12/09/2023 09:54 Lori Dement Avail
195 12/09/2023 09:58 David Powers Alrt(Call)/A
196 12/09/2023 09:58 David Powers Busy(Call)/A
197 12/09/2023 09:59 David Powers Avail
198 12/09/2023 09:59 David Powers W/U
199 12/09/2023 09:59 Lori Dement Alrt(Call)/A
200 12/09/2023 09:59 Lori Dement Busy(Call)/A
201 12/09/2023 09:59 David Powers Avail
202 12/09/2023 09:59 David Powers Alrt(Call)/A
203 12/09/2023 09:59 David Powers Busy(Call)/A
204 12/09/2023 10:37 Lori Dement Avail
205 12/09/2023 10:37 Lori Dement Alrt(Call)/A
206 12/09/2023 10:37 Lori Dement Busy(Call)/A
207 12/09/2023 10:41 Bonnie Bleier S/In
208 12/09/2023 10:41 Bonnie Bleier S/In
209 12/09/2023 10:41 Bonnie Bleier Alrt(Call)/A
210 12/09/2023 10:41 Bonnie Bleier Busy(Call)/A
211 12/09/2023 10:43 Lori Dement Avail
212 12/09/2023 10:43 Lori Dement W/U
213 12/09/2023 10:43 Lori Dement Avail
214 12/09/2023 10:45 Lori Dement Alrt(Call)/A
215 12/09/2023 10:45 Lori Dement Busy(Call)/A
216 12/09/2023 10:45 Bonnie Bleier Avail
217 12/09/2023 10:45 Bonnie Bleier W/U
218 12/09/2023 10:45 Bonnie Bleier Avail
219 12/09/2023 10:51 Lori Dement Avail
220 12/09/2023 10:51 Lori Dement W/U
221 12/09/2023 10:51 Lori Dement Avail
222 12/09/2023 10:52 Lori Dement Alrt(Call)/A
223 12/09/2023 10:52 Lori Dement Busy(Call)/A
224 12/09/2023 10:54 Bonnie Bleier Alrt(Call)/A
225 12/09/2023 11:00 Bonnie Bleier Busy(Call)/A
226 12/09/2023 11:03 Lori Dement N/A
227 12/09/2023 11:10 Bonnie Bleier Avail
228 12/09/2023 11:10 Bonnie Bleier W/U
229 12/09/2023 11:10 Bonnie Bleier Avail
230 12/09/2023 11:51 David Powers Avail
231 12/09/2023 11:51 David Powers W/U
232 12/09/2023 11:51 David Powers Avail
233 12/09/2023 11:52 Lori Dement Alrt(Call)/A
234 12/09/2023 11:52 Lori Dement Busy(Call)/A
235 12/09/2023 11:55 David Powers Busy(Call)/A
236 12/09/2023 13:00 Bonnie Bleier Avail
237 12/09/2023 13:00 Bonnie Bleier W/U
238 12/09/2023 13:00 Bonnie Bleier Avail
239 12/09/2023 13:00 Jennifer Leibenguth N/A
240 12/09/2023 13:07 David Powers Avail
241 12/09/2023 13:07 David Powers W/U
242 12/09/2023 13:07 David Powers Avail
243 12/09/2023 13:08 Lori Dement Alrt(Call)/A
244 12/09/2023 13:09 Bonnie Bleier Busy(Call)/A
245 12/09/2023 13:11 David Powers Alrt(Call)/A
246 12/09/2023 13:11 David Powers Busy(Call)/A
247 12/09/2023 13:14 Lori Dement Avail
248 12/09/2023 13:16 Bonnie Bleier Avail
249 12/09/2023 13:16 Lori Dement N/A
250 12/09/2023 13:19 Lori Dement Avail
251 12/09/2023 13:20 David Powers Avail
252 12/09/2023 13:20 David Powers W/U
253 12/09/2023 13:20 David Powers Avail
254 12/09/2023 13:25 Lori Dement Alrt(Call)/A
255 12/09/2023 13:26 Lori Dement Busy(Call)/A
256 12/09/2023 13:28 Lori Dement Avail
257 12/09/2023 13:37 David Powers Avail
258 12/09/2023 13:42 Bonnie Bleier Alrt(Call)/A
259 12/09/2023 13:42 Bonnie Bleier Busy(Call)/A
260 12/09/2023 13:45 Lori Dement N/A
261 12/09/2023 13:46 Bonnie Bleier Avail
262 12/09/2023 13:46 Bonnie Bleier W/U
263 12/09/2023 13:58 David Powers Avail
264 12/09/2023 16:02 David Powers Avail
265 12/09/2023 16:04 Marianne Peterson S/Out
266 12/09/2023 16:04 Marianne Peterson S/Out
267 12/09/2023 16:04 Marianne Peterson S/Out
268 12/09/2023 16:04 Marianne Peterson S/Out
269 12/09/2023 16:59 Bonnie Bleier Avail
270 12/09/2023 16:59 Jennifer Leibenguth S/Out
271 12/09/2023 16:59 Jennifer Leibenguth S/Out
272 12/09/2023 16:59 Jennifer Leibenguth S/Out
273 12/09/2023 16:59 Jennifer Leibenguth S/Out
274 12/09/2023 17:29 Bonnie Bleier Avail
275 12/09/2023 17:29 Bonnie Bleier W/U
276 12/09/2023 17:29 Bonnie Bleier Avail
277 12/09/2023 17:30 Lori Dement S/Out
278 12/09/2023 17:32 David Powers S/Out
279 12/09/2023 17:32 David Powers S/Out
280 12/09/2023 17:32 David Powers S/Out
281 12/09/2023 17:32 David Powers S/Out
282 12/09/2023 17:32 David Powers S/Out
283 12/09/2023 17:32 David Powers S/Out
284 12/09/2023 17:45 Bonnie Bleier Alrt(Call)/A
285 12/09/2023 18:37 Bonnie Bleier S/Out
Sheet6
Cell Formulas
Range Formula
E2:E6 E2 =UNIQUE(B2:B285)
F2:F6 F2 =TAKE(FILTER($A$2:$A$400,($B$2:$B$400=$E2)*($C$2:$C$400=F$1)),1)
G2:G6 G2 =TAKE(FILTER($A$2:$A$400,($B$2:$B$400=$E2)*($C$2:$C$400=G$1)),-1)
Dynamic array formulas.

The only problem with this is that it is not showing the earliest login and latest logout for each individual day. For example, I need to know What Time Jennifer signed-in to start her day on 9/11/23 and what time she last signed-out on that same day. Then I need that information for the next day and so on for the week. Same for every other employee.

Fluff · Sep 29, 2023

Missed that part, try

Fluff.xlsm

A

B

C

D

E

F

G

H

1

Entry Time

Agent Name

State Chg

S/In

S/Out

2

11/09/2023 09:01

Jennifer Leibenguth

S/In

11/09/2023

Jennifer Leibenguth

11/09/2023 09:01

11/09/2023 17:29

3

11/09/2023 09:01

Jennifer Leibenguth

N/A

11/09/2023

Bonnie Bleier

#CALC!

11/09/2023 16:01

4

11/09/2023 09:01

Jennifer Leibenguth

S/In

11/09/2023

Lori Dement

11/09/2023 09:29

11/09/2023 17:51

5

11/09/2023 09:01

Jennifer Leibenguth

S/In

11/09/2023

David Powers

11/09/2023 09:53

11/09/2023 16:57

6

11/09/2023 09:01

Jennifer Leibenguth

S/In

11/09/2023

Marianne Peterson

#CALC!

11/09/2023 15:00

7

11/09/2023 09:01

Jennifer Leibenguth

S/In

12/09/2023

Bonnie Bleier

12/09/2023 09:01

12/09/2023 09:52

8

11/09/2023 09:01

Jennifer Leibenguth

S/In

12/09/2023

David Powers

12/09/2023 09:24

12/09/2023 17:32

9

11/09/2023 09:01

Jennifer Leibenguth

S/In

12/09/2023

Jennifer Leibenguth

12/09/2023 09:27

12/09/2023 16:59

10

11/09/2023 09:01

Jennifer Leibenguth

Avail

12/09/2023

Lori Dement

#CALC!

12/09/2023 17:30

11

11/09/2023 09:01

Jennifer Leibenguth

Alrt(Call)/A

12/09/2023

Marianne Peterson

#CALC!

12/09/2023 16:04

12

11/09/2023 09:01

Jennifer Leibenguth

Busy(Call)/A

13

11/09/2023 09:05

Bonnie Bleier

Busy(Call)/A

14

11/09/2023 09:11

Jennifer Leibenguth

Avail

15

11/09/2023 09:11

Jennifer Leibenguth

W/U

16

11/09/2023 09:11

Jennifer Leibenguth

Avail

17

11/09/2023 09:13

Bonnie Bleier

Avail

18

11/09/2023 09:14

Bonnie Bleier

Avail

19

11/09/2023 09:14

Jennifer Leibenguth

Alrt(Call)/A

20

11/09/2023 09:15

Jennifer Leibenguth

Busy(Call)/A

21

11/09/2023 09:18

Jennifer Leibenguth

Avail

22

11/09/2023 09:29

Lori Dement

S/In

23

11/09/2023 09:29

Lori Dement

N/A

24

11/09/2023 09:29

Lori Dement

S/In

25

11/09/2023 09:29

Lori Dement

S/In

26

11/09/2023 09:29

Lori Dement

S/In

27

11/09/2023 09:29

Lori Dement

S/In

28

11/09/2023 09:29

Lori Dement

S/In

29

11/09/2023 09:52

Bonnie Bleier

Avail

30

11/09/2023 09:53

David Powers

S/In

31

11/09/2023 09:53

David Powers

N/A

32

11/09/2023 09:53

David Powers

S/In

33

11/09/2023 09:53

David Powers

S/In

34

11/09/2023 09:53

David Powers

S/In

35

11/09/2023 09:53

David Powers

S/In

36

11/09/2023 09:53

David Powers

S/In

37

11/09/2023 09:54

Jennifer Leibenguth

N/A

38

11/09/2023 09:57

Bonnie Bleier

Alrt(Call)/A

39

11/09/2023 09:57

Bonnie Bleier

Busy(Call)/A

40

11/09/2023 09:57

Jennifer Leibenguth

Avail

41

11/09/2023 10:00

Bonnie Bleier

Avail

42

11/09/2023 10:00

Bonnie Bleier

W/U

43

11/09/2023 11:37

David Powers

Alrt(Call)/A

44

11/09/2023 11:37

Lori Dement

N/A

45

11/09/2023 11:37

David Powers

Busy(Call)/A

46

11/09/2023 11:45

David Powers

Avail

47

11/09/2023 11:45

David Powers

W/U

48

11/09/2023 11:55

Bonnie Bleier

W/U

49

11/09/2023 11:55

Bonnie Bleier

Avail

50

11/09/2023 15:00

Marianne Peterson

S/Out

51

11/09/2023 15:00

Marianne Peterson

S/Out

52

11/09/2023 15:00

Marianne Peterson

S/Out

53

11/09/2023 15:00

Marianne Peterson

S/Out

54

11/09/2023 15:00

Marianne Peterson

S/Out

55

11/09/2023 15:00

Marianne Peterson

S/Out

56

11/09/2023 15:00

Marianne Peterson

S/Out

57

11/09/2023 15:05

David Powers

N/A

58

11/09/2023 15:06

David Powers

Avail

59

11/09/2023 15:12

Bonnie Bleier

Avail

60

11/09/2023 15:12

Bonnie Bleier

W/U

61

11/09/2023 15:12

Bonnie Bleier

Avail

62

11/09/2023 15:14

Bonnie Bleier

Alrt(Call)/A

63

11/09/2023 15:14

Bonnie Bleier

Busy(Call)/A

64

11/09/2023 15:15

Jennifer Leibenguth

Avail

65

11/09/2023 15:15

Jennifer Leibenguth

W/U

66

11/09/2023 15:15

David Powers

Avail

67

11/09/2023 15:15

David Powers

W/U

68

11/09/2023 15:15

Jennifer Leibenguth

Avail

69

11/09/2023 15:15

David Powers

Avail

70

11/09/2023 15:17

Jennifer Leibenguth

N/A

71

11/09/2023 15:19

Bonnie Bleier

Avail

72

11/09/2023 15:20

Bonnie Bleier

Alrt(Call)/A

73

11/09/2023 15:21

Bonnie Bleier

Busy(Call)/A

74

11/09/2023 15:21

Jennifer Leibenguth

Avail

75

11/09/2023 15:21

Bonnie Bleier

Avail

76

11/09/2023 15:32

Jennifer Leibenguth

N/A

77

11/09/2023 15:32

Lori Dement

Alrt(Call)/A

78

11/09/2023 15:32

Lori Dement

Busy(Call)/A

79

11/09/2023 15:37

Lori Dement

Avail

80

11/09/2023 15:37

Lori Dement

W/U

81

11/09/2023 15:38

Lori Dement

Avail

82

11/09/2023 15:46

Bonnie Bleier

W/U

83

11/09/2023 15:46

Bonnie Bleier

Avail

84

11/09/2023 15:48

Lori Dement

Avail

85

11/09/2023 15:48

Lori Dement

W/U

86

11/09/2023 15:48

Lori Dement

Avail

87

11/09/2023 15:51

Bonnie Bleier

Alrt(Call)/A

88

11/09/2023 15:51

Bonnie Bleier

Busy(Call)/A

89

11/09/2023 15:57

Lori Dement

N/A

90

11/09/2023 15:59

Bonnie Bleier

N/A

91

11/09/2023 16:01

Bonnie Bleier

S/Out

92

11/09/2023 16:01

Bonnie Bleier

S/Out

93

11/09/2023 16:01

Bonnie Bleier

S/Out

94

11/09/2023 16:01

Bonnie Bleier

S/Out

95

11/09/2023 16:01

Bonnie Bleier

S/Out

96

11/09/2023 16:01

Bonnie Bleier

S/Out

97

11/09/2023 16:03

David Powers

Avail

98

11/09/2023 16:07

David Powers

Alrt(Call)/A

99

11/09/2023 16:07

David Powers

Busy(Call)/A

100

11/09/2023 16:10

Jennifer Leibenguth

Avail

101

11/09/2023 16:13

David Powers

Avail

102

11/09/2023 16:13

David Powers

W/U

103

11/09/2023 16:13

David Powers

Avail

104

11/09/2023 16:17

Jennifer Leibenguth

Alrt(Call)/A

105

11/09/2023 16:17

Jennifer Leibenguth

Busy(Call)/A

106

11/09/2023 16:20

David Powers

Alrt(Call)/A

107

11/09/2023 16:20

David Powers

Busy(Call)/A

108

11/09/2023 16:23

Jennifer Leibenguth

Avail

109

11/09/2023 16:23

Jennifer Leibenguth

W/U

110

11/09/2023 16:23

Jennifer Leibenguth

Avail

111

11/09/2023 16:33

Jennifer Leibenguth

Alrt(Call)/A

112

11/09/2023 16:33

Jennifer Leibenguth

Busy(Call)/A

113

11/09/2023 16:34

David Powers

Avail

114

11/09/2023 16:34

David Powers

W/U

115

11/09/2023 16:34

David Powers

Avail

116

11/09/2023 16:36

David Powers

Alrt(Call)/A

117

11/09/2023 16:36

Jennifer Leibenguth

Avail

118

11/09/2023 16:36

Jennifer Leibenguth

W/U

119

11/09/2023 16:36

David Powers

Busy(Call)/A

120

11/09/2023 16:37

Jennifer Leibenguth

Avail

121

11/09/2023 16:42

David Powers

Avail

122

11/09/2023 16:42

David Powers

W/U

123

11/09/2023 16:42

David Powers

Avail

124

11/09/2023 16:46

Lori Dement

Avail

125

11/09/2023 16:52

Lori Dement

Alrt(Call)/A

126

11/09/2023 16:52

Lori Dement

Busy(Call)/A

127

11/09/2023 16:52

David Powers

N/A

128

11/09/2023 16:53

Jennifer Leibenguth

Alrt(Call)/A

129

11/09/2023 16:53

Jennifer Leibenguth

Busy(Call)/A

130

11/09/2023 16:57

David Powers

S/Out

131

11/09/2023 16:57

David Powers

S/Out

132

11/09/2023 16:57

David Powers

S/Out

133

11/09/2023 16:57

David Powers

S/Out

134

11/09/2023 16:57

David Powers

S/Out

135

11/09/2023 16:57

David Powers

S/Out

136

11/09/2023 16:57

Jennifer Leibenguth

Avail

137

11/09/2023 16:57

Jennifer Leibenguth

W/U

138

11/09/2023 17:00

Jennifer Leibenguth

Alrt(Call)/A

139

11/09/2023 17:00

Jennifer Leibenguth

Busy(Call)/A

140

11/09/2023 17:00

Lori Dement

Avail

141

11/09/2023 17:00

Lori Dement

W/U

142

11/09/2023 17:01

Lori Dement

Avail

143

11/09/2023 17:04

Lori Dement

Alrt(Call)/A

144

11/09/2023 17:04

Lori Dement

Busy(Call)/A

145

11/09/2023 17:05

Lori Dement

Avail

146

11/09/2023 17:05

Lori Dement

W/U

147

11/09/2023 17:05

Lori Dement

Avail

148

11/09/2023 17:06

Jennifer Leibenguth

Avail

149

11/09/2023 17:06

Jennifer Leibenguth

W/U

150

11/09/2023 17:24

Lori Dement

Avail

151

11/09/2023 17:25

Lori Dement

Alrt(Call)/A

152

11/09/2023 17:25

Lori Dement

Busy(Call)/A

153

11/09/2023 17:29

Jennifer Leibenguth

S/Out

154

11/09/2023 17:29

Jennifer Leibenguth

S/Out

155

11/09/2023 17:29

Jennifer Leibenguth

S/Out

156

11/09/2023 17:29

Jennifer Leibenguth

S/Out

157

11/09/2023 17:43

Lori Dement

Avail

158

11/09/2023 17:43

Lori Dement

Alrt(Call)/A

159

11/09/2023 17:43

Lori Dement

Busy(Call)/A

160

11/09/2023 17:47

Lori Dement

N/A

161

11/09/2023 17:50

David Powers

S/In

162

11/09/2023 17:50

David Powers

N/A

163

11/09/2023 17:50

David Powers

S/In

164

11/09/2023 17:50

David Powers

S/In

165

11/09/2023 17:51

David Powers

Avail

166

11/09/2023 17:51

David Powers

Alrt(Call)/A

167

11/09/2023 17:51

David Powers

Busy(Call)/A

168

11/09/2023 17:51

Lori Dement

S/Out

169

11/09/2023 17:51

Lori Dement

S/Out

170

11/09/2023 17:51

Lori Dement

S/Out

171

12/09/2023 09:01

Bonnie Bleier

S/In

172

12/09/2023 09:01

Bonnie Bleier

S/In

173

12/09/2023 09:01

Bonnie Bleier

S/In

174

12/09/2023 09:24

David Powers

S/In

175

12/09/2023 09:24

David Powers

N/A

176

12/09/2023 09:24

David Powers

S/In

177

12/09/2023 09:24

David Powers

S/In

178

12/09/2023 09:27

Jennifer Leibenguth

S/In

179

12/09/2023 09:27

Jennifer Leibenguth

N/A

180

12/09/2023 09:27

Jennifer Leibenguth

S/In

181

12/09/2023 09:49

Lori Dement

Busy(Call)/A

182

12/09/2023 09:50

David Powers

Alrt(Call)/A

183

12/09/2023 09:50

David Powers

Busy(Call)/A

184

12/09/2023 09:52

Bonnie Bleier

S/Out

185

12/09/2023 09:52

Bonnie Bleier

S/Out

186

12/09/2023 09:52

Bonnie Bleier

S/Out

187

12/09/2023 09:52

Bonnie Bleier

S/Out

188

12/09/2023 09:52

David Powers

Avail

189

12/09/2023 09:52

David Powers

W/U

190

12/09/2023 09:52

David Powers

Avail

191

12/09/2023 09:53

David Powers

Alrt(Call)/A

192

12/09/2023 09:53

David Powers

Busy(Call)/A

193

12/09/2023 09:53

David Powers

Avail

194

12/09/2023 09:54

Lori Dement

Avail

195

12/09/2023 09:58

David Powers

Alrt(Call)/A

196

12/09/2023 09:58

David Powers

Busy(Call)/A

197

12/09/2023 09:59

David Powers

Avail

198

12/09/2023 09:59

David Powers

W/U

199

12/09/2023 09:59

Lori Dement

Alrt(Call)/A

200

12/09/2023 09:59

Lori Dement

Busy(Call)/A

201

12/09/2023 09:59

David Powers

Avail

202

12/09/2023 09:59

David Powers

Alrt(Call)/A

203

12/09/2023 09:59

David Powers

Busy(Call)/A

204

12/09/2023 10:37

Lori Dement

Avail

205

12/09/2023 10:37

Lori Dement

Alrt(Call)/A

206

12/09/2023 10:37

Lori Dement

Busy(Call)/A

207

12/09/2023 10:41

Bonnie Bleier

S/In

208

12/09/2023 10:41

Bonnie Bleier

S/In

209

12/09/2023 10:41

Bonnie Bleier

Alrt(Call)/A

210

12/09/2023 10:41

Bonnie Bleier

Busy(Call)/A

211

12/09/2023 10:43

Lori Dement

Avail

212

12/09/2023 10:43

Lori Dement

W/U

213

12/09/2023 10:43

Lori Dement

Avail

214

12/09/2023 10:45

Lori Dement

Alrt(Call)/A

215

12/09/2023 10:45

Lori Dement

Busy(Call)/A

216

12/09/2023 10:45

Bonnie Bleier

Avail

217

12/09/2023 10:45

Bonnie Bleier

W/U

218

12/09/2023 10:45

Bonnie Bleier

Avail

219

12/09/2023 10:51

Lori Dement

Avail

220

12/09/2023 10:51

Lori Dement

W/U

221

12/09/2023 10:51

Lori Dement

Avail

222

12/09/2023 10:52

Lori Dement

Alrt(Call)/A

223

12/09/2023 10:52

Lori Dement

Busy(Call)/A

224

12/09/2023 10:54

Bonnie Bleier

Alrt(Call)/A

225

12/09/2023 11:00

Bonnie Bleier

Busy(Call)/A

226

12/09/2023 11:03

Lori Dement

N/A

227

12/09/2023 11:10

Bonnie Bleier

Avail

228

12/09/2023 11:10

Bonnie Bleier

W/U

229

12/09/2023 11:10

Bonnie Bleier

Avail

230

12/09/2023 11:51

David Powers

Avail

231

12/09/2023 11:51

David Powers

W/U

232

12/09/2023 11:51

David Powers

Avail

233

12/09/2023 11:52

Lori Dement

Alrt(Call)/A

234

12/09/2023 11:52

Lori Dement

Busy(Call)/A

235

12/09/2023 11:55

David Powers

Busy(Call)/A

236

12/09/2023 13:00

Bonnie Bleier

Avail

237

12/09/2023 13:00

Bonnie Bleier

W/U

238

12/09/2023 13:00

Bonnie Bleier

Avail

239

12/09/2023 13:00

Jennifer Leibenguth

N/A

240

12/09/2023 13:07

David Powers

Avail

241

12/09/2023 13:07

David Powers

W/U

242

12/09/2023 13:07

David Powers

Avail

243

12/09/2023 13:08

Lori Dement

Alrt(Call)/A

244

12/09/2023 13:09

Bonnie Bleier

Busy(Call)/A

245

12/09/2023 13:11

David Powers

Alrt(Call)/A

246

12/09/2023 13:11

David Powers

Busy(Call)/A

247

12/09/2023 13:14

Lori Dement

Avail

248

12/09/2023 13:16

Bonnie Bleier

Avail

249

12/09/2023 13:16

Lori Dement

N/A

250

12/09/2023 13:19

Lori Dement

Avail

251

12/09/2023 13:20

David Powers

Avail

252

12/09/2023 13:20

David Powers

W/U

253

12/09/2023 13:20

David Powers

Avail

254

12/09/2023 13:25

Lori Dement

Alrt(Call)/A

255

12/09/2023 13:26

Lori Dement

Busy(Call)/A

256

12/09/2023 13:28

Lori Dement

Avail

257

12/09/2023 13:37

David Powers

Avail

258

12/09/2023 13:42

Bonnie Bleier

Alrt(Call)/A

259

12/09/2023 13:42

Bonnie Bleier

Busy(Call)/A

260

12/09/2023 13:45

Lori Dement

N/A

261

12/09/2023 13:46

Bonnie Bleier

Avail

262

12/09/2023 13:46

Bonnie Bleier

W/U

263

12/09/2023 13:58

David Powers

Avail

264

12/09/2023 16:02

David Powers

Avail

265

12/09/2023 16:04

Marianne Peterson

S/Out

266

12/09/2023 16:04

Marianne Peterson

S/Out

267

12/09/2023 16:04

Marianne Peterson

S/Out

268

12/09/2023 16:04

Marianne Peterson

S/Out

269

12/09/2023 16:59

Bonnie Bleier

Avail

270

12/09/2023 16:59

Jennifer Leibenguth

S/Out

271

12/09/2023 16:59

Jennifer Leibenguth

S/Out

272

12/09/2023 16:59

Jennifer Leibenguth

S/Out

273

12/09/2023 16:59

Jennifer Leibenguth

S/Out

274

12/09/2023 17:29

Bonnie Bleier

Avail

275

12/09/2023 17:29

Bonnie Bleier

W/U

276

12/09/2023 17:29

Bonnie Bleier

Avail

277

12/09/2023 17:30

Lori Dement

S/Out

278

12/09/2023 17:32

David Powers

S/Out

279

12/09/2023 17:32

David Powers

S/Out

280

12/09/2023 17:32

David Powers

S/Out

281

12/09/2023 17:32

David Powers

S/Out

282

12/09/2023 17:32

David Powers

S/Out

283

12/09/2023 17:32

David Powers

S/Out

284

12/09/2023 17:45

Bonnie Bleier

Alrt(Call)/A

285

12/09/2023 18:37

Bonnie Bleier

S/Out

Sheet6

Cell Formulas
Range	Formula
E2:F11	E2	=UNIQUE(HSTACK(INT(A2:A285),B2:B285))
G2	G2	=TAKE(FILTER($A$2:$A$400,(INT(A$2:A$400)=E2)(B$2:B$400=F2)($C$2:$C$400=G$1)),1)
H2	H2	=TAKE(FILTER($A$2:$A$400,(INT(A$2:A$400)=E2)(B$2:B$400=F2)($C$2:$C$400=H$1)),1)
G3:G11	G3	=TAKE(FILTER($A$2:$A$400,(INT(A$2:A$400)=$E3)(B$2:B$400=F3)($C$2:$C$400=G$1)),1)
H3:H11	H3	=TAKE(FILTER($A$2:$A$400,(INT(A$2:A$400)=$E3)(B$2:B$400=F3)($C$2:$C$400=H$1)),1)
Dynamic array formulas.

pitcrew · Sep 29, 2023

Fluff said:
Missed that part, try

Fluff.xlsm
A B C D E F G H
1 Entry Time Agent Name State Chg S/In S/Out
2 11/09/2023 09:01 Jennifer Leibenguth S/In 11/09/2023 Jennifer Leibenguth 11/09/2023 09:01 11/09/2023 17:29
3 11/09/2023 09:01 Jennifer Leibenguth N/A 11/09/2023 Bonnie Bleier #CALC! 11/09/2023 16:01
4 11/09/2023 09:01 Jennifer Leibenguth S/In 11/09/2023 Lori Dement 11/09/2023 09:29 11/09/2023 17:51
5 11/09/2023 09:01 Jennifer Leibenguth S/In 11/09/2023 David Powers 11/09/2023 09:53 11/09/2023 16:57
6 11/09/2023 09:01 Jennifer Leibenguth S/In 11/09/2023 Marianne Peterson #CALC! 11/09/2023 15:00
7 11/09/2023 09:01 Jennifer Leibenguth S/In 12/09/2023 Bonnie Bleier 12/09/2023 09:01 12/09/2023 09:52
8 11/09/2023 09:01 Jennifer Leibenguth S/In 12/09/2023 David Powers 12/09/2023 09:24 12/09/2023 17:32
9 11/09/2023 09:01 Jennifer Leibenguth S/In 12/09/2023 Jennifer Leibenguth 12/09/2023 09:27 12/09/2023 16:59
10 11/09/2023 09:01 Jennifer Leibenguth Avail 12/09/2023 Lori Dement #CALC! 12/09/2023 17:30
11 11/09/2023 09:01 Jennifer Leibenguth Alrt(Call)/A 12/09/2023 Marianne Peterson #CALC! 12/09/2023 16:04
12 11/09/2023 09:01 Jennifer Leibenguth Busy(Call)/A
13 11/09/2023 09:05 Bonnie Bleier Busy(Call)/A
14 11/09/2023 09:11 Jennifer Leibenguth Avail
15 11/09/2023 09:11 Jennifer Leibenguth W/U
16 11/09/2023 09:11 Jennifer Leibenguth Avail
17 11/09/2023 09:13 Bonnie Bleier Avail
18 11/09/2023 09:14 Bonnie Bleier Avail
19 11/09/2023 09:14 Jennifer Leibenguth Alrt(Call)/A
20 11/09/2023 09:15 Jennifer Leibenguth Busy(Call)/A
21 11/09/2023 09:18 Jennifer Leibenguth Avail
22 11/09/2023 09:29 Lori Dement S/In
23 11/09/2023 09:29 Lori Dement N/A
24 11/09/2023 09:29 Lori Dement S/In
25 11/09/2023 09:29 Lori Dement S/In
26 11/09/2023 09:29 Lori Dement S/In
27 11/09/2023 09:29 Lori Dement S/In
28 11/09/2023 09:29 Lori Dement S/In
29 11/09/2023 09:52 Bonnie Bleier Avail
30 11/09/2023 09:53 David Powers S/In
31 11/09/2023 09:53 David Powers N/A
32 11/09/2023 09:53 David Powers S/In
33 11/09/2023 09:53 David Powers S/In
34 11/09/2023 09:53 David Powers S/In
35 11/09/2023 09:53 David Powers S/In
36 11/09/2023 09:53 David Powers S/In
37 11/09/2023 09:54 Jennifer Leibenguth N/A
38 11/09/2023 09:57 Bonnie Bleier Alrt(Call)/A
39 11/09/2023 09:57 Bonnie Bleier Busy(Call)/A
40 11/09/2023 09:57 Jennifer Leibenguth Avail
41 11/09/2023 10:00 Bonnie Bleier Avail
42 11/09/2023 10:00 Bonnie Bleier W/U
43 11/09/2023 11:37 David Powers Alrt(Call)/A
44 11/09/2023 11:37 Lori Dement N/A
45 11/09/2023 11:37 David Powers Busy(Call)/A
46 11/09/2023 11:45 David Powers Avail
47 11/09/2023 11:45 David Powers W/U
48 11/09/2023 11:55 Bonnie Bleier W/U
49 11/09/2023 11:55 Bonnie Bleier Avail
50 11/09/2023 15:00 Marianne Peterson S/Out
51 11/09/2023 15:00 Marianne Peterson S/Out
52 11/09/2023 15:00 Marianne Peterson S/Out
53 11/09/2023 15:00 Marianne Peterson S/Out
54 11/09/2023 15:00 Marianne Peterson S/Out
55 11/09/2023 15:00 Marianne Peterson S/Out
56 11/09/2023 15:00 Marianne Peterson S/Out
57 11/09/2023 15:05 David Powers N/A
58 11/09/2023 15:06 David Powers Avail
59 11/09/2023 15:12 Bonnie Bleier Avail
60 11/09/2023 15:12 Bonnie Bleier W/U
61 11/09/2023 15:12 Bonnie Bleier Avail
62 11/09/2023 15:14 Bonnie Bleier Alrt(Call)/A
63 11/09/2023 15:14 Bonnie Bleier Busy(Call)/A
64 11/09/2023 15:15 Jennifer Leibenguth Avail
65 11/09/2023 15:15 Jennifer Leibenguth W/U
66 11/09/2023 15:15 David Powers Avail
67 11/09/2023 15:15 David Powers W/U
68 11/09/2023 15:15 Jennifer Leibenguth Avail
69 11/09/2023 15:15 David Powers Avail
70 11/09/2023 15:17 Jennifer Leibenguth N/A
71 11/09/2023 15:19 Bonnie Bleier Avail
72 11/09/2023 15:20 Bonnie Bleier Alrt(Call)/A
73 11/09/2023 15:21 Bonnie Bleier Busy(Call)/A
74 11/09/2023 15:21 Jennifer Leibenguth Avail
75 11/09/2023 15:21 Bonnie Bleier Avail
76 11/09/2023 15:32 Jennifer Leibenguth N/A
77 11/09/2023 15:32 Lori Dement Alrt(Call)/A
78 11/09/2023 15:32 Lori Dement Busy(Call)/A
79 11/09/2023 15:37 Lori Dement Avail
80 11/09/2023 15:37 Lori Dement W/U
81 11/09/2023 15:38 Lori Dement Avail
82 11/09/2023 15:46 Bonnie Bleier W/U
83 11/09/2023 15:46 Bonnie Bleier Avail
84 11/09/2023 15:48 Lori Dement Avail
85 11/09/2023 15:48 Lori Dement W/U
86 11/09/2023 15:48 Lori Dement Avail
87 11/09/2023 15:51 Bonnie Bleier Alrt(Call)/A
88 11/09/2023 15:51 Bonnie Bleier Busy(Call)/A
89 11/09/2023 15:57 Lori Dement N/A
90 11/09/2023 15:59 Bonnie Bleier N/A
91 11/09/2023 16:01 Bonnie Bleier S/Out
92 11/09/2023 16:01 Bonnie Bleier S/Out
93 11/09/2023 16:01 Bonnie Bleier S/Out
94 11/09/2023 16:01 Bonnie Bleier S/Out
95 11/09/2023 16:01 Bonnie Bleier S/Out
96 11/09/2023 16:01 Bonnie Bleier S/Out
97 11/09/2023 16:03 David Powers Avail
98 11/09/2023 16:07 David Powers Alrt(Call)/A
99 11/09/2023 16:07 David Powers Busy(Call)/A
100 11/09/2023 16:10 Jennifer Leibenguth Avail
101 11/09/2023 16:13 David Powers Avail
102 11/09/2023 16:13 David Powers W/U
103 11/09/2023 16:13 David Powers Avail
104 11/09/2023 16:17 Jennifer Leibenguth Alrt(Call)/A
105 11/09/2023 16:17 Jennifer Leibenguth Busy(Call)/A
106 11/09/2023 16:20 David Powers Alrt(Call)/A
107 11/09/2023 16:20 David Powers Busy(Call)/A
108 11/09/2023 16:23 Jennifer Leibenguth Avail
109 11/09/2023 16:23 Jennifer Leibenguth W/U
110 11/09/2023 16:23 Jennifer Leibenguth Avail
111 11/09/2023 16:33 Jennifer Leibenguth Alrt(Call)/A
112 11/09/2023 16:33 Jennifer Leibenguth Busy(Call)/A
113 11/09/2023 16:34 David Powers Avail
114 11/09/2023 16:34 David Powers W/U
115 11/09/2023 16:34 David Powers Avail
116 11/09/2023 16:36 David Powers Alrt(Call)/A
117 11/09/2023 16:36 Jennifer Leibenguth Avail
118 11/09/2023 16:36 Jennifer Leibenguth W/U
119 11/09/2023 16:36 David Powers Busy(Call)/A
120 11/09/2023 16:37 Jennifer Leibenguth Avail
121 11/09/2023 16:42 David Powers Avail
122 11/09/2023 16:42 David Powers W/U
123 11/09/2023 16:42 David Powers Avail
124 11/09/2023 16:46 Lori Dement Avail
125 11/09/2023 16:52 Lori Dement Alrt(Call)/A
126 11/09/2023 16:52 Lori Dement Busy(Call)/A
127 11/09/2023 16:52 David Powers N/A
128 11/09/2023 16:53 Jennifer Leibenguth Alrt(Call)/A
129 11/09/2023 16:53 Jennifer Leibenguth Busy(Call)/A
130 11/09/2023 16:57 David Powers S/Out
131 11/09/2023 16:57 David Powers S/Out
132 11/09/2023 16:57 David Powers S/Out
133 11/09/2023 16:57 David Powers S/Out
134 11/09/2023 16:57 David Powers S/Out
135 11/09/2023 16:57 David Powers S/Out
136 11/09/2023 16:57 Jennifer Leibenguth Avail
137 11/09/2023 16:57 Jennifer Leibenguth W/U
138 11/09/2023 17:00 Jennifer Leibenguth Alrt(Call)/A
139 11/09/2023 17:00 Jennifer Leibenguth Busy(Call)/A
140 11/09/2023 17:00 Lori Dement Avail
141 11/09/2023 17:00 Lori Dement W/U
142 11/09/2023 17:01 Lori Dement Avail
143 11/09/2023 17:04 Lori Dement Alrt(Call)/A
144 11/09/2023 17:04 Lori Dement Busy(Call)/A
145 11/09/2023 17:05 Lori Dement Avail
146 11/09/2023 17:05 Lori Dement W/U
147 11/09/2023 17:05 Lori Dement Avail
148 11/09/2023 17:06 Jennifer Leibenguth Avail
149 11/09/2023 17:06 Jennifer Leibenguth W/U
150 11/09/2023 17:24 Lori Dement Avail
151 11/09/2023 17:25 Lori Dement Alrt(Call)/A
152 11/09/2023 17:25 Lori Dement Busy(Call)/A
153 11/09/2023 17:29 Jennifer Leibenguth S/Out
154 11/09/2023 17:29 Jennifer Leibenguth S/Out
155 11/09/2023 17:29 Jennifer Leibenguth S/Out
156 11/09/2023 17:29 Jennifer Leibenguth S/Out
157 11/09/2023 17:43 Lori Dement Avail
158 11/09/2023 17:43 Lori Dement Alrt(Call)/A
159 11/09/2023 17:43 Lori Dement Busy(Call)/A
160 11/09/2023 17:47 Lori Dement N/A
161 11/09/2023 17:50 David Powers S/In
162 11/09/2023 17:50 David Powers N/A
163 11/09/2023 17:50 David Powers S/In
164 11/09/2023 17:50 David Powers S/In
165 11/09/2023 17:51 David Powers Avail
166 11/09/2023 17:51 David Powers Alrt(Call)/A
167 11/09/2023 17:51 David Powers Busy(Call)/A
168 11/09/2023 17:51 Lori Dement S/Out
169 11/09/2023 17:51 Lori Dement S/Out
170 11/09/2023 17:51 Lori Dement S/Out
171 12/09/2023 09:01 Bonnie Bleier S/In
172 12/09/2023 09:01 Bonnie Bleier S/In
173 12/09/2023 09:01 Bonnie Bleier S/In
174 12/09/2023 09:24 David Powers S/In
175 12/09/2023 09:24 David Powers N/A
176 12/09/2023 09:24 David Powers S/In
177 12/09/2023 09:24 David Powers S/In
178 12/09/2023 09:27 Jennifer Leibenguth S/In
179 12/09/2023 09:27 Jennifer Leibenguth N/A
180 12/09/2023 09:27 Jennifer Leibenguth S/In
181 12/09/2023 09:49 Lori Dement Busy(Call)/A
182 12/09/2023 09:50 David Powers Alrt(Call)/A
183 12/09/2023 09:50 David Powers Busy(Call)/A
184 12/09/2023 09:52 Bonnie Bleier S/Out
185 12/09/2023 09:52 Bonnie Bleier S/Out
186 12/09/2023 09:52 Bonnie Bleier S/Out
187 12/09/2023 09:52 Bonnie Bleier S/Out
188 12/09/2023 09:52 David Powers Avail
189 12/09/2023 09:52 David Powers W/U
190 12/09/2023 09:52 David Powers Avail
191 12/09/2023 09:53 David Powers Alrt(Call)/A
192 12/09/2023 09:53 David Powers Busy(Call)/A
193 12/09/2023 09:53 David Powers Avail
194 12/09/2023 09:54 Lori Dement Avail
195 12/09/2023 09:58 David Powers Alrt(Call)/A
196 12/09/2023 09:58 David Powers Busy(Call)/A
197 12/09/2023 09:59 David Powers Avail
198 12/09/2023 09:59 David Powers W/U
199 12/09/2023 09:59 Lori Dement Alrt(Call)/A
200 12/09/2023 09:59 Lori Dement Busy(Call)/A
201 12/09/2023 09:59 David Powers Avail
202 12/09/2023 09:59 David Powers Alrt(Call)/A
203 12/09/2023 09:59 David Powers Busy(Call)/A
204 12/09/2023 10:37 Lori Dement Avail
205 12/09/2023 10:37 Lori Dement Alrt(Call)/A
206 12/09/2023 10:37 Lori Dement Busy(Call)/A
207 12/09/2023 10:41 Bonnie Bleier S/In
208 12/09/2023 10:41 Bonnie Bleier S/In
209 12/09/2023 10:41 Bonnie Bleier Alrt(Call)/A
210 12/09/2023 10:41 Bonnie Bleier Busy(Call)/A
211 12/09/2023 10:43 Lori Dement Avail
212 12/09/2023 10:43 Lori Dement W/U
213 12/09/2023 10:43 Lori Dement Avail
214 12/09/2023 10:45 Lori Dement Alrt(Call)/A
215 12/09/2023 10:45 Lori Dement Busy(Call)/A
216 12/09/2023 10:45 Bonnie Bleier Avail
217 12/09/2023 10:45 Bonnie Bleier W/U
218 12/09/2023 10:45 Bonnie Bleier Avail
219 12/09/2023 10:51 Lori Dement Avail
220 12/09/2023 10:51 Lori Dement W/U
221 12/09/2023 10:51 Lori Dement Avail
222 12/09/2023 10:52 Lori Dement Alrt(Call)/A
223 12/09/2023 10:52 Lori Dement Busy(Call)/A
224 12/09/2023 10:54 Bonnie Bleier Alrt(Call)/A
225 12/09/2023 11:00 Bonnie Bleier Busy(Call)/A
226 12/09/2023 11:03 Lori Dement N/A
227 12/09/2023 11:10 Bonnie Bleier Avail
228 12/09/2023 11:10 Bonnie Bleier W/U
229 12/09/2023 11:10 Bonnie Bleier Avail
230 12/09/2023 11:51 David Powers Avail
231 12/09/2023 11:51 David Powers W/U
232 12/09/2023 11:51 David Powers Avail
233 12/09/2023 11:52 Lori Dement Alrt(Call)/A
234 12/09/2023 11:52 Lori Dement Busy(Call)/A
235 12/09/2023 11:55 David Powers Busy(Call)/A
236 12/09/2023 13:00 Bonnie Bleier Avail
237 12/09/2023 13:00 Bonnie Bleier W/U
238 12/09/2023 13:00 Bonnie Bleier Avail
239 12/09/2023 13:00 Jennifer Leibenguth N/A
240 12/09/2023 13:07 David Powers Avail
241 12/09/2023 13:07 David Powers W/U
242 12/09/2023 13:07 David Powers Avail
243 12/09/2023 13:08 Lori Dement Alrt(Call)/A
244 12/09/2023 13:09 Bonnie Bleier Busy(Call)/A
245 12/09/2023 13:11 David Powers Alrt(Call)/A
246 12/09/2023 13:11 David Powers Busy(Call)/A
247 12/09/2023 13:14 Lori Dement Avail
248 12/09/2023 13:16 Bonnie Bleier Avail
249 12/09/2023 13:16 Lori Dement N/A
250 12/09/2023 13:19 Lori Dement Avail
251 12/09/2023 13:20 David Powers Avail
252 12/09/2023 13:20 David Powers W/U
253 12/09/2023 13:20 David Powers Avail
254 12/09/2023 13:25 Lori Dement Alrt(Call)/A
255 12/09/2023 13:26 Lori Dement Busy(Call)/A
256 12/09/2023 13:28 Lori Dement Avail
257 12/09/2023 13:37 David Powers Avail
258 12/09/2023 13:42 Bonnie Bleier Alrt(Call)/A
259 12/09/2023 13:42 Bonnie Bleier Busy(Call)/A
260 12/09/2023 13:45 Lori Dement N/A
261 12/09/2023 13:46 Bonnie Bleier Avail
262 12/09/2023 13:46 Bonnie Bleier W/U
263 12/09/2023 13:58 David Powers Avail
264 12/09/2023 16:02 David Powers Avail
265 12/09/2023 16:04 Marianne Peterson S/Out
266 12/09/2023 16:04 Marianne Peterson S/Out
267 12/09/2023 16:04 Marianne Peterson S/Out
268 12/09/2023 16:04 Marianne Peterson S/Out
269 12/09/2023 16:59 Bonnie Bleier Avail
270 12/09/2023 16:59 Jennifer Leibenguth S/Out
271 12/09/2023 16:59 Jennifer Leibenguth S/Out
272 12/09/2023 16:59 Jennifer Leibenguth S/Out
273 12/09/2023 16:59 Jennifer Leibenguth S/Out
274 12/09/2023 17:29 Bonnie Bleier Avail
275 12/09/2023 17:29 Bonnie Bleier W/U
276 12/09/2023 17:29 Bonnie Bleier Avail
277 12/09/2023 17:30 Lori Dement S/Out
278 12/09/2023 17:32 David Powers S/Out
279 12/09/2023 17:32 David Powers S/Out
280 12/09/2023 17:32 David Powers S/Out
281 12/09/2023 17:32 David Powers S/Out
282 12/09/2023 17:32 David Powers S/Out
283 12/09/2023 17:32 David Powers S/Out
284 12/09/2023 17:45 Bonnie Bleier Alrt(Call)/A
285 12/09/2023 18:37 Bonnie Bleier S/Out
Sheet6
Cell Formulas
Range Formula
E2:F11 E2 =UNIQUE(HSTACK(INT(A2:A285),B2:B285))
G2 G2 =TAKE(FILTER($A$2:$A$400,(INT(A$2:A$400)=E2)*(B$2:B$400=F2)*($C$2:$C$400=G$1)),1)
H2 H2 =TAKE(FILTER($A$2:$A$400,(INT(A$2:A$400)=E2)*(B$2:B$400=F2)*($C$2:$C$400=H$1)),1)
G3:G11 G3 =TAKE(FILTER($A$2:$A$400,(INT(A$2:A$400)=$E3)*(B$2:B$400=F3)*($C$2:$C$400=G$1)),1)
H3:H11 H3 =TAKE(FILTER($A$2:$A$400,(INT(A$2:A$400)=$E3)*(B$2:B$400=F3)*($C$2:$C$400=H$1)),1)
Dynamic array formulas.

That worked perfectly, thanks you so much for your help! I hope you have a great weekend.

Fluff · Sep 29, 2023

You're welcome & thanks for the feedback.

Tough Data Sheet to get Login/Login dates and times.

pitcrew

New Member

Excel Facts

Fluff

MrExcel MVP, Moderator

pitcrew

New Member

Fluff

MrExcel MVP, Moderator

pitcrew

New Member

Fluff

MrExcel MVP, Moderator

pitcrew

New Member

Fluff

MrExcel MVP, Moderator

Similar threads

Forum statistics

Share this page

Tough Data Sheet to get Login/Login dates and times.

New Member

Excel Facts

MrExcel MVP, Moderator

New Member

MrExcel MVP, Moderator

New Member

MrExcel MVP, Moderator

New Member

MrExcel MVP, Moderator

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock