• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Extract list of late deliveries

Pierre

Member
Hello,
I have a list of people with delivery dates, customers and information if payment is confirmed. I am looking for a formula to extract from this list a list of deliveries which are late (meaning the delivery date was schedule before the date of the day) AND payment is confirmed. I put in the Excel file the result I'm looking for.

I think that it should be done with an array formula, but I'm not very good with them....

Any help will be welcome :)
 

Attachments

  • extract_list.xlsx
    10.4 KB · Views: 8
Pierre
Your: the delivery date was schedule before the date of the day
Order's C-column has Delivery date ... where is the date of the day data?
 
Pierre
You should reread Forum Rules:
You seems to missed Cross-posting ... totally.
 
Back
Top