Hello guys,
I am currently facing the following problem.
I have three tables:
Table 1: All employees
Table 2: All trainings available
Table 3: Who has already taken part in which training.
Now I would like to have a fourth table in which there is an entry for each employee and each training in which he has not yet participated.
Example data and the desired result are linked below.
Thanks in advance!
Hi RH,
Welcome to our forum. Can you please upload an Excel file containing your examples to save us having to manually enter it into a worksheet in order to answer your questions?
Many thanks,
Mynda
Hello Mynda,
yes of course! I'll attach the file.
Greetings,
R
Hi R,
Thanks for the file. Please see solution attached - the final query 'Merge1' matches your desired result.
Mynda
Hey Mynda,
thank you for your efforts!
Unfortunately it doesn't work for me, because you're using the result table in your merge, which I usually don't know.
If you take a look at my file again, you can only use the tabs "Team", "Training", and "Done".
The tab open should be the result.
Greetings,
R
Hi R,
Unfortunately you weren't clear and as there was no table or sheet labelled 'desired result' I incorrectly made the assumption that the sheet called 'Done' was what you expected to be the desired result.
Please see attached.
Mynda
Perfect! Thank you so much!!
