# Challenges: check-in / out app

**URL:** <https://community.glideapps.com/t/challenges-check-in-out-app/1501>\
**Category:** Ask for Help\
**Created:** [October 29, 2019, 11:47pm UTC](https://community.glideapps.com/t/challenges-check-in-out-app/1501 "2019-10-29T23:47:01Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [October 30, 2019, 4:22am UTC](https://community.glideapps.com/t/challenges-check-in-out-app/1501/4 "2019-10-30T04:22:19Z")

</div>

This might be something that would help to get the last value for a user:

> [@Time of last post/row by user](https://community.glideapps.com/t/time-of-last-post-row-by-user/1294/10):
>
> @apertur.co Could this be a solution? arrayformula(vlookup(D3:D5,sort({B3:B,A3:A},2,false),2,false) ) vlookup looks up in the left column {B3:B,A3:A} switches columns vlookup looks up the first occurrence sort({B3:B,A3:A},2,false) reverses the order

This contains a piece about using COUNTIF with concatinated values instead of COUNTIFS:

> <https://stackoverflow.com/questions/29203247/using-countifs-in-an-array-formula>

---

_[View the full topic](https://community.glideapps.com/t/challenges-check-in-out-app/1501)._