Log In
Register
Home
Active Member
March 21, 2019
Offline
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!
July 16, 2010
Offline
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
Active Member
March 21, 2019
Offline
Hello Mynda,
yes of course! I'll attach the file.
Greetings,
R
July 16, 2010
Offline
Hi R,
Thanks for the file. Please see solution attached - the final query 'Merge1' matches your desired result.
Mynda
Active Member
March 21, 2019
Offline
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
July 16, 2010
Offline
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
1 Guest(s)
