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
quot;It is a good thing to follow the first law of holes;
if you are in one stop digging.quot; Lord Healeyquot;Mariaquot; gt; wrote in message
...
gt;I have set up an Accounts Receivable worksheet on excel. How do list all
gt;the
gt; customers that have not paid within the month. Is it possible to get the
gt; list
gt; of customers that have not paid in a list format in excel?
- Jul 16 Mon 2007 20:38
How do I identify all the non-paying customers from A/R workseet?
close
全站熱搜
留言列表
發表留言