Hi all,

I'm looking at setting up a small lending system in order to keep a live log of who is taking out access cards, and how long they are holding them for.

As I'm only really looking at one table, I understand that Excel is the better software for this, however I'm quite keen to have the information displayed so that outstanding borrowers are featured predominantly. Imagine that record #19 hasn't returned theirs, but the most recent record is #102 and therefore #19 has disappeared from view.

I'm more than happy to do the leg work myself, but I'm just looking for a few pointers to know where to begin. What kind of formulas I should be using etc etc.

Cheers,
RN.