Enigma909
New member
- Joined
- Apr 20, 2021
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 365
Hello I am writing a school project and I am having trouble setting up a function.
I have some unique ID’s in the first column, different names in the second column, start dates in the third column and end dates in the fourth column.
I am trying to create a function that says for unique ID “1”, if name “A” comes before name “B” what is the difference between end date “A” and start date “B”. I hope this makes sense.
I was thinking about using an IF AND function but I can’t make it work.
An example could be: For ID “1” if “Apple” appears before “Pears” what is the difference between 01.02.19 and 04.02.19.
The function should return: 3 days in a new column, and it should then continue to the next unique “ID” which is “2”.
I really hope that you can help me.
Best regards
I have some unique ID’s in the first column, different names in the second column, start dates in the third column and end dates in the fourth column.
I am trying to create a function that says for unique ID “1”, if name “A” comes before name “B” what is the difference between end date “A” and start date “B”. I hope this makes sense.
I was thinking about using an IF AND function but I can’t make it work.
An example could be: For ID “1” if “Apple” appears before “Pears” what is the difference between 01.02.19 and 04.02.19.
The function should return: 3 days in a new column, and it should then continue to the next unique “ID” which is “2”.
I really hope that you can help me.
Best regards