Create check in and check out in Excel - Excel Tips and Tricks

preview_player
Показать описание
Learn how to create check in and check out in Excel.

Here are the steps outlined in my video.

Running List
=FILTER(B5:B27,COUNTIF(E5:E27,B5:B27)<1)

Create Drop Down
1) Select cell E5:E27
2) Data ~ Data Tools ~ Data Validation
3) Setting tabs
4) List
5) Source set "=$D$5#"
6) OK

#shorts #short #shortvideo #fyp #excel #microsoft #tiktok #fypシ
Рекомендации по теме
Комментарии
Автор

Why wouldn’t you put a 1 next to names to be checked in and create the non checked in list based on those without the 1 ? Otherwise you’re asking for spelling mistakes to break it

defaultHandle
join shbcf.ru