Cheers All, I have about 5 assets (Laptops) that get checked-out and checked-in. I am trying to see how many devices are checked out on a day-to-day basis. The mixed data in the checked-in/out column and the non sequential dates are really throwing me off. Any thoughts are welcome.

Thanks,
David

Attached Files

20180226_1341.xlsx (28.9 KB, 11 views)