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
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