View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carla Carla is offline
external usenet poster
 
Posts: 78
Default If over 60, then show all detail

I need to know the whole picture for problem customers, not just individual
invoices that are past due.

I have a table that shows details for any invoice with a balance due. It
also specifies inv amt in the appropriate column (current, over 30, over 60,
over 90). I need a formula that will say if any customer has any invoices in
over 60 or over 90 to show ALL detail for customer, not just specific line
items for that customer that are actually over 60 or over 90.

Thank you for your expertise!
Carla