Please help - School Project - Trying to setup function.

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

crosspost: https://www.mrexcel.com/board/thread...ction.1168589/

https://www.excelguru.ca/forums/show...setup-function

Rule 03: Cross-posting Without Telling Us

Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Read this to understand why we ask you to do this.

I have added the crosspost reference for you today. Please comply with this and all our rules in the future

Your "example" in the text does not tally with the sheet. You have given us NO IDEA where/how you want the results displayed.

re-post your sheet showing some manually calculated resutls WHERE you want them to appear. Do not describe in words situations that DO NOT exist in your sheet.

It's still confusing for me.... If X comes before Y... How do you choose X? How do you choose Y?

So for ID 2 there are 4 unique entries... How do you know which one you are choosing to be X? How do you know which one you are choosing to be Y?

You did not add manually calculated expected results to the sheet, as requested.

Please do so this time.

Sorry. I have no idea what you want.

I'm out.

How to know Bread in B3 and Apple in B2, who come first? Base on Start date or End date? Should the results put in E2 downwards?
Try to put your expected results in where they should be, and explain how it is calculated.
Good luck.