Forum Discussion
Need help with Excel Formula
tviss64 Why not manually indicate in your simplified example what you would expect to see in each of Sheets 3, 4 and 5. Including the colours and the logic behind it.
Riny_van_EekelenGood suggestion. I have added the example in the attached file.
tviss64 Great! I'm on my way out now. Gladly leave it to someone else her to resolve. If not, I'll get back to you later.
Riny_van_EekelenThank you!
tviss64 This is something that would fit Power Query (PQ) very well. Especially if you have to do this regularly and on larger data sets. Created two structured tables from the Original and New data. Queried them and did three merges that load the desired records back to your sheets 3, 4 and 5. See attached workbook.
Are you familiar with PQ? If not, the site in the link below would be a good place to start.