How do I identify all the non-paying customers from A/R workseet?

I have set up an Accounts Receivable worksheet on excel. How do list all the
customers that have not paid within the month. Is it possible to get the list
of customers that have not paid in a list format in excel?

How do you identify those that have paid? Assume you would put paid next to
them, then just apply autofilter, from dropdown select custom and not equal
to paid (or whatever you use to indicate payment)

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Maria" <[email protected]> wrote in message
news:[email protected]...
>I have set up an Accounts Receivable worksheet on excel. How do list all
>the
> customers that have not paid within the month. Is it possible to get the
> list
> of customers that have not paid in a list format in excel?